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:

• Occasionally injected clocks in Postgres June 29, 2025

  Using a coalescable parameter to stub time as necessary in tests, but otherwise use the shared database clock across all operations.

• Testing the graceful handling of request cancellation in Go, 499s June 19, 2025

  Using built-in net/http facilities to make sure that canceled requests are abandoned immediately to save time and resources.

• Be careful with Dropbox May 25, 2025

  Fun times with Dropbox’s new ~/Library/CloudStorage location and File Provider API integration.