pg to mysql and mysql to pg

**Dark Atheist** · March 17th, 2008

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** · March 17th, 2008

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** · March 17th, 2008

eh ? - 13 year olds wot ?

**vern** · March 18th, 2008

... 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** · March 18th, 2008

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

**Dark Atheist** · March 19th, 2008

straight answer would have been nice.

**LordOfLA** · March 19th, 2008

you had one...

**vern** · March 19th, 2008

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** · March 20th, 2008

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** · March 25th, 2008

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

March 17th, 2008	Top \| #1
Dark Atheist OSNN Veteran Addict Joined: April 2003 Location: In The Void Posts: 6,373 Blog Entries: 9 Reputation: 1877 Power: 193	pg to mysql and mysql to pg 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?

March 17th, 2008	Top \| #2
LordOfLA Godlike! Joined: February 2004 Location: Salisbury, Wiltshire, UK Posts: 7,031 Blog Entries: 5 Reputation: 4137 Power: 213	Re: pg to mysql and mysql to pg 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 If HK-47 and GLaDOS had a child, the character they create would cause the video game world to overdose on awesome. -sheridanmovieguy: Dragon age forum user.

March 17th, 2008	Top \| #3
Dark Atheist OSNN Veteran Addict Joined: April 2003 Location: In The Void Posts: 6,373 Blog Entries: 9 Reputation: 1877 Power: 193	Re: pg to mysql and mysql to pg eh ? - 13 year olds wot ?

March 18th, 2008	Top \| #4
vern Dominus Joined: March 2002 Location: Minnesota, USA Posts: 1,570 Reputation: 660 Power: 146	Re: pg to mysql and mysql to pg ... 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! free illegal pr0n @ ribbed.us

March 18th, 2008	Top \| #5
LordOfLA Godlike! Joined: February 2004 Location: Salisbury, Wiltshire, UK Posts: 7,031 Blog Entries: 5 Reputation: 4137 Power: 213	Re: pg to mysql and mysql to pg no, meaning that kiddie hosts don't usually have a clue as to the options that they can provide to users If HK-47 and GLaDOS had a child, the character they create would cause the video game world to overdose on awesome. -sheridanmovieguy: Dragon age forum user.

Latest News Posts

Latest Forum Posts

Latest Member Blogs

March 19th, 2008	Top \| #6
Dark Atheist OSNN Veteran Addict Joined: April 2003 Location: In The Void Posts: 6,373 Blog Entries: 9 Reputation: 1877 Power: 193	Re: pg to mysql and mysql to pg straight answer would have been nice.

March 19th, 2008	Top \| #7
LordOfLA Godlike! Joined: February 2004 Location: Salisbury, Wiltshire, UK Posts: 7,031 Blog Entries: 5 Reputation: 4137 Power: 213	Re: pg to mysql and mysql to pg you had one... If HK-47 and GLaDOS had a child, the character they create would cause the video game world to overdose on awesome. -sheridanmovieguy: Dragon age forum user.

March 19th, 2008	Top \| #8
vern Dominus Joined: March 2002 Location: Minnesota, USA Posts: 1,570 Reputation: 660 Power: 146	Re: pg to mysql and mysql to pg 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. free illegal pr0n @ ribbed.us

March 20th, 2008	Top \| #9
LordOfLA Godlike! Joined: February 2004 Location: Salisbury, Wiltshire, UK Posts: 7,031 Blog Entries: 5 Reputation: 4137 Power: 213	Re: pg to mysql and mysql to pg 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. If HK-47 and GLaDOS had a child, the character they create would cause the video game world to overdose on awesome. -sheridanmovieguy: Dragon age forum user.

March 25th, 2008	Top \| #10
Dark Atheist OSNN Veteran Addict Joined: April 2003 Location: In The Void Posts: 6,373 Blog Entries: 9 Reputation: 1877 Power: 193	Re: pg to mysql and mysql to pg 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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MYSQL Replication?	Eagle710	Linux & BSD	2	December 3rd, 2007 6:56pm
sorting mySQL	jimi_81	Web Design & Coding	5	May 6th, 2005 12:36am
VB 6 and mySQL	disavowed00	Web Design & Coding	5	January 15th, 2005 8:29pm
PHP and Mysql	luish	Web Design & Coding	7	August 24th, 2003 6:27pm
PHP MySQL	5meg	Web Design & Coding	3	February 2nd, 2002 1:34pm