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

From Melvin Davidson
Subject Re: PostgreSQL Developer Best Practices
Date
Msg-id CANu8FixjTwQ5+ip2EtxrzxifqyQRWaL0h2=yC46bd3CzD+8zzg@mail.gmail.com
Whole thread Raw
In response to PostgreSQL Developer Best Practices  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Consistency in naming convention.

Good suggestion!

On Tue, Aug 25, 2015 at 12:33 PM, Marc Munro <marc.munro@gmail.com> wrote:
On Sat, 2015-08-22 at 15:15 +0000, Melvin Davidson wrote:

> I've been searching for a "PostgreSQL Developer Best Practices" with not
> much luck,
> so I've started my own. At the risk of stirring up a storm of controversy,
> I would appreciate additional suggestions and feedback.
>

You might add: Create all relation names as plurals.

Or, if your site uses predominantly singular names, make that the
standard.  Consistency within the site is more important than any
dogmatic belief about whether singular or plural forms is better.  If
you don't put it in the standard, someone will eventually create tables
with names that don't gel with everything else.

__
Marc






--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: PostgreSQL Developer Best Practices
Next
From: David Kerr
Date:
Subject: Why does splitting $PGDATA and xlog yield a performance benefit?