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 problem.
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 our doors with pitchforks by avoiding a new database migration.
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.
River v0.41 now supports Turso , a ground-up rewrite of SQLite in Rust that aims for full SQLite compatibility.
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.
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.
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.)
Published fragment The paradox of free time , on how a long stretch of open, contiguous time makes you … less (?) productive.
Updated now , on moving to Austin, working on River, and life after Stainless.
Published sequence 111 , Ladyslipper. Bunches of ladyslippers in the Wagner Natural Area near St. Albert/Edmonton. Here we show a few of the hundreds just a few feet off trail. The flowers were nice but they’d better be – thousands of mosquitoes feasted on us as we made the walk. My kill count was in the hundreds and I still took dozens of bites by the end.
Published sequence 110 , Bull Creek Hills. A mountain meadow along a hike up into Bull Creek Hills via Marston Creek, in Kananaskis Country, Alberta. Walked this one with my parents’ hiking groups, The Ramblers, and experienced a catastrophic failure of my 25-year-old hiking boots midway through.
Published sequence 109 , Monolith. This building is called the “Marie-Elisabeth-Lüders-Haus”, near the Bundestag. I’ve never been inside, but its website says it provides “scientific services”, and houses the parliamentary library and archives. It’s one of my favorite buildings in Berlin – an enormous, imposing monolith towering up and over the Spree. Very…
Published sequence 108 , Canals. Walking Berlin in the spring is one of the best urban experiences on Earth. I got in the habit of doing evening walks down into Kreuzberg and circling around along the Landwehr Canal , taking in sunset and walking the rest of the way back in the early night. This photo is the last rays of the sun near Lohmühlenbrücke, where two canals intersect.
Published sequence 107 , Fountain and Ruinenberg. A fountain near Sanssouci and looking out to Ruinenberg . Taken on a walk through Potsdam, something that’s become somewhat of an annual tradition when I go visit Berlin. Potsdam is a superior version of Versailles (less castle, more greenspace), and both Sanssouci Park and the surrounding town are some of the best places to explore anywhere…
A tweet from the creator of Homebrew worth thinking about: I think I will give up. I have made a bunch of very interesting things over the last 6 months. But I cannot get any attention for them and don’t know how. My son is 4 and he deserves my time. I’m going to go and get a normal job. My time making things is over I think. We’ve entered an economy where far more can be generated…
Published fragment Rich, fully attributed context timeout errors in Go , on making Go’s generic context deadline exceeded errors traceable with small helpers that attribute the operation that timed out and spell out how long the timeout was.
Published fragment SQLite bulk insert with sqlc , on using json_each and json_extract to achieve this end.
Published fragment Generating words? Keep them short. .
We shipped an insert-only TypeScript package for River . Like the equivalents for Python and Ruby, it’ll emit jobs from a TypeScript project that’ll be worked over in Go code.
Nanoglyph 052 is published, on life after acquisition, the minimum viable unit of saleable software and whether River can qualify, Balkan Ruby in Sofia, and hiking in the Vitosha mountains.