Re: Stupid Database Tricks

Marshall <marshall.spight_at_gmail.com> wrote:

>On May 22, 1:48 pm, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:
>>
>> Every table will have a numeric id column, and this column will be the
>> primary key.
>
>I don't know why, exactly, since it's not like it's the worst one
>mentioned, but that one DRIVES ME CRAZY!
>
>I hear people say this, and I want to say oh, I see: you're
>just the stupidest freaking idiot ever, is that it? Of course
>instead I say something about that being contraindicated.
>
>My extra special favorite: there's a table that's *just* two
>foreign keys to two different tables; a basic join table. The
>pair (key1, key2) is unique of course. And oh yeah, we
>have to add an additional numeric primary key.
>
>Grrrrr.....

     An auto-incrementing numeric primary key, right?

>> For performance, we enforce integrity in the application.

     If it is not too much trouble.

>Aiiieeee!!!

     This episode of Stupid Database Tricks have brought to you by the ninth and fifth letters of the alphabet.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.