Re: PostgreSQL Developer Best Practices

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(at)archidevsys(dot)co(dot)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(at)postgresql(dot)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.