| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | David Fetter <david(at)fetter(dot)org> |
| Cc: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, Pierre C <lists(at)peufeu(dot)com>, francois(dot)perou(at)free(dot)fr, Josh Berkus <josh(at)agliodbs(dot)com>, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers(at)postgresql(dot)org, dpage(at)pgadmin(dot)org |
| Subject: | Re: SQL compatibility reminder: MySQL vs PostgreSQL |
| Date: | 2010-03-08 17:18:31 |
| Message-ID: | 603c8f071003080918n26f521flded1fa4607bf3405@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-hackers |
On Mon, Mar 8, 2010 at 12:10 PM, David Fetter <david(at)fetter(dot)org> wrote:
> 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?
That seems largely irrelevant to the problem at hand. It's not
impossible to do syntactic transformations from one Turing-complete
langauge to another; if it were, there could be no such thing as a
compiler.
...Robert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2010-03-08 17:43:38 | Re: SQL compatibility reminder: MySQL vs PostgreSQL |
| Previous Message | Hitoshi Harada | 2010-03-08 17:14:46 | Re: SQL compatibility reminder: MySQL vs PostgreSQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Bunce | 2010-03-08 17:32:03 | Re: Safe security |
| Previous Message | Hitoshi Harada | 2010-03-08 17:14:46 | Re: SQL compatibility reminder: MySQL vs PostgreSQL |