PostgreSQL vs. MySQL: How to Select the Right Open-Source Database

 
 
By Jim Mlodgenski  |  Posted 2010-10-21 Email Print this article Print
 
 
 
 
 
 
 

To properly evaluate the strengths of PostgreSQL and MySQL, the two leading open-source databases, one must look at the history and pedigree of each, and their feature functionality and performance. By comparing and contrasting PostgreSQL and MySQL here, Knowledge Center contributor Jim Mlodgenski guides you to a more informed decision about which open-source database is right for your enterprise deployment.

Traditionally, the comparison between PostgreSQL and MySQL gets heated from both sides of the religious camps. They are both technically strong, open-source databases with a large install base. However, in reality, rarely do the strengths of each database overlap to an extent where it is a toss-up of which solution to use.

Once people understand the strengths of each product, the choice is typically fairly clear. In order to properly evaluate the strengths of PostgreSQL and MySQL, let's look at the history and pedigree of each. Let's also look at their feature functionality and performance, as well as the requirements for a successful enterprise database deployment.

A historical perspective

The PostgreSQL community is the oldest, largest and fastest-growing community of its kind.  PostgreSQL started in 1985 at the University of California, Berkley as an evolution of the Ingres project. After several years in academia, the PostgreSQL project was released into the open-source world. The community began to flourish to the point where, today, there are more than 1,000 contributors and over 30,000 members.

The key advantage to the large community is the interaction between users and developers, which allows users to become directly involved in the design of new features. This diverse community is the model that many other open-source communities strive for.

The MySQL community, on the other hand, started in the commercial world. MySQL was started in Sweden in 1994 out of a need to have a high-speed database behind Websites. It was released in the open-source world a few years later under the control of MySQL AB. This commercial control helped MySQL become one of the most widely-used databases in the world (which led to Sun acquiring MySQL AB in 2008). The popularity of MySQL also became a major factor in the EU acceptance of the Oracle acquisition of Sun, which finalized earlier this year.




 
 
 
 
Jim Mlodgenski is Chief Architect at EnterpriseDB. Jim is one of EnterpriseDB's first employees, having joined the company in May 2005. Over the years, Jim has been responsible for key activities such as sales engineering, professional services, strategic technology solutions delivery and customer education. Prior to joining EnterpriseDB, Jim was a partner and architect at Fusion Technologies, a technology services company. For nearly a decade, Jim developed early designs and concepts for Fusion's consulting projects, and specialized in Oracle application development, Web development and open-source information architectures. He can be reached at jim.mlodgenski@enterprisedb.com.
 
 
 
 
 
 
 

Submit a Comment

Loading Comments...
 
Manage your Newsletters: Login   Register My Newsletters























 
 
 
 
 
 
 
 
 
 
 
Thanks for your registration, follow us on our social networks to keep up-to-date
Rocket Fuel