THE COLLECTION

Library

Everything you’ve found. Nothing you need to save twice.

2 articles
Browse at your own pace.

The era of personal software

The author describes building a custom health tracking web app to collect data from his devices. He uses automated exports, a hosted Postgres database, and AI agents to log meals and give insights. He argues that LLMs make personal software cheap to build, but not a full replacement for existing tools yet.

Debugging deadlocks in Postgres

Argues that Postgres deadlocks (SQLSTATE 40P01) usually reflect inconsistent lock ordering in transaction design, best fixed by restructuring operations into a consistent order. Case study: two seemingly identical bulk upserts deadlocked because rows were randomly ordered (a Go map converted to a slice) and Postgres acquires locks row-by-row during inserts; sorting rows solved it. Alternatives like explicit locks (FOR UPDATE, advisory locks) or jittered retries trade off parallelism and raise lock timeout risk.