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

[Khalid Baheyeldin]

Joke taken.

But I was serious.

The recurring problem with PostgreSQL that we, as a community, have
is that we get people that help for a little while and then disappear. No
one who uses
PostgreSQL on large site help on a regular basis to make sure that the
future is safe
with them. We then get the preaching, very similar to yours, and then not
much, until
the following cycle. The new DB TNG API makes things better, but it does not
address
the scalability issues and speed when Drupal meets PostgreSQL.

On Fri, Aug 21, 2009 at 8:43 PM, Pierre Rineau <
pierre.rineau at makina-corpus.com> wrote:

> 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
>
>


-- 
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.drupal.org/pipermail/development/attachments/20090821/abd429d0/attachment.htm>