Category: All posts
Nov 28, 2024
Posted by
Ryan Booz
The state of Postgres is strong. It’s the one of the most popular and loved databases in the world, even after 30+ years of development. But, there are many aspects of the Postgres community that can be improved. We wanted to hear from developers so that we (and hopefully others too) could get a better understanding of how to help the Postgres community continue to grow.
Earlier this year, we launched our second State of PostgreSQL survey. Nearly 450 developers replied, giving us a good sample from which to glean several insights. We wanted to understand the different types of developers that use Postgres today, the kinds of use cases they’re tackling, the places they go to share and learn, and the opportunities for improvement in the Postgres community overall.
At Timescale, we’re always looking for ways to contribute to the Postgres community. We employ full-time contributors to Postgres (and are hiring more), we sponsor Postgres events and meetups, we speak and share our insights at Postgres events, and we’ve developed handy resources like the Postgres Cheat Sheet.
We’re active members of the Postgres community, and thus appreciate how expansive, vibrant, and supportive it is. The “State of Postgres” is an opportunity to support our qualitative understanding of the Postgres community with quantitative data. This was our second State of Postgres survey (read the findings from the first survey).
👉 Read on for our key findings – and be sure to check out the full report for more insights, detailed question responses, anonymized source data, and how to get notified about next year's survey.
How do you refer to Postgres?
While the GIF/Jif debate rages on, it seems the debate between “Postgres” and “PostgreSQL” has a clear winner:
Compared to one year ago, is Postgres being used more or less in your organization?
The past year has been one of turmoil and tragedy, but in parallel we’ve seen a rapid adoption of open-source technology in almost every industry. Even the traditional laggards have embraced a modern tech stack. Postgres is part of that story, and 43% of developers who use Postgres at work report using it about the same amount, while 52% reported using it more - or a lot more - than this time last year. That’s a great story for one of the most venerable database products ever.
How long have you been using Postgres?
The increase in Postgres usage is particularly striking when viewed alongside the percentage of developers who are new to Postgres. It’s no secret that Postgres is one of the most popular and loved databases in the world, and our survey results corroborate that assertion.
What is the main reason you chose to use Postgres over other options?
As we’ve mentioned, Postgres is continuing to grow and attract new developers. But, we wanted to understand why developers are choosing Postgres over the alternatives. It shouldn’t surprise us that the top two reasons are reliability and SQL, two of the biggest reasons why we chose Postgres on which to build TimescaleDB.
How do you deploy Postgres?
The ways developers deploy Postgres are as diverse as the community's experience, geographical locations, and job titles, although self-managed deployments (on-site, private data center, public cloud) seem to be most common.
What cloud provider(s) do you use?
The growth of the cloud is no secret, and the same is true within the Postgres community. About 75% use a cloud provider - or multiple - in some capacity, with nearly half (46%) on AWS. What was a little surprising to us is how Digital Ocean edged out Azure for the #3 cloud provider slot.
Even the most venerated communities can stand to improve. Indeed, we’ve seen throughout history that communities that elect not to improve eventually lose touch with their constituency and whither away. We are big believers in Postgres, and we are committed to its success.
What is the best thing about the Postgres community, or what do you like the most?
Documentation quality, community helpfulness and commitment to open-source, and volume of available resources were common themes.
What is the most challenging thing about the Postgres community, or what do you like the least?
Of course, there are some parts of the community that could be improved. In particular, respondents highlighted the code contribution and development process, as well as a possible fragmentation in the community.
What would make the Postgres community better, or more welcoming to newcomers?
Respondents shared many concrete, constructive suggestions, some of which we have shared below. At Timescale, we are committed to building a more welcoming and inclusive industry. We hire team members who display attributes of kindness and cooperation, and we take our role as stewards of communities seriously. It shouldn’t come as a surprise that we aim to help the Postgres community achieve these same goals.
Timescale is a remote-first company, but even so, we love getting together as a team in-person. The past year has been challenging, but as eternal optimists, we’re looking ahead to a future where we can meet and share our experiences face-to-face.
In the meantime, we wanted to understand which virtual events Postgres developers would recommend their friends and colleagues attend?
We encourage you to read the full results of the State of Postgres 2021 and download the data yourself. Our goal is to further dialogue and understanding within the Postgres community.
Let us know what you think on Twitter (#StateOfPostgres) or on our Slack Community.