Welcome to the Lounge

1-Nov-21 2:40

The way spirit is mixed with drug I gather. (6)

The way = St
spirit = rum
drug = e
mixed (anag)

Gather = Muster

"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP

OriginalGriff1-Nov-21 2:43

OriginalGriff

1-Nov-21 2:43

I figured "Spirit" was "GIN" or "RUM", and "Drug" was "E", but I missed "ST" ... Sigh | :sigh:

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

pkfox1-Nov-21 2:55

1-Nov-21 2:55

It was a bit hard for a Monday Sniff | :^)

"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP

Richard Andrew x641-Nov-21 5:31

Richard Andrew x64

1-Nov-21 5:31

How does "drug" translate to "E"?

The difficult we do right away...
...the impossible takes slightly longer.

pkfox1-Nov-21 5:52

1-Nov-21 5:52

Ecstasy was commonly known as E

"Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP

DRHuff1-Nov-21 6:28

DRHuff

1-Nov-21 6:28

Commonly?!?!?!?!?!?

If you can't laugh at yourself - ask me and I will do it for you.

pkfox1-Nov-21 6:40

1-Nov-21 6:40

Yea even OG knew it Big Grin | :-D

- well it was in the UK anyway

Thought of the day

Jörgen Andersson1-Nov-21 2:38

Jörgen Andersson

1-Nov-21 2:38

We have entered November.
Mariah Carey is defrosting as we speak.

Wrong is evil and must be defeated. - Jeff Ello

Re: Thought of the day

OriginalGriff1-Nov-21 2:45

OriginalGriff

1-Nov-21 2:45

Quick! Shove her back in the freezer and wind the temperature down as far as it'll go!

Re: Thought of the day

megaadam1-Nov-21 5:23

megaadam

1-Nov-21 5:23

Did you mean Thought of the Month ?

"If we don't change direction, we'll end up where we're going"

Re: Thought of the day

PIEBALDconsult1-Nov-21 6:09

PIEBALDconsult

1-Nov-21 6:09

That attempt at humor is a real turkey.

Normalization

Eddy Vluggen1-Nov-21 2:24

1-Nov-21 2:24

How many here normalize their databases?

Bastard Programmer from Hell Suspicious | :suss:

"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Jörgen Andersson1-Nov-21 2:31

Jörgen Andersson

1-Nov-21 2:31

If I create it, yes.
If it's inherited, maybe.

But you should probably have asked to what form.
I personally go for at least third, but usually not up to fifth. It depends on purpose.

Wrong is evil and must be defeated. - Jeff Ello

Eddy Vluggen1-Nov-21 7:00

1-Nov-21 7:00

Jörgen Andersson wrote:
But you should probably have asked to what form.

If I need to ask that, then the answer is that there's usually no normalization.

Jörgen Andersson wrote:
I personally go for at least third, but usually not up to fifth. It depends on purpose.

So it depends on purpose? Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

obermd1-Nov-21 3:26

obermd

1-Nov-21 3:26

Yes, but usually no further than third level. For really small databases the answer is usually not, especially if I inherited the structure.

Gaston Verelst1-Nov-21 3:44

Gaston Verelst

1-Nov-21 3:44

I normalize until 3rd NF.
Maybe I'll have some denormalized tables for quick access. But I only do that when performance is not good, and I can't find another problem. That is, no premature optimizations.

Check out my blog at http://msdev.pro/

honey the codewitch1-Nov-21 3:58

honey the codewitch

1-Nov-21 3:58

Looking it up (i had to) it looks like I typically use 3NF.

Real programmers use butterflies

Eddy Vluggen1-Nov-21 7:05

1-Nov-21 7:05

honey the codewitch wrote:
Looking it up (i had to)

You'd do it on instinct, with butterflies Cool | :cool:

Bastard Programmer from Hell Suspicious | :suss:

"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

honey the codewitch1-Nov-21 7:13

honey the codewitch

1-Nov-21 7:13

I do. That's why I had to look it up. I never learned it formally. I just learned "construct a database in a way that maintains integrity and is sane enough for the application to survive for awhile"

Real programmers use butterflies

Eddy Vluggen1-Nov-21 7:49

1-Nov-21 7:49

honey the codewitch wrote:
I do. That's why I had to look it up. I never learned it formally.

It does sound like I'm attacking. My apologies.

honey the codewitch wrote:
construct a database in a way that maintains integrity

You'd laugh and go "that's soo obvious".

Bastard Programmer from Hell Suspicious | :suss:

"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

honey the codewitch1-Nov-21 7:55

honey the codewitch

1-Nov-21 7:55

I didn't take it as an attack, no worries. I figured I just needed to clarify.

I learned DBs in the .com boom days when it was a free for all. I attempted to impose some order on the mess. All I got for my efforts typically was put in charge of databases - something i didn't want to be in charge of.

And then there was the time when I worked with a self taught developer who built out an entire ecommerce platform, front and back end, including a jquery-like (but *not jquery Unsure | :~

) engine for the front end. Rather than doing JOINs in the database he was doing them in PHP on the webserver.

I taught him SQL. Then I quit.

Real programmers use butterflies

ElectronProgrammer2-Nov-21 3:56

ElectronProgrammer

2-Nov-21 3:56

honey the codewitch wrote:
Rather than doing JOINs in the database he was doing them in PHP on the webserver

I had a colleague like that once. He was transferring two 100G entries tables (+-50 columns each) to PHP to do joins using for loops. It was killing the server and taking almost a week to process.

The boss only noticed when he requested a new, more powerful server (our server was brand new). Boss told me to converted it to SQL and it started taking less than an hour to do the same join Poke tongue | ;-P

That colleague quit the project soon after that.

Daniel Pfeffer2-Nov-21 7:17

Daniel Pfeffer

2-Nov-21 7:17

ElectronProgrammer wrote:
That colleague quit the project soon after that.

Did he fall, or was he pushed? $Shucks | :-\$

Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.

ElectronProgrammer2-Nov-21 10:09

ElectronProgrammer

2-Nov-21 10:09

He fell. It wasn't his only mistake. I tried to give him an hand but he took ~~the arm~~ to harm (he had a PhD and I had a licenciate degree*). I would rather have him there than ending overworked and underpaid as I did. I guess the corporate reality train was to heavy for him Sigh | :sigh:

* That degree is one below masters and one above bachelor in pre-bologna process which was my case