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.
Postgres: Boundless `text` and Back Again
The 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
How We Went All In on sqlc/pgx for Postgres + Go
Touring the ORM and Postgres landscape in Go, and why sqlc is today’s top pick. September 8, 2021
Minimally Invasive (and More Accurate) Analytics: GoAccess and Athena/SQL
A privacy and GDPR-friendly approach to producing basic and complex site analytics, and one which is more accurate in an age when adblockers reign supreme. February 16, 2021
Older articles available here.
There's always an events table
If you’re going to have an events table, delete old stuff, and do so in batch queries with a LIMIT
. Consider partitioning. May 1, 2022
Older fragments available here.