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:

• Your Go version CI matrix might be wrong August 11, 2024

  As of Go 1.21, Go fetches toolchains automatically, and it’s easy to not be running the version that you thought you were running.

• Elden Ring July 25, 2024

  I broke my promise never to give FromSoftware money again, and it was okay.

• Sqlc: 2024 check in June 16, 2024

  Quick thoughts on whether sqlc is still the direction for Go projects now that we’ve been using it for three years.