Re: SQL compatibility reminder: MySQL vs PostgreSQL - Mailing list pgsql-hackers

From Chris Browne
Subject Re: SQL compatibility reminder: MySQL vs PostgreSQL
Date
Msg-id 87r5ny1nel.fsf@ca.afilias.info
Whole thread Raw
In response to SQL compatibility reminder: MySQL vs PostgreSQL  (François Pérou <francois.perou@free.fr>)
List pgsql-hackers
francois.perou@free.fr (François Pérou) writes:
> * I am very surprised by the SQL level of Php developers. The example
> Drupal developers trying to rewrite SQL queries dynamically adding
> DISTINCT clause is just an example. So don't expect them to understand
> the difference between MySQL and PostgreSQL. It is out of reach. They
> focuse on Php code.

If they refuse to contemplate suggestions as to how to write more
portable SQL queries that would work with databases other than MySQL,
then I don't know what constructive discussion there can be about this.

> I believe that PostgreSQL should support more MySQLisms in order to BEAT
> MySQL.

Why, when the MySQLisms in questions are divergences from the SQL
standards, and the issue seems to bite all the other databases in more
or less the same way?

It doesn't seem to me that the answer to "Drupal developers refuse to
consider writing portable SQL" is to try to impose MySQL's divergences
from SQL onto all the *other* DBMSes.
-- 
"Have  you noticed   that,  when we were   young,  we were   told that
`everybody else   is doing  it' was   a  really  stupid reason  to  do
something,  but now it's the standard  reason for picking a particular
software package?" -- Barry Gehm 


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: SQL compatibility reminder: MySQL vs PostgreSQL
Next
From: François Pérou
Date:
Subject: Re: SQL compatibility reminder: MySQL vs PostgreSQL