Comparison of PostgreSql and MySQL is really a burden. These two are the greatest applications, and frequently the choice to use it purely is of personal preference. They could be compared paralelly to try helping users to decide what may be the better choice for them.
CharacteristicsThis is probably the advantage of PostgreSql. Stored procedures, views or sub-queries, cursors are not supported by MySQL. It was a big mistake by the developers of MySQL, but his claim is that these features are not essential. However, it may be necessary to consider whether you really need all the extra characteristics in PostgreSql, because many developers do not really use them for real. SupportThis term has a range of meanings.
How MySQL is more widely used in many applications, media, and it also means that there is a larger community, available to help and advise you on problems that you might encounter in everyday life. But PostgreSQL has active forums and mailing lists, there are concerns and that commercial support, so that both applications are quite overlapped in these areas.
Ease of useOne of the toughest. It's like a debate between the two users usually go, Person A: " MySQL is easy to use as" Person B immediately interrupted with "No mistake, PostgreSQL are much easier, because" debate and turns. In fact, it's because Person A is easier than MySQL. It does not mean that person C and so on for PostgreSQL. It's really a personal taste, and grouping for new users who may work a little with every individual to decide themselves what is the best option.
StabilityThe press MySQL said to be more stable, but the voice is often false. This might be due to the part in fact that few of the characteristics of the latest updates in MySQL are always "under construction" so as to speak. SpeedMySQL is designed to be fast database, while PostgreSQL is presented as a more complete, both seems to want to meet in middle with the recent changes, and the speed difference is hardly a huge problem.
LicenseMySQL is mostly used as the working model of the open source companies, seeking for generating income. It is distributed under the control of GNU (General Public License) that requires a license derivative works the same manner, although the commercial licenses are commonly available for the people who wants to work in this type of limitations. PostgreSql uses the BSD license, that allows the usage of a code, provided that the credits remain.
|