Re: PostgreSQL Developer Best Practices

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: PostgreSQL Developer Best Practices
Дата
Msg-id CANu8Fix-zvJx5oHUh4ga_YXGOHhgWZD+NETQ_v0pfa_NqYTqTA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Developer Best Practices  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Список pgsql-general
Thank you to all that contributed to this thread. I now have about a dozen guidelines
I would like to share. However, since a few individuals felt it was more of an
opportunity to prove or disprove certain theories, rather than just contribute additional
good practices, I will not be posting them directly to this thread. Rather, if anyone  is
interested in obtaining a copy, please just send me a request to my direct email and I
will gladly reply back with a copy.
   
Know that these are general guidelines. If you disagree with any of them, then you
are free to change them to suit you specific requirements. Just please do not start
another thread to debate the merits or disadvantages of them. If it's more important
to prove that you are right rather than contribute to help others, then you are doing
neither.


On Wed, Aug 26, 2015 at 3:13 PM, Gavin Flower <GavinFlower@archidevsys.co.nz> wrote:
On 27/08/15 06:59, Raymond O'Donnell wrote:
On 26/08/2015 19:54, Gavin Flower wrote:
On 27/08/15 00:03, Vincent de Phily wrote:
On Wednesday 26 August 2015 10:27:04 Gavin Flower wrote:
Actually I would suggest standardising on singular names, not JUST
because that this the standard I prefer!  :-)

But (also) because:

   1. Singular words tend to be shorter

   2. plurals are more ambiguous wrt spelling

   3. there other good reasons, that I've forgotten for now :-(
      (but I remember having them!!!)
Oh, so you name your tables 'fish' and 'crow' instead of 'school' and
'murder' ? Such wasted opportunities :p

???
A school of fish and a murder of crows... wonderfully evocative
collective nouns.

Ray.


Hmm...

Reminds me about a story I was told where a programmer had used names of his favourite footballers as labels in an assembler program!  :-)


-Gavin




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



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

В списке pgsql-general по дате отправления:

Предыдущее
От: Martín Marqués
Дата:
Сообщение: Re: Slave promotion problem...
Следующее
От: marin@kset.org
Дата:
Сообщение: Re: Slave promotion problem...