Andrei Mackenzie

Andrei Mackenzie

Principal Software Engineer at DealRoom

19Aug 2026

tmux Agent Status

In the old days when I wrote code manually, my sweet spot for multi-tasking was two: a priority task and a background task to work on if the first one became bl...
10May 2026

The Case for SQL Templates

Most kinds of web applications require some way to persist state. Relational databases like Postgres and Mysql are good general purpose choices, but how should...
11Apr 2026

Transcribe Audio with Silero VAD and Whisper

The Pytorch ecosystem greatly simplifies addition of machine learning features to applications. Pre-trained models suitable for a variety of tasks are available...
17May 2022

Forward Compatibility

Martin Kleppmann's excellent Designing Data-Intensive-Applications includes much wisdom for how to evolve applications without incurring downtime. A key concept...
13Dec 2012

Altering Large InnoDB Tables

Large InnoDB tables in MySQL present a common challenge: How are columns best added or removed? For this article, "Large" means millions, possibly several hundr...