Company
Date Published
Author
Ryan Booz
Word count
2107
Language
English
Hacker News points
5

Summary

The State of PostgreSQL 2022 survey has been analyzed, and the results show that performance and tooling are two topics that drive discussion year after year. The survey focused on three specific use cases: querying and administration, development, and data visualization. Popular tools for querying and administration included psql (69.4% of respondents), pgAdmin, DBeaver, Datagrip, and IntelliJ IDEs. For development, pgcli was mentioned frequently, as well as Azure Data Studio, which provides features such as SQL-based Jupyter Notebooks and export to Excel without plugins. Other tools that gained attention from community members include Postico for MacOS users, pgBadger for cluster monitoring and performance analysis, pganalyze for query plan insights, Depesz EXPLAIN and Dalibo EXPLAIN for quick explain plan analysis, pgMustard for advanced insights, QGIS for spatial data visualization, Superset for data visualization and dashboarding, Streamlit for Python-based data analysis and visualizations. The survey also highlighted the importance of third-party PostgreSQL tools, including management features like pgBouncer and cluster monitoring tools like pgBadger.