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

[Cameron Eagans]

MS SQL? Ugh, maybe we should just tear out the DB abstraction layer and use
Excel spreadsheets instead.

/me would rather do that than try to use MS SQL for -anything-

=P
-----
Cameron Eagans
Owner, Black Storms Studios, LLC
http://www.blackstormsstudios.com


On Fri, Aug 21, 2009 at 10:53 AM, Paolo Mainardi <paolomainardi at gmail.com>wrote:

> :D
>
> And we don't want talk about MS SQL Server ?
>
> On Fri, Aug 21, 2009 at 5:54 PM, 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
>>
>>
>
>
> --
> Paolo Mainardi
>
> CTO Twinbit
> Blog: http://www.paolomainardi.com
>
> -- Please consider the environment before printing this email --
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.drupal.org/pipermail/development/attachments/20090821/9c9d1141/attachment.htm>