THE COLLECTION
Library
Everything you’ve found. Nothing you need to save twice.
2 articlesBrowse at your own pace.
j
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.
jakub.kr10 minintermediateUnread
i
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.
incident.ioLouis Heath5 minintermediateRead1 answer