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

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.

ergo

💻 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.

ClusterLabs