#347 — March 18, 2020

Read on the Web

Postgres Weekly

Understanding Recursive SQL Queries — Recursive common table expressions make it possible to work with dynamic graph or hierarchically structured data within Postgres. This is quite a nice, gentle introduction to the idea to allow you to move on to more advanced guides.

Martin Heinz

Postgres is the World's Best Database: Here's Why — Yes! We need a little cheerleading this week, so why not cheerlead for Postgres? 😄 “I intend to prove that by virtue of both design and implementation that PostgreSQL is objectively and measurably a better database than anything currently available..” All good arguments, too.

Kirk Roybal

Your Data Is Your Business — PGX is a full-service database consultancy focused around PostgreSQL systems. Let us help you architect, build, troubleshoot and scale your PostgreSQL data systems on any platform or hosting environment.

PostgreSQL Experts, Inc. sponsor

An Overview of Generated Columns — It’s been several months since we enjoyed Rob Conery’s dive into generaed columns but as one of Postgres 12’s headline new features, it’s worth getting up to speed if you haven’t already. The basic idea is that generated columns are special columns which contain data calculated on the fly from other data on the row, a little like spreadsheet functions.

Brian Fehrle

Is Database Interoperability at Risk? — Bruce reflects on the current case going on between Oracle and Google over the latter’s alleged ‘copying’ of the Java API and whether it could affect database systems ‘copying’ each other’s SQL-related additions.

Bruce Momjian

Spatial Tile Serving with Postgres Functions — How to use functions along with PostGIS to generate dynamic map tiles on-the-fly with pg_tileserv and Crunchy Spatial.

Paul Ramsey

▶  Azure Arc: Bring Hyperscale PostgreSQL to On-Premises and Multi-Cloud — Azure Arc is a still in-preview approach to deploying Azure services ‘anywhere’ across on-premise, edge, and multicloud environments.

Umur Cubukcu and Nikhil Patel

Postgres's Date and Time Data Types Explained

Li Zhennan

How to Authenticate Postgres Users Against Amazon AWS Cognito — Cognito is a centralized user authentication system provided by AWS, but can it be used to authenticate Postgres users? Sort of. This post presents an initial attempt at solving the problem.


💻 Live Webinar: How to Analyze Your Prometheus Data in SQL — Learn how (and why) to use PostgreSQL to store & analyze monitoring metrics, write custom queries, visualize results in Grafana, and more.

Timescale sponsor

pgagroal 0.5.0: A High Performance Postgres Connection Pool — Boasts significant performance compared to the (unnamed) competition. 0.5.0’s primary new feature is SCRAM-SHA-256 support.

RedHat Inc.

check_pgbackrest 1.8: The pgBackRest Backup Monitor — So if you’re using pgBackRest for your Postgres backups, check_pgbackrest can plug into Nagios to keep an eye on things.

Stefan Fercot

PAF (PostgreSQL Automatic Failover) 2.3.0 Released — A Pacemaker and Corosync based approach. Adds support for Postgres 12.


🗓 Upcoming Events

Note: Due to the travel disruption caused by the ongoing COVID-19 outbreak, please check the status of events you are attending or wish to attend. We are checking each event we list prior to publication, but the situation can change quickly and it seems very likely most in-person events will be postponed or cancelled.

  • Swiss PGDay 2020 (June 18-19 in Switzerland) — A two track conference (one in English, one in German) aimed at the entire Postgres community.
  • Postgres Vision 2020 (June 22-24 in Boston, MA)
  • Postgres Ibiza 2020 (June 25-26 in Ibiza, Spain) — A two day conference on the sunny island of Ibiza in the Mediterranean. I recall this one getting some great trip reports last year!

We are considering reworking this section to list virtual events such as webinars, Twitch streams, and similar online get-togethers. If you are running any, please let us know!