[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] PostgreSQL Developer Best Practices
From: Melvin Davidson <melvin6925 () gmail ! com>
Date: 2015-08-31 13:16:34
Message-ID: CANu8Fix-zvJx5oHUh4ga_YXGOHhgWZD+NETQ_v0pfa_NqYTqTA () mail ! gmail ! com
[Download RAW message or body]
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.
[Attachment #3 (text/html)]
<div dir="ltr">Thank you to all that contributed to this thread. I now have about a \
dozen guidelines <br>I would like to share. However, since a few individuals felt it \
was more of an <br>opportunity to prove or disprove certain theories, rather than \
just contribute additional <br>good practices, I will not be posting them directly to \
this thread. Rather, if anyone is <br>interested in obtaining a copy, please just \
send me a request to my direct email and I <br>will gladly reply back with a \
copy.<br> <br>Know that these are general guidelines. If you disagree with any \
of them, then you <br>are free to change them to suit you specific requirements. Just \
please do not start <br>another thread to debate the merits or disadvantages of them. \
If it's more important <br>to prove that you are right rather than contribute to \
help others, then you are doing <br>neither.<br><br></div><div \
class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 26, 2015 at 3:13 PM, \
Gavin Flower <span dir="ltr"><<a href="mailto:GavinFlower@archidevsys.co.nz" \
target="_blank">GavinFlower@archidevsys.co.nz</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><span class="">On 27/08/15 06:59, Raymond O'Donnell \
wrote:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"> On 26/08/2015 19:54, Gavin Flower wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> On 27/08/15 00:03, Vincent de Phily wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> On Wednesday 26 August 2015 10:27:04 Gavin Flower wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> Actually I would suggest standardising on singular names, \
not JUST<br> because that this the standard I prefer! :-)<br>
<br>
But (also) because:<br>
<br>
1. Singular words tend to be shorter<br>
<br>
2. plurals are more ambiguous wrt spelling<br>
<br>
3. there other good reasons, that I've forgotten for now :-(<br>
(but I remember having them!!!)<br>
</blockquote>
Oh, so you name your tables 'fish' and 'crow' instead of \
'school' and<br> 'murder' ? Such wasted opportunities :p<br>
<br>
</blockquote>
???<br>
</blockquote>
A school of fish and a murder of crows... wonderfully evocative<br>
collective nouns.<br>
<br>
Ray.<br>
<br>
<br>
</blockquote></span>
Hmm...<br>
<br>
Reminds me about a story I was told where a programmer had used names of his \
favourite footballers as labels in an assembler program! :-)<span \
class="HOEnZb"><font color="#888888"><br> <br>
<br>
-Gavin</font></span><div class="HOEnZb"><div class="h5"><br>
<br>
<br>
<br>
-- <br>
Sent via pgsql-general mailing list (<a href="mailto:pgsql-general@postgresql.org" \
target="_blank">pgsql-general@postgresql.org</a>)<br> To make changes to your \
subscription:<br> <a href="http://www.postgresql.org/mailpref/pgsql-general" \
rel="noreferrer" target="_blank">http://www.postgresql.org/mailpref/pgsql-general</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><div \
class="gmail_signature"><div dir="ltr"><font size="4"><b><span \
style="font-family:courier new,monospace">Melvin Davidson</span></b></font><br><font \
style="font-weight:bold" size="3"><span style="color:rgb(128,0,255)">I reserve the \
right to fantasize. Whether or not you </span><br style="color:rgb(128,0,255)"> \
<span style="color:rgb(128,0,255)">wish to share my fantasy is entirely up to you. \
</span><img style="color:rgb(128,0,255)" \
src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"></font><br></div></div>
</div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic