📄 JSONPath: A Query Language for JSON – [PDF] — If you’ve heard that Postgres 12 has support for SQL/JSON (which Markus Winand has called "the most complete and correct .. implementation I've seen.") and wondered why that’s a big deal, this set of code-rich slides should fill you with ideas. I’m always a bit wary of linking to slidedecks, but these deserve a look as they're very good.

Oleg Bartunov

PostgreSQL 12.1, 11.6, 10.11, 9.6.16, 9.5.20, and 9.4.25 Released — A wide variety of releases to fix over 60 bugs that were reported in the last several months (including many which only affect Postgres 12). This is also a good time to note 9.4 will no longer receive such fixes after February 2020, so consider getting an upgrade plan into place if you’re still using it.

PostgreSQL Global Development Group

Whitepaper: Harden Your PostgreSQL Database — Learn about Database Security and develop a deep understanding of industry best practices. Explore how to harden your PostgreSQL cluster and have confidence that your data is adequately protected from malicious attacks.

2ndQuadrant PostgreSQL Whitepapers sponsor

An Interview on What Makes Postgres Unique (Extensions) — Dimitri Fontaine interviewed Craig Kerstiens about the importance of extensions in the Postgres ecosystem and what his favorites are.

Craig Kerstiens

Dealing with Similarity in Postgres and Rails using Trigrams — A tutorial aimed at the Rubyists amongst us (yes, we have a newsletter for that) but the lessons can be used by any Postgres user as it leans upon pg_trgm, a core Postgres module that provides functions for determining the similarity of strings based on trigram matching.

Leigh Halliday

effective_cache_size: What It Means in Postgres — A brief explainer of what the effective_cache_size config setting is for and how it helps Postgres’s query planner.

Hans-Jürgen Schönig

Avoiding 'OR' for Better Query Performance — A look at different kinds of queries using SQL’s OR and how to rewrite them without OR for better performance.

Laurenz Albe

Downloading Large Heroku Postgres Backups — The Heroku PaaS provides a variety of tools for working with Postgres databases including creating forks of your database, scheduling backups, downloading dumps, and more.

Justin Searls

check_pgbackrest 1.6 Released — pgBackRest is a Postgres backup and restore tool but check_pgbackrest is a Nagios plugin that monitors the backups pgBackRest takes.

Dalibo

Crunchy High-Availability PostgreSQL Keeps Critical Applications Up — Leverage trusted open source software to ensure your PostgreSQL data is always available.

Crunchy Data sponsor

Scaledger: A Double-Entry Accounting Database with a Typed GraphQL API — The API is introspected directly from a Postgres schema.

df8

pg-minify: Minifies PostgreSQL Scripts, Reducing IO Usage

Vitaly Tomilov