July 2022 Summaries

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.

This paragraph summarizes the text: David Bailey, an intern at the Wendelstein 7-X fusion reactor experiment, uses TimescaleDB to monitor the reliability of the reactor's heating system. He collects and handles various types of data using TimescaleDB, including general health metrics, log messages, and detection events. The database provides a well-balanced mixture of features, being built on top of PostgreSQL while still giving access to regular relational database features. David uses Grafana extensively to plot the measurements with just a few SQL queries, which would have been much harder without it. He is motivated to share his experience with others in his field and wants to motivate his research institute to install a proper multi-node TimescaleDB cluster.

We analyzed the State of PostgreSQL survey, which revealed that most respondents (54.4%) are located in the EMEA region, followed by North America. The majority of users have been using PostgreSQL for six or more years, with 6.4% being new users experimenting with it for less than a year. Most users work as software developers/engineers, followed by database administrators and software architects. The survey found that over 300 respondents contributed to the PostgreSQL community, regardless of their experience level. Three tools stood out among respondents who use them for queries and administration tasks: psql, pgAdmin, and DBeaver.

Prometheus and OpenTelemetry are two metrics systems used in observability, with Prometheus being a standard tool for monitoring systems and OpenTelemetry offering a more flexible and unified standard for traces, logs, and metrics. While both systems allow code instrumentation via SDKs, OpenTelemetry supports automatic instrumentation without adding code to applications, but also has limitations compared to Prometheus, such as not supporting delta representations or exponential histograms. The two systems can be converted between each other with minimal loss of precision, but some metric types may change slightly. Most organizations will likely mix both standards, and the choice between them depends on priorities such as stability, flexibility, and specific use cases, with Promscale being a long-term store for Prometheus metrics that seamlessly integrates with Prometheus and offers 100% PromQL compliance.