About nixCraft

Comparison PostgreSQL vs MySQL database server

Posted by Vivek Gite [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:

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

Want to stay up to date with the latest Linux tips, news and announcements? Subscribe to our free e-mail newsletter or RSS feed to get all updates. You can Email this page to a friend.

You may also be interested in other helpful articles:

Discussion on This Article:

  1. David Lee Says:

    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.

Leave a Reply

We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Copyright © 2004-2008 nixCraft. All rights reserved - TOS/Disclaimer - Privacy policy - Sitemap - Powered by Open source software.