This post is about the question: 'SQL protocol: PostgreSQL or MySQL?'. Please see below for details.
We want to standardize the widely used SQL and we want it to be open source and have a mature ecosystem around the database, with the natural choice of PostgreSQL and MySQL.
The reasons for selecting PostgreSQL (not MySQL) are as follows:
PostgreSQL has a looser license, which is more compliant with YugaByte DB's open source spirit;
the popularity of PostgreSQL over the past few years has been soaring compared to any other SQL database, which has never been affected.
of the five SQL databases currently ranked top 10 in DB-Engines, only PostgreSQL has become more popular since 2014, while other databases tend to be stable or are losing market.
In addition, for many applications, PostgreSQL is an excellent substitute for Oracle. The organization is being attracted by PostgreSQL because it is open-source, vendor-neutral (MySQL is owned by Oracle), has a participating developer community, a booming supplier ecosystem, a powerful function set and a mature code base.
After more than 20 years of strict use, it is still going strong.
