You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
What is the diff bet PostgreSQL and MySQL?
- Thread starter AshokD
- Start date
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
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
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.
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.
jonathanpair
New Member
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. MySQL is the best one for the data base.