Primary PII
2024.310A regulation arrives. The work looks like encryption at first. It is not.
Databases
tag:
databases
all tags →2024
Redis caching patterns
2024.172Cache-aside, write-through, write-behind -- and the three problems that make caching hard: stampedes, coordinated expiry, and invalidation.
2021
PostgreSQL HA
2021.074Streaming replication, automated failover, and the operational lessons that aren't in the PostgreSQL docs -- split-brain, silent lag, and why DR drills matter more than DR plans.
2019
Learning Postgres under fire
2019.258The index was there. The query was right. Postgres stopped using it anyway.
2018
The week pgbouncer stopped being news
2018.193Transaction pooling, one SET that didn't stick, and a standup that moved on.
2013
MySQL on XFS
2013.101Using bind mounts to move MySQL data, config, and logs to an XFS volume without changing a single MySQL setting.
2012
Rolling your own search
2012.074Building catalog search with flattened MongoDB documents and application-side scoring when the proper tools don't exist yet.