pg to mysql and mysql to pg

Dark Atheist

OSNN Veteran Addict
Political Access
Joined
8 Apr 2003
Messages
6,376
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

Godlike!
Joined
2 Feb 2004
Messages
7,026
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 :)
 

vern

Dominus
Political Access
Joined
2 Mar 2002
Messages
1,572
... 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

Godlike!
Joined
2 Feb 2004
Messages
7,026
no, meaning that kiddie hosts don't usually have a clue as to the options that they can provide to users :)
 

vern

Dominus
Political Access
Joined
2 Mar 2002
Messages
1,572
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

Godlike!
Joined
2 Feb 2004
Messages
7,026
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

OSNN Veteran Addict
Political Access
Joined
8 Apr 2003
Messages
6,376
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
 

Members online

No members online now.

Latest forum posts

Latest profile posts

Also Hi EP and people. I found this place again while looking through a oooollllllldddd backup. I have filled over 10TB and was looking at my collection of antiques. Any bids on the 500Mhz Win 95 fix?
Any of the SP crew still out there?
Xie wrote on Electronic Punk's profile.
Impressed you have kept this alive this long EP! So many sites have come and gone. :(

Just did some crude math and I apparently joined almost 18yrs ago, how is that possible???
hello peeps... is been some time since i last came here.
Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.

Forum statistics

Threads
62,011
Messages
673,478
Members
5,607
Latest member
rohitprabhakar