DB conversion

[Tim Writer]

cbbrowne-HInyCGIudOg at public.gmane.org writes:

> > Is there an easy way to convert from Postgres to MySQL?
> 
> There can't be, because a great deal of the functionality would require
> that you add substantial code to your application since MySQL does
> minimal if any validation of input, and does not support vital features
> such as triggers, stored procedures, and VIEWs.
> 
> The only way you are likely to be able to convert a relational database
> application to use MySQL is if you are using your database in the most
> impoverished way.

At risk of starting a flame war, that's a matter of opinion.  I could rewrite
your last sentence this way:

    You can easily convert your application from Posgress to MySQL
    as long as you're using it sensibly, i.e. for storing data. If
    you're using "advanced" features that really don't belong in a
    database, like triggers, stored procedures, etc. the conversion
    will be more difficult.

When all you've got is a hammer, everything looks like a nail.

Just my $0.02.

-- 
tim writer <tim-s/rLXaiAEBtBDgjK7y7TUQ at public.gmane.org>                                  starnix inc.
905.771.0017 ext. 225                           thornhill, ontario, canada
http://www.starnix.com              professional linux services & products
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml