Issue 328 - PostGIS 3.0 released (11)

Aquameta: An Experimental Web Development Platform Built Entirely in Postgres — I’m a big fan of using the right tools for the right job, but this is an interesting project nonetheless. Apps in Aquameta are “represented entirely as relational data”.

E-Maj 3.2.0: A Way to Log and Rollback Table Updates — E-Maj logs updates performed on tables (of your choice) and lets you cancel/rollback such updates at will. v3.2 introduces Postgres 12 support.

PgBouncer 1.12.0: A Connection Pooler for Postgres — 1.12 includes fixes to SCRAM support improving interoperability with newer Postgres versions.

How to Never Lose a Transaction with pg_receivewal — pg_receivewal (formerly pg_receivexlog) streams a Postgres server or cluster’s write-ahead log in real time and can be used to avoid data loss in even ‘dire circumstances’.

PostGIS 3.0.0: Geospatial Objects for Postgres — A long time in the coming, PostGIS 3.0 takes the popular spatial Postgres extension into the Postgres 12 world, moves raster support into a separate extension, and significantly improves performance via parallelization (a bit more about this here).

Auto Failover with PostgreSQL 12 — The team behind pg_auto_failover, an extension for automated failover for Postgres clusters, reflect on how it’s been upgraded to support Postgres 12.

Generating Land-Constrained Geographical Point Grids with PostGIS — I’ve never had a need to use PostGIS so far, but tutorials like this certainly make it look appealing. Clever stuff.

A Beginner’s Guide to Formatting Dates in SQL — Date and time types can often throw up challenges in SQL, so it’s good to have tutorials that reflect on the various ways to work with them.

Sending Notifications From Amazon Aurora PostgreSQL — As a managed service, Amazon Aurora restricts your access to useful extensions for sending notifications directly from its Postgres-compatible database implementation.. so how can you get notifications after database jobs complete? Here’s how to do it.

Real-Time Postgres Performance Monitoring — Collect out-of-the-box and custom PostgreSQL metrics and correlate them with data from your distributed infrastructure, applications, and logs. Gain real-time performance insights and set intelligent alerts with Datadog. Start a free trial.

eBook: How to Get a 3x Performance Improvement on Your Postgres Database — The pganalyze team shares their best practices, learned over the last few years by helping companies like Atlassian optimize their Postgres databases.