#​608 — July 17, 2025

Web Version
Together with  Rocketadmin

Postgres Weekly

📊 Xata's Reaction to PlanetScale's Postgres Benchmarks — PlanetScale’s entry into the Postgres world has sparked widespread attention, with other providers scrutinizing their benchmark results. Xata, another major platform, examines PlanetScale’s methodology, runs their own benchmarks, and highlights the challenges of conducting accurate, fair benchmarks given all the variables involved.

Tudor Golubenco (Xata)

💡 The folks at Neon have also taken a look at PlanetScale's benchmarks and show off the impact of their specific extra caching layer.

Rocketadmin: A Swiss Army Knife for Your Backoffice — Learn about our open-source, flexible, and secure admin panel service and how to integrate it into your workflow. Give strict permissions to users, create Automations and UI Widgets, and explore your database with AI Insights.

Rocketadmin sponsor

LISTEN/NOTIFY Does Not Scale — As interesting as LISTEN/NOTIFY are, I’ve never felt the urge to use it – the mechanism just feels uneasy versus the usual query→result approach. This look at scaling issues around lock contention does little to change my mind.

Elliot Levin

Billions of Edges Per Second with Postgres — An introduction to OneSparse, a Postgres extension that uses SuiteSparse’s GraphBLAS library to turn tables into high-performance sparse matrices and back again with no external graph database needed. It requires some explanation to understand, but luckily Michel goes into a lot of depth here.

Michel Pelletier

IN BRIEF:

📄 Comparing Postgres' Storage Options – A quick comparison of standard row storage, column stores, CSV, and Parquet. Hans-Jürgen Schönig

⚙️ stripe-sync-engine: A Stripe-To-Postgres Sync Engine as a Standalone Library Kevin Grüneberg (Supabase)

📄 Fixing Slow Row-Level Security Policies Dian Fay

🛠 Code and Tools

pdot: Interactive Directed Graphs of Your Database — A tool that produces GraphViz or Mermaid definitions to render graphs showing off various things in a Postgres database, like table relationships, foreign key graphs, triggers and functions, RLS policy relationships, and more.

Dian Fay

Odyssey 1.4: A Scalable Postgres Connection Pooler — A production-ready, Linux-only connection pooler and request router out of Yandex. v1.4 focuses on fixes and stability – there’s also a new Telegram chat room for support.

Yandex

📰 Classifieds

🐘 Atlas manages Postgres like Terraform manages infra. Define schema as code and safely plan and apply migrations. Find out more.

💌 Did you know we have a whole family of newsletters? Check out JavaScript Weekly, Go Weekly and Ruby Weekly for a broader look at what we do.

Endor: Add Services (like Postgres) as Node Dependencies — A curious new effort to make it possible to spin up quick, sandboxed environments and servers, covering things like Postgres, MariaDB and Valkey, with a simple npm install and endor run.

Angel M Miguel (Endor)

Redka: Redis Re-Implemented with SQL — A Go-powered data store that’s compatible with Redis’s API but uses SQL behind the scenes to make it all work. Till now it’s been based on SQLite but v0.6 introduces Postgres support.

Anton Zhiyanov

  • FerretDB 2.4 – A database that acts like MongoDB but uses Postgres for storage.

  • QuestDB 9.0 – Java-powered time-series database with Postgres wire protocol compatibility. Now with true N-dimensional arrays and materialized view improvements.

  • 🤖 pgai 0.11 – Timescale's tools to work with RAG and LLMs in Postgres.

  • qsv 6.0 – CLI tool for querying, slicing, filtering, transforming, sorting, and converting tabular data.

  • Squawk 2.20 – Linter for Postgres migrations and SQL.

  • PostgreSQL Anonymizer 2.3

  • OrioleDB Beta 12