From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Melvin Davidson <melvin6925(at)gmail(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | John Turner <jjturner(at)energi(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org>, Ray Cote <rgacote(at)appropriatesolutions(dot)com> |
Subject: | Re: PostgreSQL Developer Best Practices |
Date: | 2015-08-24 16:40:09 |
Message-ID: | 55DB48E9.5050104@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 08/24/2015 09:34 AM, Melvin Davidson wrote:
> And again, I am talking about _database_ design, not Web apps. Letting
> Web developers design a database to work with their app, is a very,
> Very, VERY bad idea.
Again this is not restricted to Web apps. Anything that touches a
database via an ORM is fair game.
> It is far better to let DBA's and "database develeopers" design a good
> database, then to let those apps mold a db into a non-optimum design.
Aah, the perfect world I do not live in.
>
> On Mon, Aug 24, 2015 at 12:26 PM, Joshua D. Drake <jd(at)commandprompt(dot)com
> <mailto:jd(at)commandprompt(dot)com>> wrote:
>
> On 08/24/2015 08:56 AM, Melvin Davidson wrote:
>
> >The "serial" key is the default primary key amongst every
> single web
> development environment in existence.
>
> Methinks thou doest take too much for granted.
>
> Yes, serial has it's purpose, but I sincerely doubt it is "the
> default
> primary key amongst every single web development environment in
> existence"
> I am not sure where you get your stats from. Probably you are
> referring
> to "Ruby on Rails". IMHO,
>
>
> Rails
> Anything that uses Hibernate (Java)
> Django
> Every PHP framework
> Pyramid
> Anything that uses sql-alchemy
>
> I can go on for miles with this. It is true that a lot of these
> support non-serial keys. It is also true that is not the default.
>
>
> JD
>
>
> --
> Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
> <tel:503-667-4564>
> PostgreSQL Centered full stack support, consulting and development.
> Announcing "I'm offended" is basically telling the world you can't
> control your own emotions, so everyone else should do it for you.
>
>
>
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2015-08-24 16:40:37 | Re: PostgreSQL Developer Best Practices |
Previous Message | Melvin Davidson | 2015-08-24 16:34:15 | Re: PostgreSQL Developer Best Practices |