[development] Request to review Guidelines for writing MySQL and PostgreSQL compliant SQL

[Pierre Rineau]

This was a joke :) I really don't like MySQL but the fact is it exists
so I won't burn in useless flame wars :)

I will go to issue queue as soon as I have some time to do it, I
currently just have submited patches to make the DataSync module work
with PostgreSQL, I really do help the community, but just bit by bit.

I did not mean to harm :)

On Fri, 2009-08-21 at 14:47 -0400, Khalid Baheyeldin wrote:
> Pierre R
> 
> We get this every now and then: endless preaching about PostgreSQL
> and how it is a real DB and MySQL isn't, how it is free and not
> controlled
> by a company, yadda yadda ...
> 
> What we don't get is people passionate enough about it to be involved
> with core enough to make sure everything works under PostgreSQL just
> as well as MySQL.
> 
> Yes, I am aware of a few who are envolved, but they are not the ones
> who 
> preach the virtues of PostgreSQL on the lists, and they are mostly
> dual
> users for MySQL, not pure PostgreSQL users.
> 
> So, to this group, please go to the issue queue and help with
> PostgreSQL.
> We are sold on the virtues, but short of hands ...
> 
> On Fri, Aug 21, 2009 at 11:54 AM, Pierre Rineau
> <pierre.rineau at makina-corpus.com> wrote:
>         The real issue is using MySQL. PostgreSQL is a way better in
>         many
>         aspects. And it does understand standard SQL, better than
>         MySQL.
>         
>         War launched!
>         
>         
>         On Fri, 2009-08-21 at 13:42 +0200, Jean-Michel Pouré wrote:
>         > Dear friends,
>         >
>         > Just a quick note that I added some information in the
>         manual:
>         > Developing Drupal using PostgreSQL:
>         > http://drupal.org/node/338676
>         >
>         > Especially, "Guidelines for writing MySQL and PostgreSQL
>         compliant SQL":
>         > http://drupal.org/node/555514
>         >
>         > This page lists major differences between MySQL and
>         PostgreSQL syntax.
>         >
>         > Some issues can be fixed in D7 (some may already as I did
>         not follow
>         > development). I saw compatibility functions around. Some
>         automatic casts
>         > may be added also in D7 PostgreSQL schema. If this was done,
>         please
>         > inform me and I will update the pages or update them
>         yourself.
>         >
>         > Some need fixing in PostgreSQL. All issues require attention
>         from
>         > developers.
>         >
>         > Would it be possible to review http://drupal.org/node/555514
>         > to make sure anyone agrees on the standard SQL to use for
>         both MySQL and
>         > PostgreSQL.
>         >
>         > When it is done, I will contact PostgreSQL hackers to ask
>         for
>         > modifications in PostgreSQL core. Some modifications seem to
>         be in the
>         > scope of possibility.
>         >
>         > Besides, as stated before, I think we would gain to flag
>         minimal
>         > PostgreSQL version to 8.4 to benefit from PostgreSQL 8.4 new
>         versions
>         > and from a better compatibility with Drupal.
>         >
>         > PostgreSQL new stable release is PostgreSQL 8.4, even if
>         Debian flags it
>         > as unstable. I could upgrade some 500.000 pages sites to
>         PostgreSQL 8.4
>         > without running into a single problem. SO IMHO let us not
>         stick to an
>         > old PG version.
>         >
>         > This is a minor issue, please focus on
>         http://drupal.org/node/555514
>         >
>         > Kind regards,
>         > Jean-Michel
>         
>         
> 
> 
> 
> -- 
> Khalid M. Baheyeldin
> 2bits.com, Inc.
> http://2bits.com
> Drupal optimization, development, customization and consulting.
> Simplicity is prerequisite for reliability. --  Edsger W.Dijkstra
> Simplicity is the ultimate sophistication. --   Leonardo da Vinci