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

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.
Terrahertz wrote on Electronic Punk's profile.
Yo fellas!
Electronic Punk wrote on Sazar's profile.
Where are you buddy?
Perris Calderon wrote on Electronic Punk's profile.
Hey EP! All good with me, applying for Microsoft MVP right now, should have done this a while ago.

Notifications don't work, I only found your response by coming back to hunt up some threads, if you want, give me your email address so we can keep in touch easier!
Perris Calderon wrote on Electronic Punk's profile.
EP, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there!

Forum statistics

Threads
61,997
Messages
673,414
Members
5,591
Latest member
nodee