Making a choice between Mysql and Postgresql
Open source databases have proven their credibility in terms of speed and performance. MySQL and PostgreSQL are the two popular open database solutions and software developers often have difficulty in choosing one over the other, as they are not able to make a proper comparative analysis and match features with requirements. MySQL is faster than PostgreSQL but the latter is richer in features. MySQL is easy to use than but PostgreSQL offers a familiar interface and syntax structure to the developers. However, this is just the tip of the iceberg. Many more differences exist. Not all differences may matter much but certain parameters such as stability may make a big difference. An important question that has to be figured out is that which is more stable mysql or postgresql.
As far as stability is concerned, MySQL is stable in almost all types of environments even when resource intensive queries are executed. However, the newly incorporate features in MySQL are not very stable. In this respect, PostgreSQL has an edge, as all its features are stable. An important reason is that most of the features in PostgreSQL have been there since a long time and have been thoroughly tested and upgraded through subsequent versions.
MySQL is definitely more popular than PostgreSQL. Part of the reason is that most of the users need a limited set of functionalities. PostgreSQL provides a more comprehensive set of features and functionalities that helpful in certain situations. It provides features such as Views, Cursors, Stored Procedures, Subqueries that MySQL does not offer. These features let the developers design and implement designs that are more integrated.
Developer community for MySQL is bigger than PostgreSQL. More people are contributing to MySQL development and bug fixes. Mailing list for PostgreSQL is more active than MySQL (ensuring quick replies for common problems), but number wise MySQL has an edge.