Php/MYSQL conversion

[Anon]

Hi. I have an working database program that is written in PHP3 and runs on PostgreSQL. For versatility purposes, I believe that it may make more sense if it could be converted to run on MySQL instead. Is this kind of conversion something that is possible? Is it a fairly easy undertaking?

[Anon]

So much depends on the database structure, and whether or not you're using the features that PostgreSQL supports and MySQL doesn't, like transactions, sub-selects and stored procedures. While MySQL is very fast, it doesn't offer all of the features of PostgreSQL.

Another thing to consider is the how much coding will need to be changed; if you coded it carefully and abstracted the database calls, good for you. If not, I'd think about this very carefully...

Mom always sez, "If ain't broke, don't fix it."

[Anon]

Thank you for replying. Honestly now I am more confused than before. The reason I wanted to switch it was mainly due to finding cheap hosting service that can support postgrSQL (as hardly anone supports it).
I was told by doing minor adjustments and converting it to mySQL it will be very easy to find a cheap host.

I will be using all the features for the data base.

I hope this will clarifies what I am looking for.