What is the diff bet PostgreSQL and MySQL?

Question

What is the diff bet PostgreSQL and MySQL?

Answer 1

Well, this is an hard question, even if PostgreSQL it's more mature and support all the most modern features, MySQL in the last 2 years reached the same level. PostgreSQL is working to improve performance and to add new valuable features. MySQL is working most of all on adding new features and in bug fixing.

Even if PostgreSQL is still slower then MySQL, it has some advantages then MySQL, like unlimited number of indexes (MySQL 64)

PostgreSQL is completely open source. MySQL not, it has two licenses, one commercial and one open.



I strongly advice you to take a look on this comparison:

http://www.encorewiki.org/display/encore/Open+Source+Databases+Comparison



And to read the features list and choose the DB based on your needs:



http://www.postgresql.org/about/press/features83

http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html

Answer 2

here's a good forum:



http://developers.slashdot.org/article.pl?sid=06/12/18/1152230&from=rss



...and one quote from that:



You have to give the MySQL guys credit for the fact that it is an incredibly easy product when it comes to configuring it for your needs. For me, out of college, going to Oracle was a culture shock because the process of configuring Oracle was so convoluted and drawn out for simple stuff. I know that Oracle and PostgreSQL can be much more powerful than MySQL, but there is something to be said for how easy it is for a developer to install MySQL and just start working with it.



and from my experience:



There is nothing more powerful than a free dbms like MySQL.

Configuring it is quite easy for beginners. For features, I'd give it a thumbs up for Postgre, but MySQL, will keep the gears of your website running.



regards,



.o0zhylax0o.

Answer 3

Plz see

http://www-css.fnal.gov/dsg/external/freeware/pgsql-vs-mysql.html