I'm @brandur, an occasional writer, and engineer at Stripe and previously Heroku.
I most often talk about web APIs, Postgres, Rust, software safety and resilience, efficient human interfaces, and running.
The traditional soft deletion pattern using
deleted_at columns leaks into code, curbs the usefulness of foreign keys, and makes data removal difficult. Luckily, there’s an alternative. July 19, 2022
text type in Postgres, why it’s awesome, and why you might want to use
varchar anyway. Also, a story about trying to get string parameters bounded at Stripe. September 10, 2021
Touring the ORM and Postgres landscape in Go, and why sqlc is today’s top pick. September 8, 2021
Older articles available here.
Tracking improvements to Postgres partitioning since 2017. In just five years it’s gone from a non-feature to a very good one. October 5, 2022
Older fragments available here.