#​580 — December 4, 2024

Web Version
Together with  Honeybadger

Postgres Weekly

Amazon Aurora DSQL: A New Postgres-Compatible Database — In ‘preview’ for now, DSQL’s promise is ‘virtually unlimited scalability’ with high availability and strong consistency, while being Postgres compatible (kinda..? No views, triggers, JSON, or foreign key constraints..). AWS Hero AJ Stuyvenberg calls it “the single most exciting launch I’ve seen from AWS in a while”, so watch this space. (Official press release.)

Amazon Web Services

💡 AWS's Marc Brooker has put together a personal blog post about DSQL that explains things a bit more, as well as some of the choices made in its architecture.

Full-Stack Observability from Honeybadger — Honeybadger's new logging platform is a bit like Splunk, DataDog, or CloudWatch Logs, but with just the good parts and a reasonable price tag. Plus, it's easy to integrate with Crunchy Bridge, Journald, AWS, and more!

Honeybadger sponsor

What I Wish Someone Told Me About Postgres — A diverse grab-bag of practical tips covering areas from normalization and the use of different types to SQL ‘eccentricities’, locks, and the use of JSONB.

Hazel Bachrach

QUICK BITS:

Transactional Schema Migration Across Tenant Databases with pg_karnak — If you run a setup where each tenant/user of your system has its own database, maintaining the schemas across them can rapidly become tricky. pg_karnak is Nile’s distributed DDL layer for coordinating schemas across tenants. It hasn’t been open sourced yet, but this post digs deep into how it works.

Gwen Shapira (Nile)

The substring Function, Regex Style — While you can use Postgres’ substring function to extract parts of strings using numeric indices, did you know it supports using regular expressions too?

Leo Hsu and Regina Obe

Optimizing Postgres Performance and Compression: pglz vs. LZ4 — Did you know you can change the algorithm used to compress your TOAST data? It might be worth it if LZ4 is as fast as we see here.

Keyur Panchal (Timescale)

📄 Writing Composable SQL using Knex and Pipelines – Knex.js is a popular SQL query builder in the JavaScript space. Aycan Gulez

📄 Unique Constraint Violations During Inserts Can Cause Bloat Josef Machytka

📰 Classifieds

🚀 pgai Vectorizer automates embedding creation and syncing in Postgres with one SQL command—keeps embeddings updated, no tools needed.

🚀 Looking for fast, accurate search? Power up your query capabilities with MongoDB Atlas Vector Search.

🛠 Code and Tools

Supabase Cron: Job Scheduling in Postgres — A module that uses the pg_cron extension to manage recurring jobs on the Supabase platform (both via the dashboard or SQL).

Vasilov, Rice, and Sutton (Supabase)

  • 🤖 pgai v0.2 – Timescale's tools to work with RAG and LLMs in Postgres. With v0.2, its vectorizer now supports Ollama.

  • pgwire 0.27 – The Postgres wire protocol implemented in a Rust library.

  • PgParty 1.9 – Create Postgres partitions from Active Record in Ruby.