Our love for PostgreSQL runs deep. We built our products on PostgreSQL, are proud members of the PostgreSQL community, and wouldn’t exist without it and the extensibility it provides.
In 2019, Timescale launched the first State of PostgreSQL report, advancing our desire to provide greater insights into the specificities and features useful to the PostgreSQL community. Following a one-year hiatus due to the pandemic and after the 2021 survey submissions, we released the 2021 report.
We are pleased to announce that the 2022 survey is now open for submissions! We are keen to learn more about how you use PostgreSQL for work and personal projects, how you deploy it, and how we can collectively improve it.
✨
Help us give back to this awesome group: answer survey questions and share with other PostgreSQL users. We are excited to hear your thoughts and spark a conversation that will keep us moving forward and building better things together. 🙌 We will share our report (as well as give you full and free access to the survey’s anonymized raw data) in July. Thank you for being a part of the community!
The State of PostgreSQL in 2019 and 2021
So, what have we learned from the two years we sent out our survey? You will find the few key findings here, but check out our reports for a full picture. From the most used programming languages to whether developers use PostgreSQL for work or personal projects (or both!), favorite features, and qualitative answers, The State of PostgreSQL paints an accurate and informative portrait of this great community.
Sample
Five hundred developers answered our survey in 2019, and 445 participated two years later. In both years, respondents mainly were software developers/engineers, software architects, and database administrators from the EMEA (Europe, Middle East, Africa) region.
PostgreSQL usage is growing
Around 67 % of developers said they were using the database “more” or “a lot more” in 2019, compared to 52 % in 2021. However, the number of participants using it “about the same” increased from 31 % in 2019 to 43 % in 2021.
Use cases: Building applications at the top
Building applications is the primary use case for PostgreSQL developers, totaling 70 % in 2019 and 67 % in 2021.
Code contributions are crucial to open-source software development, and PostgreSQL successfully mobilizes its community. In 2019, about 9 % of respondents contributed their code to the database, and 11 % claimed to do it two years later.
Why do you use PostgreSQL?
In both surveys, developers said that reliability and SQL were the main reasons they use PostgreSQL.
The way developers deploy PostgreSQL is changing
In 2019, 51 % of respondents deployed PostgreSQL using AWS, while 46 % relied on a self-managed data center. In 2021, the self-managed option took the lead, with 36.4 % deploying on-site, 35.3 % from a private data center, and 32.8 % on a public cloud. In 2021, AWS was the leading cloud provider, with 46.1 % of the answers.
If you’ve got any feedback or questions on The State of PostgreSQL, let us know on Twitter or join Timescale’s Community Slack and message us in #general.
How OpenSauced Is Building a Copilot for Git History With pgvector and Timescale
