Skip to main content
Background Image
  1. PostgreSQL Posts/

StackOverflow 2024 Survey: PostgreSQL Has Gone Completely Berserk

·659 words·4 mins· ·
Ruohang Feng
Author
Ruohang Feng
Pigsty Founder, @Vonng
Table of Contents

The 2024 StackOverflow Global Developer Survey results are fresh out, with high-quality questionnaire feedback from 60,000 developers across 185 countries and regions. Of course, as a database veteran, I’m most interested in the “Database” section of the survey results:


Popularity
#

First is database popularity: Database usage rates among professional developers

The proportion of users of a technology out of the total is popularity. It means: what percentage of users used this technology in the past year. Popularity represents accumulated usage over the past year, is a stock indicator, and the most core factual indicator.

database-used-prof.png

In usage rates, PostgreSQL has maintained its crown among professional developers for three consecutive years with an astounding 51.9% usage rate, breaking 50% for the first time! The gap with second-place MySQL (39.4%) has further widened to 12.5 percentage points (last year this gap was 8.5 percentage points).

If we consider database usage among all developers, PostgreSQL is the second year becoming the world’s most popular database, with 48.7% usage rate pulling ahead of second-place MySQL (40.3%) by 8.4 percentage points (last year it was 4.5 percentage points).

If we combine the past eight years of survey data and plot popularity on a scatter chart, we can clearly see PostgreSQL has maintained almost consistently high linear growth.

trend-used-prof.png

On this list, databases showing significant growth besides PostgreSQL include SQLite, DuckDB, Supabase, BigQuery, Snowflake, and Databricks SQL. Among these, BigQuery, Snowflake, and Databricks belong to the current hot big data analytics field. SQLite and DuckDB belong to unique embedded database ecosystems that don’t conflict with relational databases, while Supabase is a backend development platform that wraps PostgreSQL as its core foundation.

used-prof-2023-2024.png

All other databases have been impacted to varying degrees by PostgreSQL’s rise.


Loved and Wanted
#

Next is database love (red) and desire (blue): Databases most loved and wanted by all developers in the past year, sorted by desire.

database-admire-desire.png


So-called “reputation” (red dots), love rate (Loved) or admiration rate (Admired), refers to what percentage of users are willing to continue using this technology, which is an annual “retention rate” indicator that can reflect users’ views and evaluations of a technology, representing future growth potential.

trend-loved.png

In reputation, PostgreSQL continues to lead for the second year with 74.5% love rate. Particularly noteworthy are two databases: in the past year, SQLite and DuckDB’s love rates showed significant increases, while TiDB’s love rate showed an alarming decline (from 64.33 to 48.8).


The proportion of demanders out of the total is the demand rate (Wanted), or desire rate (Desired), shown as red dots in the above chart. It means: what percentage of users will actually choose to use this technology in the next year, representing actual growth momentum for the next year. Therefore, in SO’s chart, they’re also sorted by demand rate.

loved-2023-2024.png

On this metric, PostgreSQL has been leading for three consecutive years, and with an amazing advantage widening the gap with followers. Perhaps driven by recent vector database demand, PostgreSQL’s demand showed an extremely amazing surge, jumping from 19% in 2022 to 47% in 2024. Meanwhile, MySQL’s demand rate was even overtaken by SQLite, falling from second place in 2023 to third.

trend-wanted.png

Demand accurately reflects next year’s increment (users explicitly answered: “I plan to use this database next year”), so this surge in demand will quickly reflect in next year’s popularity.


Summary
#

PostgreSQL has been the undisputed, crushingly dominant world’s most popular, most loved, and most wanted database for the second consecutive year.

And according to past eight years’ trends and next year’s demand predictions, no other force can shake this position anymore.

MySQL, once PostgreSQL’s biggest competitor, has clearly shown signs of decline, while other databases have also been impacted by PostgreSQL to varying degrees. Databases that can continue growing either have different ecological niches from PostgreSQL, or are simply rebranded or protocol-compatible PostgreSQL variants.

PostgreSQL will become the Linux kernel of the database world, and the civil war among PostgreSQL world distributions is about to begin.

Related

Why PostgreSQL is the Bedrock for the Future of Data
·2719 words·13 mins
Today, one of the biggest trends in software development is PostgreSQL becoming the de facto database standard. There have already been blogs about using PostgreSQL for everything, but until now, there haven’t been many articles explaining the reasons behind this phenomenon (and more importantly, why it matters).
Will PostgreSQL Change Its Open Source License?
·2090 words·10 mins
PostgreSQL will not change its license
Technical Minimalism: Just Use PostgreSQL for Everything
·988 words·5 mins
Whether production databases should be containerized remains a controversial topic. From a DBA’s perspective, I believe that currently, putting production databases in Docker is still a bad idea.
New PostgreSQL Ecosystem Player: ParadeDB
·877 words·5 mins
ParadeDB aims to be an Elasticsearch alternative: “Modern Elasticsearch Alternative built on Postgres” — PostgreSQL for search and analytics.
Looking Ahead to PostgreSQL in 2024
·3460 words·17 mins
This article is PostgreSQL core team member Jonathan Katz’s outlook on the future of the PostgreSQL project in 2024, reviewing the progress PostgreSQL has made in recent years.
PostgreSQL Wins 2024 Database of the Year Award! (Fifth Time)
·724 words·4 mins
DB-Engines officially announced today that PostgreSQL has once again been crowned “Database of the Year.” This is the fifth time PG has received this honor in the past seven years. If not for Snowflake stealing the spotlight for two years, the database world would have almost become a PostgreSQL solo show.