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

[Khalid Baheyeldin]

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