category
Deep dives
Long, technical, and unapologetic: protocols, databases, and how systems actually work.
-
A flight recorder for Postgres Why database incidents stay unexplained, what aviation figured out about that decades ago, and the design thinking behind Tracegres: incidents should be reconstructable, not anecdotal. -
Prepared statements vs connection pools Part three of speaking fluent PostgreSQL: why the query that works locally dies behind pgbouncer, explained from the wire up, and every fix ranked. -
Faking pg_catalog Part two of speaking fluent PostgreSQL: the system catalog is the real compatibility surface. What psql and every GUI tool actually ask, the five tables that carry the load, and how to build a catalog shim from captured traffic instead of guesswork. -
Speaking fluent PostgreSQL What implementing the Postgres wire protocol from three directions taught me: the startup dance, the two protocols hiding inside it, why transactions are the hard part, and the compatibility lies every Postgres-compatible database must tell.