PostgreSQL Developer Best Practices

From: Marc Munro <marc(dot)munro(at)gmail(dot)com>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL Developer Best Practices
Date: 2015-08-25 16:33:28
Message-ID: 1440520408.12291.29.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2015-08-25 16:38:44 Re: PostgreSQL Developer Best Practices
Previous Message David G. Johnston 2015-08-25 16:23:39 Re: PostgreSQL Developer Best Practices