18th July 2026
Tool
SQLite Query Explainer
— View Mozilla Bugzilla bug reports and run SQL queries against a SQLite database to see exactly how SQLite executes them. The tool annotates every line of `EXPLAIN QUERY PLAN` and low-level `EXPLAIN` bytecode output with plain-English descriptions of what the query planner and virtual machine are doing.
Julia Evan's, in Learning a few things about running SQLite:
Maybe one day I’ll learn to read a query plan.
Big same.... which inspired me to have Fable build this interactive explain tool, which runs SQLite in Python in Pyodide in Web Assembly in the browser and adds a layer of explanation to the results of both EXPLAIN and EXPLAIN QUERY PLAN.
Approach with caution, since I don't know enough about SQLite query plans to verify the results myself, but it seems cromulent enough to me.
Recent articles
- Running the full server-side Datasette Python app in the browser with service workers and Pyodide - 17th November 2026
- Locating the source of a mysterious beep with Claude - 9th November 2026
- Hide your slop PR descriptions behind <details><summary> - 9th November 2026
- Qwen 3.8 27B on my laptop can interpret model weights, too - 3rd November 2026