Comparison PostgreSQL vs MySQL database server

by on December 19, 2006 · 1 comment· Last updated December 19, 2006

Both are open source databases. This is old debate. Yes no one can expect one database fits all your jobs.

To choose between the two databases, you need to understand whether you need the transaction support of Postgres or the large-text-area support in MySQL.

From the article:
It's interesting that the two databases appear to be converging to meet in the middle somewhere. While MySQL is working on adding transaction support and slowly adding features like subselects, Postgres is making progress in the performance and stability.

It compare two databases using following points:

  • SQL standard COMPLIANCE
  • PLATFORMS
  • Speed
  • STABILITY
  • DATA INTEGRITY
  • SPECIAL server-side FEATURES
  • Security
  • LOCKING and CONCURRENCY SUPPORT
  • LARGE OBJECTS etc

A good read (little old too) but don't forget to make some test running before selecting your database.



You should follow me on twitter here or grab rss feed to keep track of new changes.

Featured Articles:

{ 1 comment… read it below or add one }

1 David Lee February 4, 2008 at 11:56 pm

There’s a WikiVS page on this topic. It has a lot of up-to-date information:

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

Plus, you can contribute to the comparisons, wiki-style.

Reply

Leave a Comment

You can use these HTML tags and attributes for your code and commands: <strong> <em> <ol> <li> <u> <ul> <blockquote> <pre> <a href="" title="">
What is 15 + 9 ?
Please leave these two fields as-is:
Solve the simple math so we know that you are a human and not a bot.



Previous post:

Next post: