MySQL vs. PostgreSQL

[Burgresso]

I'm hoping to get some advice about which is better to learn (nay, master really ;) ) database administration on - MySQL or PostgreSQL?

I already now MySQL pretty well I'm looking to diving deep into either one of these soon; any reccomendations on which I should learn?

I ask in part b/c I've heard that PostqreSQL has more relational features than MySQL (which may imply that concepts learned on PostgreSQL are more universal) but I was hoping to get advice from people who know more about the subject than me.

regards

burgresso

[offbyte]

hi that's a good question

i'll just add whitch would be the best ide to program a graffical interface

i'm doing a work for university about emploiment... still in the E-R...

[adamkane]

MySQL is better for learning. It's easier to setup and maintain. PostGRESQL is great too, but who will spend most of your time banging your head against the wall.

Install an open-source CMS based on PHP/MySQL to get the ball rolling. After that you will understand which is better.

[davidomundo]

An accurate and up-to-date comparison page between MySQL & PostgreSQL:

http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL

Plus, you can contribute your own bit of information, wiki-style. :)