• Ratcheting SQL Queries: reducing a database's load by 1/4th with a simple change

  2026-03-05

• An Elegy for my Beloved Slow Query Logs

  2026-03-04

• (Almost) Every table needs `request_uuid`

  2026-02-25

• Why doesn't MySQL's query planner rewrite some `ORDER BY.. LIMIT` queries to use a `UNION` strategy? No clue.

  2025-11-22

• A one-table SQL query will often use a single index

  2025-10-08

• Indexes are sorted arrays (sort of)

  2023-08-14

• Writing FizzBuzz in MySQL 5.7 for no good reason

  2022-07-07

• Large Analytics SQL Queries are a Code Smell

  2022-05-11