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

  2026-03-05

• 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

• Using NodeJS's AsyncLocalStorage to Instrument a Webserver

  2022-05-30

• MongoDB Performance is Disk-graceful

  2021-10-22

• Node's `AsyncLocalStorage` Makes the Commons Legible

  2021-08-18