I got a nice shout-out from Ben Dicken over the weekend on an old article I’d written on managing database connections. (This guy is apparently the Mick Jagger of databases, because I can’t remember having gotten so many inbound LinkedIn in…
Published fragment Does anyone run Postgres without PgBouncer?, on how nearly every notable managed Postgres provider bundles a connection pooler, giving us a strong hint that connection management is a product problem rather than a user pr…
Published Migration fatigue, and how LLMs help us avoid it, on how we used an LLM to optimize a core query in active job rescue. The optimized version ran up to 130x faster compared to baseline, and prevented exasperated users knocking on o…
Published fragment River binaries will get 10 kB lighter, on removing accidental test-only transitive dependencies that added about 10 kB to every Go binary built with River.
Published fragment pgtestdb’s template cloning approach to testing is fast, on how Postgres template databases enable database-per-test isolation in around 100 ms, within spitting distance of River’s schema-based approach.
I was reminded by Cup o’ Go yesterday of the existence of Peter Downs’ pgtestdb, a Go/Postgres testing package. pgtestdb is built around Postgres template databases, a built-in feature that you can try right from a vanilla psql shell: CREAT…
Published fragment I used to add links by hand, on how LLMs now drive most of this blog’s workflows, replacing what used to be a lot of small, manual edits.
I was reflecting on how the rise of LLMs has changed my workflows when it comes to this blog. I continue to maintain a strong certified human charter that guarantees all content here is written by a human hand, but I use LLMs frequently for…
We shipped active job rescue, a new River Pro feature that uses queue heartbeats to quickly recover jobs orphaned by crashed clients. (If you’re on Pro, try it today! No configuration or schema change required.)
An odd effect I’ve noticed over the years is that when I have a whole day free to do something versus a tight two hours before I have to go somewhere and/or meet someone and/or tend to some other responsibility, I’ll get more done in the tw…
I’ve often cited Sofia Coppola’s Lost in Translation (2003) as one of my favorite movies. I’d never dug much into Coppola’s other work, so imagine my delight to discover that she’s made another movie, Somewhere (2010) with a similar premise…
I’ve written previously about my misgivings with static sites on AWS, and while some of those points are still valid, there’s no question that the maturity of the AWS product and the incredible surface area that its products cover easily ma…