Bytes • Logic & Latency
2026
- Talk
What it takes to make a Postgres connection pooler invisible to your app: session settings, shared prepared statements, LISTEN/NOTIFY and failed commits.
-
How we test connection pooling in Multigres, and what a 100% pass rate actually tells you about correctness.
- Talk
How the Multigres pooler supports transactions, temp tables and LISTEN/NOTIFY without falling back to session pooling.
-
We test the scalability of Multigres' native connection pooler past 16,000 connections, and prove real Postgres compatibility by running Miniflux unmodified on a Multigres cluster.
-
In a single database, prepared statements parse once. Behind many gateways that win quietly evaporates. How Multigres consolidates prepared statements so Postgres parses each one exactly once.
-
Connection pool modes force a tradeoff between performance and correctness. Multigres figures out per-query which mode a connection needs, so you never have to choose statement, transaction, or session mode.
-
Why Multigres gives every user a dedicated connection pool (mostly a security story), how it shares a fixed budget fairly with max-min fairness, and the bucketing trick that keeps lookup fast.
-
Most connection poolers do two jobs in one process. Multigres splits them: multigateway accepts clients, multipooler manages backends. This is why.
- Talk
Building a custom connection pooler for Multigres: extended query protocol, per-user pools for RLS, and prepared statement consolidation.
- Talk
Why Multigres bundles pooling, HA, backups and sharding into one system for Postgres, and how its query-serving layer works.
-
Same engineer. Same complexity. A year last time, eight weeks this time. This isn't a story about AI writing code. It's a story about the system, expertise, and discipline that made AI actually useful.
2025
-
An introduction to the technical side of B³ - where I share insights about distributed systems, HA patterns & all things code.
- Talk
How Vitess implements two-phase commit across shards, and how we fuzz it to check commits really are all-or-nothing.
-
Learn how PlanetScale keeps its private fork of Vitess up-to-date with OSS
2024
- Talk
What Vitess is, how its architecture fits together, and a demo of how it serves queries as a distributed database.
2023
-
PlanetScale launched support for foreign key constraints. This article covers some of the behind-the-scenes technical challenges we had to overcome to support them.
2022
- Talk
High availability in Vitess with VTOrc: failure detection, automatic failovers, and durability policies built on semi-sync replication.
-
Exploring VTOrc, the new Vitess-native orchestration tool that automates fault detection and repairs
- Talk
Vitess's architecture and features, plus a live demo of moving a running RDS database into Vitess and cutting traffic over.