Re: Stupid Database Tricks

From: Cimode <cimode_at_hotmail.com>
Date: 23 May 2007 01:40:13 -0700
Message-ID: <1179909613.476611.136500_at_h2g2000hsg.googlegroups.com>

On May 23, 9:16 am, hasta..._at_hotmail.com wrote:
> On 22 mai, 22:48, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:
>
>
>
> > Every table will have a numeric id column, and this
> > column will be the primary key.
>
> Dear Bob,
>
> I'm pretty new to this group, and thus not aware
> of the previous discussions on this subject.
> Please pardon what could be a FAQ.
>
> I am of the opinion that a table modeling
> things out there in the "real world" should
> have a synthesized primary key column,
> mainly because the mapping between the
> database row and the "real" thing is usually
> pretty complicated, or turns out to be, sooner
> or later.
>
> That primary key should never be shown to
> the user.
>
> Of course, the rule does not apply to all relations.
>
> If this is the position you think is a stupid trick,
> I would be very grateful to have a reference
> explaining why it is a mistake.
>
> Thanks much for your time
>
> --- Raoul

The explanation is in the subject. Read it carefully and you will understand what it's all about.

Regards... Received on Wed May 23 2007 - 10:40:13 CEST