Three times in four years, PostgreSQL won the title of “database of the year” again!

Time:2021-7-25

PostgreSQL is a database management system that has been more popular in the DB engines rankings than any of the other 360 monitored systems in the past year.
Therefore, we declare PostgreSQL the DBMS of 2020.

To determine the DBMS for this year, we subtracted the popularity score in January 2020 from the latest score in January 2021. We use the difference of these numbers instead of percentages, because it will benefit systems with low popularity at the beginning. The result is a list of DBMS that have successfully improved their popularity by 2020, or in other words, how many people have begun to communicate in a way measured in our method, such as job opportunities, professional profile entries and online references.

Annual DBMS: PostgreSQL
Three times in four years, PostgreSQL won the title of

PostgreSQL has won the annual DBMS award in 2017 and 2018, and is now the first database management system to win this award three times.

PostgreSQL is famous and loved for its stability and feature set. The latest version mainly focuses on the improvement of database engine to improve its performance and efficiency. For Devops, these enhancements are very popular, as our popularity score shows: seven years ago, PostgreSQL had a popularity score of 167, but now it is 552. The gap with the top three systems has narrowed year by year.

It is worth mentioning that PostgreSQL is the basic technology of various database management systems in our ranking. If these database management systems provide important DBMS functions on top of them, they are listed as separate entries. These systems include Greenplum, EDB, Postgres, timescaledb, citus, etc.

Runner up: Microsoft azure SQL database
Microsoft azuresql database is a fully managed database as a service. It is built on the latest stable version of Microsoft SQL server products and optimized for functions that can run in the cloud (automatic scaling, geo replication, automatic adjustment, etc.). Therefore, functions such as manual backup / restore and server configuration parameter management are not supported.

Between January 2020 and January 2021, the popularity score of azure SQL database increased from 28.2 to 71.4 (impressive 253%), and the overall ranking in DB engines ranking increased from 25 to 15.

In the nine years of DB engines, this is the first time that cloud database service has entered the top three of the “database of the year” award.

Third place: mongodb
Mongo won the annual champion of DBMS twice in 2013 and 2014, and its popularity has not stopped since then. It is the most popular NoSQL system, and the most famous is the document store. A little-known fact is that mongodb is also the most popular search engine when we include a secondary database model. This is a good illustration of the expanding scope of mongodb since its release 11 years ago. It is no doubt that mongodb can be used in today’s production, although it was not mature ten years ago.
We congratulate PostgreSQL, Microsoft and mongodb on their success in 2020.

Previous DB engines annual DBMS Award Winners:

database year
PostgreSQL 2020
MySQL 2019
PostgreSQL 2018
PostgreSQL 2017
Microsoft SQL 2016
Oracle 2015
Mongo DB 2014
Mongo DB 2013

reaction
Selected statement of results:
Jonathan Katz, a member of the core team of PostgreSQL: “the success of PostgreSQL is due to the global collaborative community of open source developers who are solving the modern challenges of data management. We thank DB engines for its continued recognition of PostgreSQL, and we will continue to enhance our developer friendly open source database system, which is known for its reliability and robustness. “

Rishi Dave, chief marketing officer of mongodb: “mongodb has ushered in a bumper year. Our popularity among developers continues to grow. This fact proves that our community server has downloaded 130 million times – 55 million this year alone, more than in the first ten years of our company. Our global cloud database mongodb atlas now accounts for nearly 50% of our revenue. With the release of the multi multi version, It became the first multi cloud cluster to enable applications to run simultaneously between multiple cloud providers. It’s exciting to add this additional recognition of DB engine to our list of achievements. “

Original link:https://db-engines.com/en/blog_post/85

For more wonderful content, please pay attention to the following platforms and websites:

Official account of China PostgreSQL branch (technical articles and technical activities):
PostgreSQL branch of Open Source Software Alliance

Technical Q & a community of China PostgreSQL branch:
www.pgfans.cn

Official website of China PostgreSQL branch:
www.postgresqlchina.com