Generating SVG Images from Postgres — pg-svg is a set of functions for creating SVG graphics from within Postgres. Its main use case is for converting PostGIS geometries into graphics as demonstrated in this thorough introduction (complete with an epic query), but you can use it independently of PostGIS too.

Martin Davis (Crunchy Data)

Postgres 16 Beta 1 Released — We are now truly on the fairway leading towards Postgres 16's eventual release. The draft release notes tease all of the updates, with particular improvements coming to performance, query parallelism, SQL/JSON, security, monitoring, and more.

PostgreSQL Global Development Group

Materialized Views: Precompute with Postgres — Learn the benefits of using materialized views in Postgres for analytics, the differences between materialized and regular views, and tips for optimizing their use.

Hydra sponsor

How to Use Variables in psql — You can set variables in psql using \set or by passing them in at the command line. Hubert shows off some uses.

Hubert depesz Lubaczewski

HypoPG 1.4.0: Hypothetical Indexes for Postgres — You can use HypoPG to create indexes that don’t really exist but which can be used to determine out if said indexes could be used by the query planner to improve performance. This week’s release makes it possible to support the opposite: hypothetically hiding existing indexes. GitHub repo.

Julien Rouhard

pg_dumpbinary v2.11: Dump a Database in Binary Format — Use pg_dump if you can, but if you encounter unusual situations where a binary dump would help – this is for you. GitHub repo.

Gilles Darold

Diesel 2.1: Extensible ORM and Query Builder for Rust — Gets rid of the boilerplate around database interaction in Rust without sacrificing performance. Supports Postgres, MySQL, and SQLite.

Diesel