PostgreSQL won the title of “database of the year” three times in four years!

Time:2021-3-14

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

To determine this year’s DBMS, we subtracted the January 2020 popularity score from the latest January 2021 score. We use the difference of these numbers instead of the percentage, because it will benefit systems that are initially less popular. The result is a list of DBMS in terms of how successful they have been in increasing their popularity in 2020, or in other words, how many people are starting to communicate in a way that we measure in our approach, such as job opportunities, professional profile entries, and online references.

Annual DBMS: PostgreSQL
PostgreSQL won the title of

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

PostgreSQL is known and loved for its stability and feature set. Recent versions mainly focus on the improvement of database engine to improve its performance and efficiency. For Devops, these enhancements are very popular, and our popularity score shows this: seven years ago, PostgreSQL scored 167, and now it’s 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 DBMS provide important DBMS functions on top of them, they will be 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, geographic 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 increased from 25 to 15.

In the nine years of DB engines, this is the first time that cloud database service has won the top three “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 one is the document store. A little-known fact is that mongodb is also the most popular search engine when we include the secondary database model. This is a good illustration of the expanding scope of mongodb since its release 11 years ago. Equally important, there is no doubt that mongodb is a mature and productive system today, and the web jokes of ten years ago were not particularly mature, even though they might have been interesting at that time.
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, member of PostgreSQL core team: “PostgreSQL’s success is due to a global collaborative community of open source developers who are addressing the modern challenges of data management. We thank DB engines for their 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 a good year. The fact that our popularity among developers continues to grow proves that our community servers have been downloaded 130 million times – 55 million this year alone, more than in the first decade of our company, our global cloud database mongodb Atlas now accounts for nearly 50% of our revenue, and with the release of the multi multi version, it has become the first multi cloud cluster that enables applications to run simultaneously among multiple cloud providers. It’s exciting to add this extra recognition from DB engine to our list of achievements. “

Link to the original text: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

China PostgreSQL technical Q & a community:
www.pgfans.cn

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

Recommended Today

The selector returned by ngrx store createselector performs one-step debugging of fetching logic

Test source code: import { Component } from ‘@angular/core’; import { createSelector } from ‘@ngrx/store’; export interface State { counter1: number; counter2: number; } export const selectCounter1 = (state: State) => state.counter1; export const selectCounter2 = (state: State) => state.counter2; export const selectTotal = createSelector( selectCounter1, selectCounter2, (counter1, counter2) => counter1 + counter2 ); // […]