Re: SQL compatibility reminder: MySQL vs PostgreSQL

On Mon, Mar 08, 2010 at 11:58:20AM -0500, Jaime Casanova wrote:
> On Mon, Mar 8, 2010 at 4:17 AM, Pierre C <lists(at)peufeu(dot)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...

Aside from that little "halting problem" issue, it sounds wonderful.
You do know that SQL is Turing-complete, right?

> >> 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

Indeed.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate