<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I would think this is a slippery slope, making sure a patch work
against at least 2 db backends in a reasonable way is an important
indication of quality<br>
<br>
Larry Garfield wrote:
<blockquote cite="mid200711111958.28639.larry@garfieldtech.com"
type="cite">
<pre wrap="">PDO will only abstract the API for us. It will not help us abstract query
syntax or solve the fact that there is no such thing as "SQL", just vaguely
similar languages called MySQL, PostgreSQL, SQLite, Oracle, etc.
On Sunday 11 November 2007, Ken Rickard wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I would agree with Khalid, actually. Having rock-solid code on a
popular platform seems ideal, at least until something like PDO is
ready to handle database abstraction for us.
I only installed pgSQL to be a "responsible" module maintainer after
my requests for pgSQL testers went unanswered.
At work, we're entirely MySQL.
- Ken Rickard
On Nov 11, 2007 7:30 PM, Khalid Baheyeldin <a class="moz-txt-link-rfc2396E" href="mailto:kb@2bits.com"><kb@2bits.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Nov 11, 2007 5:17 PM, Karoly Negyesi <a class="moz-txt-link-rfc2396E" href="mailto:karoly@negyesi.net"><karoly@negyesi.net></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">In my opinion, any patch should be committable to core once it works
on mysql and has a decent hope (use common sense) to work on
postgresql. Once it's committed those who care about postgresql, if
they so want to, can test and if there is a need, fix it.
Prime example: <a class="moz-txt-link-freetext" href="http://drupal.org/node/146466">http://drupal.org/node/146466</a> this is the most
important patch we have currently as it makes Drupal search speedy and
nice. And it is more or less on hold just because noone is sure
whether the postgresql update works or not.
</pre>
</blockquote>
<pre wrap="">I know many will not like what I will say, but I have to say it.
A prime example of where MySQL works fine to solve an issue with a few
lines is this issue <a class="moz-txt-link-freetext" href="http://drupal.org/node/83738">http://drupal.org/node/83738</a>. All the huge changes
and jumping through hoops is because of accomodating PostgreSQL
We introduced schema changes just because PostgreSQL cannot do case
insensitive matching by default, while MySQL works fine. For the sake of
5% (or 1%) of the sites, we are increasing complexity.
</pre>
<blockquote type="cite">
<pre wrap="">Regards,
Karoly Negyesi
</pre>
</blockquote>
<pre wrap="">--
Khalid M. Baheyeldin
2bits.com
<a class="moz-txt-link-freetext" href="http://2bits.com">http://2bits.com</a>
Drupal optimization, development, customization and consulting.
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
</body>
</html>