Original link: db-engines.com/en/blog_pos…
January 13, 2021
By Matthias Gelbmann
Matthias Gelbmann is co-founder, Managing Director and consultant of Solid IT in Vienna, Austria.
Matthias Gelbmann studied computer science and applied mathematics in Vienna. His areas of expertise include database management systems, artificial intelligence, compiler construction, embedded software, Internet, and software processes. Prior to joining Solid IT, He worked at Alcatel, Austrian Banking Group and Philips as a software developer, software Architect, software quality Manager, project Manager and production line Manager.
In recent years, Matthias Gelbmann has focused on how best to use different database management techniques.
Translator: Wei Bo, China PG Chapter
If we add up all the popularity scores of the 185 open source DBMSS in DB-Engines’ ranking, we get a higher score than our commercial peers for the first time. Open source systems now account for 50.1% of the overall popularity score, up from 35.5% eight years ago.
While two of the top three systems have commercial licenses, seven of the top ten are open source, and the top five are open source when it comes to numbers alone. In general, the two most popular open source DBMSS, MySQL and PostgreSQL, are pioneers not only in the DBMS world, but in the open source world as a whole.
Going beyond commercial systems is a huge achievement for the open source community. However, we must add some clarification. First, we treat the system as open source if an open source version with significant DBMS functionality is available. Many systems also offer commercial licenses, often with extended capabilities. For this calculation, we still treat them as open source systems.
Second, there are many variations on open source licenses. For example, SQLite, at number nine, is public domain, a rarity these days. Then, we see systems with MIT licenses, Apache, Mozilla, BSD, GPL, AGPL, and proprietary licenses. Basically, we count the system as open source in cases where source code can be downloaded (including licenses sometimes referred to as “available resources”).
If we investigate which systems are open source, we will see the following picture:
79.3% of popularity-weighted time series DBMSS are open source, as are 77.9% of document stores and 76.5% of wide column stores. On the other hand, 76.8 percent of object-oriented DBMSS and 90 percent of multi-value DBMSS carry commercial licenses. In general, NoSQL systems prefer open source licenses, as do younger systems. This suggests that over the long term, the share of open source systems is expected to increase further over time, and when we look at the month-to-month changes, we already see some ups and downs.
To learn more about PostgreSQL technology, hot topics, industry news, and exciting events, please visit the official website of PostgreSQL in China: www.postgresqlchina.com