MS SQL? Ugh, maybe we should just tear out the DB abstraction layer and use Excel spreadsheets instead.<br><br>/me would rather do that than try to use MS SQL for -anything-<br><br>=P<br clear="all">-----<br>Cameron Eagans<br>
Owner, Black Storms Studios, LLC<br><a href="http://www.blackstormsstudios.com">http://www.blackstormsstudios.com</a><br>
<br><br><div class="gmail_quote">On Fri, Aug 21, 2009 at 10:53 AM, Paolo Mainardi <span dir="ltr"><<a href="mailto:paolomainardi@gmail.com">paolomainardi@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
:D <br><br>And we don't want talk about MS SQL Server ? <br><div><div></div><div class="h5"><br><div class="gmail_quote">On Fri, Aug 21, 2009 at 5:54 PM, Pierre Rineau <span dir="ltr"><<a href="mailto:pierre.rineau@makina-corpus.com" target="_blank">pierre.rineau@makina-corpus.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">The real issue is using MySQL. PostgreSQL is a way better in many<br>
aspects. And it does understand standard SQL, better than MySQL.<br>
<br>
War launched!<br>
<div><div></div><div><br>
On Fri, 2009-08-21 at 13:42 +0200, Jean-Michel Pouré wrote:<br>
> Dear friends,<br>
><br>
> Just a quick note that I added some information in the manual:<br>
> Developing Drupal using PostgreSQL:<br>
> <a href="http://drupal.org/node/338676" target="_blank">http://drupal.org/node/338676</a><br>
><br>
> Especially, "Guidelines for writing MySQL and PostgreSQL compliant SQL":<br>
> <a href="http://drupal.org/node/555514" target="_blank">http://drupal.org/node/555514</a><br>
><br>
> This page lists major differences between MySQL and PostgreSQL syntax.<br>
><br>
> Some issues can be fixed in D7 (some may already as I did not follow<br>
> development). I saw compatibility functions around. Some automatic casts<br>
> may be added also in D7 PostgreSQL schema. If this was done, please<br>
> inform me and I will update the pages or update them yourself.<br>
><br>
> Some need fixing in PostgreSQL. All issues require attention from<br>
> developers.<br>
><br>
> Would it be possible to review <a href="http://drupal.org/node/555514" target="_blank">http://drupal.org/node/555514</a><br>
> to make sure anyone agrees on the standard SQL to use for both MySQL and<br>
> PostgreSQL.<br>
><br>
> When it is done, I will contact PostgreSQL hackers to ask for<br>
> modifications in PostgreSQL core. Some modifications seem to be in the<br>
> scope of possibility.<br>
><br>
> Besides, as stated before, I think we would gain to flag minimal<br>
> PostgreSQL version to 8.4 to benefit from PostgreSQL 8.4 new versions<br>
> and from a better compatibility with Drupal.<br>
><br>
> PostgreSQL new stable release is PostgreSQL 8.4, even if Debian flags it<br>
> as unstable. I could upgrade some 500.000 pages sites to PostgreSQL 8.4<br>
> without running into a single problem. SO IMHO let us not stick to an<br>
> old PG version.<br>
><br>
> This is a minor issue, please focus on <a href="http://drupal.org/node/555514" target="_blank">http://drupal.org/node/555514</a><br>
><br>
> Kind regards,<br>
> Jean-Michel<br>
<br>
</div></div></blockquote></div><br><br clear="all"><br></div></div><font color="#888888">-- <br>Paolo Mainardi<br><br>CTO Twinbit<br>Blog: <a href="http://www.paolomainardi.com" target="_blank">http://www.paolomainardi.com</a><br>
<br>-- Please consider the environment before printing this email --<br>
</font></blockquote></div><br>