pg to mysql and mysql to pg

[Dark Atheist]

is it possible ? - people say ot use mysql as its more widely used by web hosts and php scripts (forums et el), but in my tests and advise from other people i have found pgsql to be a bit faster in some situations, and produces smaller databases.

I'm just wondering if you can convert between the 2 and how hard would it be?

 

[LordOfLA]

as long as you don't use features native to either database engine you can port data across easily.

It's not hard for webhosts to provide pgsql if asked either

Most don't install it because most don't know about it being run by 13 year olds and all

 

[Dark Atheist]

eh ? - 13 year olds wot ?

 

[vern]

... meaning using pg is the l33t database to use because it's less known and only real men use it. Nevermind that MySQL is now owned by Sun. ZOMG SQL Wars! SQLite 4evaaaaa!

 

[LordOfLA]

no, meaning that kiddie hosts don't usually have a clue as to the options that they can provide to users

 

[Dark Atheist]

straight answer would have been nice.

 

[LordOfLA]

you had one...

 

[vern]

Yes, you were given a straight answer. Databases can be easily converted to one or another. Even if you use native database functions, it would be trivial to write a script to convert your data if you were familiar with both to convert. Unless you need specific database functions not available in one, there really is no reason to prefer one over the other. Both have been used under a lot of performance pressure by many people. Your only real decision is which you prefer.

 

[LordOfLA]

I'm not certain of this regards mysql 5 as I've not looked at any benchmarks for it, however PostgreSQL was able to sustain many more queries with much more data at lower system resource usage than mysql 3 and 4 when Yahoo and some other big DB user were researching. I believe Yahoo chose mysql in the end though as it better fit their needs.

 

[Dark Atheist]

i may have to side with mysql as a few things i am looking at using are really only supported on mysql even though the sites the scripts are on say otherwise - even talking with some devs who say they will most likely be going full mysql only - so i may as well switch to mysql myself now