Re: PostgreSQL Developer Best Practices - Mailing list pgsql-general

From CaT
Subject Re: PostgreSQL Developer Best Practices
Date
Msg-id 20150825022320.GI5128@zip.com.au
Whole thread Raw
In response to Re: PostgreSQL Developer Best Practices  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
On Mon, Aug 24, 2015 at 08:53:43PM -0400, Melvin Davidson wrote:
> You are right, he was probably talking about FK's. I was just so frustrated
> about people insisting that using "ID" as the primary key in every table is
> a "good" idea,
> I didn't bother to reply previously. I stand firm on my belief that the
> primary key should be something meaningful and NOT "id" just for the sake
> of having a unique numeric key.

I think there is a case to be made for pragmatism. Perhaps you should
split your points up into "ideal" and "pragmatic" requirements. ie you
should aim for the "ideal" but, with good justification, "pragmatic"
will be acceptable.

Get those doing the work to think about their decisions.

--
  "A search of his car uncovered pornography, a homemade sex aid, women's
  stockings and a Jack Russell terrier."
    - http://www.dailytelegraph.com.au/news/wacky/indeed/story-e6frev20-1111118083480


pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: PostgreSQL Developer Best Practices
Next
From: "David G. Johnston"
Date:
Subject: Re: PostgreSQL Developer Best Practices