Once in a while, I write longer form articles on technical subjects like APIs, Go, or Postgres:

• Eradicating N+1s: The Two-phase Data Load and Render Pattern in Go May 28, 2024

  Using a two-phase data load and render pattern to prevent N+1 queries in a generalized way. Especially useful in Go, but applicable in any language.

• The Notifier Pattern for Applications That Use Postgres May 5, 2024

  Maximizing Postgres connection economy by using a single connection per program to receive and distribute all listen/notify notifications.

• Web APIs: Enriched DX By Disallowing Unknown Fields May 4, 2024

  Using Go’s DisallowUnknownFields option to improve an API’s integration experience by making paramter naming mistakes faster to resolve.

I put short stream of consciousness thoughts into tiny posts called fragments:

• Optimizing JPEGs with MozJPEG for local archival March 29, 2025

  Writing a wrapper script around MozJPEG to achieve ~80% compression on large JPEGs with little downside.

• The right way to do data fixtures in Go March 20, 2025

  A safe, succinct test data fixtures pattern using sqlc and validator.

• Profiling production for memory overruns + canonical log stats February 2, 2025

  Using Go’s runtime.MemStats and canonical log lines to isolate huge memory allocations to a specific endpoint.