Tool: SQLite Query Explainer 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 s ✦ AI generated
Julia Evans admits, in her writeup on running SQLite, that she still doesn't really understand how to read a query plan.
Julia Evans: Maybe one day I'll learn to read a query plan.
The new tool layers SQLite on top of Python, Pyodide, and WebAssembly entirely client-side, and augments raw EXPLAIN / EXPLAIN QUERY PLAN output with human-readable explanations.
Simon Willison: 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.
The author says he shares Julia Evans' confusion over query plans, and that this shared frustration is what pushed him to build an explainer tool.
Simon Willison: Big same.... which inspired me to have Fable build this interactive explain tool
gives example · 1
The author flags that he doesn't know enough about SQLite query plans to confirm the tool's output is correct, though it looks reasonable to him.
Simon Willison: 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.