On Mon, Oct 10, 2005 at 02:44:29PM -0300, Marc G. Fournier wrote:
> On Mon, 10 Oct 2005, Jim C. Nasby wrote:
> >On Mon, Oct 10, 2005 at 07:19:47PM +0200, Peter Eisentraut wrote:
> >>>- Many current MySQL users would like to adopt PostgreSQL but feel
> >>>unable to do so because their application package does not support
> >>>PostgreSQL at all/well enough or they feel there are technical issues
> >>>with the MySQL to PostgreSQL code (not data) migration.
> >>And of course they are right. Porting from MySQL to PostgreSQL is a
> >>problem, one which could only be solved by dumbing down PostgreSQL to
> >>accept many of MySQL's idiosyncracies, which isn't going to happen.
> >There are many features that could be implimented in PostgreSQL in a way
> >that was both logical and supported MySQL converters, though. The recent
> >discussion on one of the lists about adding enum as a type is an
> >example. I'm sure there are others.
> >I think the best way to increase migration from MySQL to PostgreSQL
> >would be to find out what the biggest pains are for users attempting to
> >migrate and then figure out how we can reduce that pain. In some cases
> >these solutions might be adding features to PostgreSQL, but many of them
> >might just involve improving existing migration tools.
> Couldn't these features be mostly added as a 'MySQL Compatibility add-on'?
> For instance, the enum type you list above ... ?
There's issues with doing that. I know one problem is that you currently
can't pass parameters in when you define a column in a table, which you
need to be able to do for an enum.
But like I said, if we want to improve migration we should find out
where the users have pain and concentrate on that. That was actually the
context of the enum discussion. I threw enum out as an example and
everyone latched onto it, missing the overall point of trying to improve
migration from MySQL.
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
In response to
pgsql-advocacy by date
|Next:||From: Jim C. Nasby||Date: 2005-10-10 19:51:17|
|Subject: Re: Feedback from LinuxWorld, London|
|Previous:||From: Samer Abukhait||Date: 2005-10-10 19:35:25|
|Subject: Re: 8.1 Press Release is Final|