More information about the Underscore mailing list

[_] Advice on migrating from Mysql to Pgsql

Derek Almond home at derekalmond.com
Thu Jan 10 14:58:36 GMT 2008

>> 
>> An now in true underscore style , the sanctimonious "of course that
>> doesn't effect me" bit ....
>> 
>> For what its worth i use Perl Catalyst with Class::DBIx which is
>> database neutral because it abstracts all the SQL and gives you yummy
>> objects to do all the queries and all the smugness you can eat.

But surely that does affect you if you want to port your DB from one format
to another - its not about where your code can reach, its about where your
data is right now.

I suppose you could use two db objects, one for each db type and copy the
data across that's way - might work for simple cases... you'd still need to
sort out the schemas though, so its not really a win since apart from the
quoting differences you can import a SQL dump  from mysql to postgres if its
only simple data.


Rick, as I recall Colin did this for sift when they moved from mysql to
postgres, do you recall him pulling his hair out lots? 


D