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
