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

From Melvin Davidson
Subject Re: PostgreSQL Developer Best Practices
Date
Msg-id CANu8Fix-zvJx5oHUh4ga_YXGOHhgWZD+NETQ_v0pfa_NqYTqTA@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Developer Best Practices  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List 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 by date:

Previous
From: Martín Marqués
Date:
Subject: Re: Slave promotion problem...
Next
From: marin@kset.org
Date:
Subject: Re: Slave promotion problem...