Web Development and Marketing

Post Page Rank

One of my former student asked me to write this, PostgreSQL vs MySQL :icon_biggrin: . Which one of these databases is the best? It depends on what you need. Again, no solution is perfect. You should decide it by yourself.

More information can be found on this interesting article by Ian Gilfillan. He wrote really good arguments on the war between PostgreSQL and MySQL. You can have a look in the link below:

http://www.databasejournal.com/features/mysql/article.php/3288951

From my point of view, MySQL is really simple and fast for normal web site. In fact, it can handle numerous requests. If you need features such as stored-procedures, sub queries and many others that MySQL doesn’t support then get PostgreSQL. Although the latest MySQL started from version 4.1 now can handle such features. Most of the web hosting have only MySQL 3.23.x and 4.0.x installation in their servers.

I still use MySQL. Why? My hosting has only MySQL database. I don’t really need sub query features in my web app. I can rewrite the query using JOIN to achieve the same result. In fact, I found that some sub query may give you slow performance. Most of my web app code is just using simple query to get highest performance as possible.
So the decision is yours. Any comments would be appreciated.
:icon_wink:

PS: this blog engine is using MySQL. Do you think is fast? :icon_lol:

Stumble it!