Re: [OT] MySQL is bad, but THIS bad? - Mailing list pgsql-hackers

From David Fetter
Subject Re: [OT] MySQL is bad, but THIS bad?
Date
Msg-id 20060518181429.GB27292@fetter.org
Whole thread Raw
In response to Re: [OT] MySQL is bad, but THIS bad?  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-hackers
On Thu, May 18, 2006 at 02:56:12PM -0300, Marc G. Fournier wrote:
> On Thu, 18 May 2006, Joshua D. Drake wrote:
> 
> >I understand the idea but I personally don't like it. I am not really 
> >interested in cross-database compatible code. 9 times out of 10 it is 
> >hacky, slow and lacks a solid supportable model because you are always 
> >taking into account *the other* databases the application supports.
> 
> I don't disagree about the 'hacky, slow and lacks ...' ... but,
> there are alot of MySQL based apps out there that are just *way too
> big* to convert wholesale to PostgreSQL that, in all honesty, are
> better suited to PostgreSQL ...

They're not too big when critical data is in there.  Then it's a
matter of what cost to make this wrong decision and have to fix it.

> To give someone a running chance at migrating it to PostgreSQL, a
> 'MySQL compatibility module' would allow them to just plug the
> existing DB in, and then work at improving sections of the code over
> time ...

You cannot cross a chasm in two steps.  MySQL apps don't generally
lend themselves to incremental improvements because they are so
tightly tied to MySQL's misbehaviors.  It would be silly and dangerous
to give people the misapprehension that this transition can be made
painlessly or at low cost.

Cheers,
D
-- 
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666                             Skype: davidfetter

Remember to vote!


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: [OT] MySQL is bad, but THIS bad?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: [OT] MySQL is bad, but THIS bad?