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

From Jaime Casanova
Subject Re: SQL compatibility reminder: MySQL vs PostgreSQL
Date
Msg-id 3073cc9b1003080858p6603bae7t2bb8a2209bd5c24@mail.gmail.com
Whole thread Raw
In response to Re: SQL compatibility reminder: MySQL vs PostgreSQL  ("Pierre C" <lists@peufeu.com>)
Responses Re: SQL compatibility reminder: MySQL vs PostgreSQL
Re: SQL compatibility reminder: MySQL vs PostgreSQL
Re: SQL compatibility reminder: MySQL vs PostgreSQL
List pgsql-hackers
On Mon, Mar 8, 2010 at 4:17 AM, Pierre C <lists@peufeu.com> wrote:
>
>> My opinion is that PostgreSQL should accept any MySQL syntax and return
>> warnings. I believe that we should access even innodb syntax and turn it
>> immediately into PostgreSQL tables. This would allow people with no
>> interest in SQL to migrate from MySQL to PostgreSQL without any harm.
>
> A solution would be a SQL proxy (a la pgpool) with query rewriting.
>

This sounds like a better idea...

>> PHP developers don't have time to invest in learning deep SQL.
>
> This is true, and it is a big problem IMHO. It results in lots of slow,
> broken, insecure database designs.
>

So, if php dev doesn't have time to learn to do things right then we
have to find time to learn to do things wrong? seems like a nosense
argument to me

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: Safe security
Next
From: David Fetter
Date:
Subject: Re: SQL compatibility reminder: MySQL vs PostgreSQL