Re: SQL compatibility reminder: MySQL vs PostgreSQL

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: SQL compatibility reminder: MySQL vs PostgreSQL
Дата
Msg-id 20100308171002.GF8996@fetter.org
обсуждение исходный текст
Ответ на Re: SQL compatibility reminder: MySQL vs PostgreSQL  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Ответы Re: SQL compatibility reminder: MySQL vs PostgreSQL  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
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@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...

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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: SQL compatibility reminder: MySQL vs PostgreSQL
Следующее
От: Hitoshi Harada
Дата:
Сообщение: Re: SQL compatibility reminder: MySQL vs PostgreSQL