Writing
RSS- 2022-09-21 INSERTing Sequential Scans Showing one way pg_stats can ruin your query performance with sequential scans.
- 2021-04-09 Avoid Costly Rails Logging Efficiency gains with Rails.logger block syntax.
- 2020-11-09 Battling RecordNotUnique in Rails A quick tour of the unique-constraint battlefield in Rails.
- 2019-11-17 Five Years of MARTA Coding A look at MARTA's open transit APIs after five years of building marta.io.
- 2019-05-06 Your First DB Index, by Example Going from nothing to index-only scanning, EXPLAINing throughout.
- 2017-08-17 The Night the PostgreSQL IDs Ran Out Your primary key column runs out of values and your database starts exploding. What now?
- 2015-07-01 300 Days in: Engineering at CallRail Where did those 300 days go, and what's been keeping me busy?
- 2015-02-26 Filling MARTA Realtime Gaps Going from realtime to realtime-ish with MARTA's train API.