Re: PostgreSQL Developer Best Practices

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: PostgreSQL Developer Best Practices
Дата
Msg-id CANu8FixjTwQ5+ip2EtxrzxifqyQRWaL0h2=yC46bd3CzD+8zzg@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL Developer Best Practices  (Melvin Davidson <melvin6925@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Adam Brusselback
Дата:
Сообщение: Re: PostgreSQL Developer Best Practices
Следующее
От: David Kerr
Дата:
Сообщение: Why does splitting $PGDATA and xlog yield a performance benefit?