Produced | OSC Open Source Community (ID: oschina2013)
The report received 992 responses, the first edition of the report in 2019 gathered feedback from more than 500 developers, and the second edition in 2021 also sampled nearly 500 participants. Respondents from EMEA (Europe, Middle East, Africa) accounted for about half of all respondents, followed by North America at 25.9%, according to the two years of survey results.
In addition to sending the survey to past participants, Timescale has promoted it on social media, email newsletters (their own and 3rd parties), TimescaleDB and PostgreSQL Slack channels, PostgreSQL mailing list, Reddit, and Hacker News. Compared with the previous two times, the number of people participating in the survey has increased this year. Key findings from the report include: why respondents use PostgreSQL, how they contribute to the community, adoption across organizations, and favorite tools and extensions.
picture
"By organizing and publishing PostgreSQL status reports, we help developers and developer-focused companies and communities better understand what's going on with Postgres: the different types of Postgres users, the types of use cases they're working on, the A place to share and learn, how this has all changed, and opportunities for improvement for the entire Postgres community, which also gives us the opportunity to give back to the wider PostgreSQL community that we are proud to be a part of and have been very helpful to us ."
Some highlights from the report include:

  • DB engines  data points out that PostgreSQL is becoming more and more popular. The number of new PostgreSQL users who have tried the database for less than a year has grown from 6.1% in 2021 to 6.4% in 2022.

picture

  • Open source is the number one reason why people choose PostgreSQL (19.3%), followed by reliability (16.5%) and scalability (9.9%). The report notes that reasons for choosing PostgreSQL vary with experience. For those who have used PostgreSQL for less than 5 years, open source is the most important factor in their choice of PostgreSQL; for those who have used PostgreSQL for 6-10 years, reliability and open source are both important; 11- 15 years of people choose PostgreSQL mainly because of its reliability.

picture

  • 44% of PostgreSQL users with 15+ years of experience have contributed to PostgreSQL at least once. "In fact, all users contribute to the PostgreSQL community, regardless of their experience."

  • 55% of respondents said PostgreSQL is being used more today than it was a year ago.

  • More than three-quarters of respondents said they use PostgreSQL for personal projects, 95% use PostgreSQL at work, and 74% use PostgreSQL for personal and professional projects.

  • The majority of respondents (76.2%) said technical documentation was their preferred way to learn PostgreSQL, followed by long blog posts (51.5%) and short blog posts (43.3%). Respondents with less than 5 years of PostgreSQL experience preferred videos to blog posts.

  • In terms of community interaction, more than 20% of respondents said that the mailing list is their way of staying in touch with the community, although some respondents mentioned the difficulty of using the PostgreSQL mailing list as the main way to interact with the core team and the entire project one. Some other channels of engagement include Slack (10%), Stack Overflow (8%), blogs (8%), Twitter (6%) and Reddit (6%).

  • Respondents also shared some of their favorite PostgreSQL extensions. The top rankings are:

    • PostGIS

    • TimescaleDB

    • pg_stat_statements

    • pgcrypto

    • pg_trgm

    • Citus

    • uuid-ossp

  • SQL, Python, Java, shell scripting, and JavaScript/TypeScript are listed as the most commonly used languages ​​to access PostgreSQL. PostgreSQL users with 0-5 years of experience are more likely to use JavaScript or TypeScript than Java; users with 6+ years of experience are more likely to use shell scripting to access the database.

  • Among respondents using tools to connect to PostgreSQL for query and administrative tasks, psql (69.4%), pgAdmin (35.3%) and DBeaver (26.2%) were the top three choices.

  • Grafana, pgAdmin, and DBeaver are the most likely visualization tools.

  • Fewer respondents than in 2019 and 2021 said they would manage their own PostgreSQL database. It seems that PostgreSQL users are increasingly using DBaaS providers to deploy PostgreSQL. Of those deploying PostgreSQL as a Kubernetes container, 44% use Helm, 16% use the Crunchy Operator, and 7% use the Zalando Operator.

See the full report for more details: https://www.timescale.com/state-of-postgres/2022

END



Conversion and retention in community operations - four common problems
picture

OSC Open Source Community

, like 22


Here are the latest open source information, software updates, technical dry goods, etc.
Click here↓↓↓ Remember to follow ✔ Star ⭐ Oh~