Such two backgrounds lead directly to the inherent strengths and weaknesses of each. This makes MySQL’s development process more deliberate, while PostgreSQL is more responsive. MySQL is backed by a well-established commercial company, while PostgreSQL is backed by a large volunteer development group. postgreSQL is based on a free BSD/MIT license, and organizations can use, copy, modify and redistribute the code, requiring only a copyright notice. It offers a single full-featured version, unlike MySQL, which offers several different community, commercial and enterprise editions. Originally developed at the University of California, Berkeley in 1985 as a successor to the Ingres database, PostgreSQL is a completely community-driven open source project. some fans of PostgreSQL say it rivals Oracle, and without the expensive price tag and arrogant customer service. PostgreSQL touts itself as the world’s most advanced open source database. The core code is based on the GPL license, and because MySQL is controlled by Oracle, the community is concerned about the impact on MySQL open source, so some branches have been developed, such as: MariaDB and Percona. Oracle supports several versions of MySQL: Standard, Enterprise, Classic, Cluster, Embedded and Community, some of which are free to download and some of which are paid for. MySQL was originally developed by MySQL AB and then sold to Sun in 2008 for $1 billion, which was acquired by Oracle in 2010. MySQL is used by applications built on LAMP, such as WordPress, Drupal and most php open source programs. ![]() MySQL claims to be the most popular open source database, and the M in LAMP refers to MySQL. Before we start our analysis, let’s take a look at these two charts. There are already many articles on the web comparing PostgreSQL with MySQL, this article is just to sort out some important information.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |