Joke taken.<br><br>But I was serious. <br><br>The recurring problem with PostgreSQL that we, as a community, have<br>is that we get people that help for a little while and then disappear. No one who uses<br>PostgreSQL on large site help on a regular basis to make sure that the future is safe<br>
with them. We then get the preaching, very similar to yours, and then not much, until<br>the following cycle. The new DB TNG API makes things better, but it does not address<br>the scalability issues and speed when Drupal meets PostgreSQL.<br>
<br><div class="gmail_quote">On Fri, Aug 21, 2009 at 8:43 PM, Pierre Rineau <span dir="ltr"><<a href="mailto:pierre.rineau@makina-corpus.com">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;">
This was a joke :) I really don't like MySQL but the fact is it exists<br>
so I won't burn in useless flame wars :)<br>
<br>
I will go to issue queue as soon as I have some time to do it, I<br>
currently just have submited patches to make the DataSync module work<br>
with PostgreSQL, I really do help the community, but just bit by bit.<br>
<br>
I did not mean to harm :)<br>
<div><div></div><div class="h5"><br>
On Fri, 2009-08-21 at 14:47 -0400, Khalid Baheyeldin wrote:<br>
> Pierre R<br>
><br>
> We get this every now and then: endless preaching about PostgreSQL<br>
> and how it is a real DB and MySQL isn't, how it is free and not<br>
> controlled<br>
> by a company, yadda yadda ...<br>
><br>
> What we don't get is people passionate enough about it to be involved<br>
> with core enough to make sure everything works under PostgreSQL just<br>
> as well as MySQL.<br>
><br>
> Yes, I am aware of a few who are envolved, but they are not the ones<br>
> who<br>
> preach the virtues of PostgreSQL on the lists, and they are mostly<br>
> dual<br>
> users for MySQL, not pure PostgreSQL users.<br>
><br>
> So, to this group, please go to the issue queue and help with<br>
> PostgreSQL.<br>
> We are sold on the virtues, but short of hands ...<br>
><br>
> On Fri, Aug 21, 2009 at 11:54 AM, Pierre Rineau<br>
> <<a href="mailto:pierre.rineau@makina-corpus.com">pierre.rineau@makina-corpus.com</a>> wrote:<br>
> The real issue is using MySQL. PostgreSQL is a way better in<br>
> many<br>
> aspects. And it does understand standard SQL, better than<br>
> MySQL.<br>
><br>
> War launched!<br>
><br>
><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<br>
> 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<br>
> 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<br>
> PostgreSQL syntax.<br>
> ><br>
> > Some issues can be fixed in D7 (some may already as I did<br>
> not follow<br>
> > development). I saw compatibility functions around. Some<br>
> automatic casts<br>
> > may be added also in D7 PostgreSQL schema. If this was done,<br>
> please<br>
> > inform me and I will update the pages or update them<br>
> yourself.<br>
> ><br>
> > Some need fixing in PostgreSQL. All issues require attention<br>
> 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<br>
> both MySQL and<br>
> > PostgreSQL.<br>
> ><br>
> > When it is done, I will contact PostgreSQL hackers to ask<br>
> for<br>
> > modifications in PostgreSQL core. Some modifications seem to<br>
> be in the<br>
> > scope of possibility.<br>
> ><br>
> > Besides, as stated before, I think we would gain to flag<br>
> minimal<br>
> > PostgreSQL version to 8.4 to benefit from PostgreSQL 8.4 new<br>
> versions<br>
> > and from a better compatibility with Drupal.<br>
> ><br>
> > PostgreSQL new stable release is PostgreSQL 8.4, even if<br>
> Debian flags it<br>
> > as unstable. I could upgrade some 500.000 pages sites to<br>
> PostgreSQL 8.4<br>
> > without running into a single problem. SO IMHO let us not<br>
> stick to an<br>
> > old PG version.<br>
> ><br>
> > This is a minor issue, please focus on<br>
> <a href="http://drupal.org/node/555514" target="_blank">http://drupal.org/node/555514</a><br>
> ><br>
> > Kind regards,<br>
> > Jean-Michel<br>
><br>
><br>
><br>
><br>
><br>
> --<br>
> Khalid M. Baheyeldin<br>
> <a href="http://2bits.com" target="_blank">2bits.com</a>, Inc.<br>
> <a href="http://2bits.com" target="_blank">http://2bits.com</a><br>
> Drupal optimization, development, customization and consulting.<br>
> Simplicity is prerequisite for reliability. -- Edsger W.Dijkstra<br>
> Simplicity is the ultimate sophistication. -- Leonardo da Vinci<br>
<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Khalid M. Baheyeldin<br><a href="http://2bits.com">2bits.com</a>, Inc.<br><a href="http://2bits.com">http://2bits.com</a><br>Drupal optimization, development, customization and consulting.<br>
Simplicity is prerequisite for reliability. -- Edsger W.Dijkstra<br>Simplicity is the ultimate sophistication. -- Leonardo da Vinci<br>