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

From Joshua D. Drake
Subject Re: PostgreSQL Developer Best Practices
Date
Msg-id 55DB3C3F.1070501@commandprompt.com
Whole thread Raw
In response to Re: PostgreSQL Developer Best Practices  (John Turner <jjturner@energi.com>)
Responses Re: PostgreSQL Developer Best Practices
List pgsql-general
On 08/24/2015 07:58 AM, John Turner wrote:
> On Mon, 24 Aug 2015 09:15:27 -0400, Ray Cote

>
> Point 9 is well-intentioned, but perhaps needs to be
> clarified/rephrased:  Developers should not be creating production-grade
> tables devoid of well-defined business keys, period. That would be
> regardless of whether they're used as de facto primary keys or simply as
> unique keys.

Although I appreciate your argument, I think we need a little foundation
in reality. The "serial" key is the default primary key amongst every
single web development environment in existence.

We can make an argument within the doc to why that can be bad, but to
state that it is "wrong" is just not going to get you anywhere.

JD


--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.


pgsql-general by date:

Previous
From: John Turner
Date:
Subject: Re: PostgreSQL Developer Best Practices
Next
From: Melvin Davidson
Date:
Subject: Re: PostgreSQL Developer Best Practices