Mechanism◆Article

The interactive explain tool runs SQLite inside Python, inside Pyodide, inside WebAssembly, entirely in the browser, and adds explanatory text to both EXPLAIN and EXPLAIN QUERY PLAN output.

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. ✦ AI generated

Simon Willison · Simon Willison's Weblog · 2026-07-18 · original ↗

Share card ↓Export .md Export .txt

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.

Read full article ↗excerpt · fair-use quotation

✳ Fable ✳ Pyodide ✳ WebAssembly

Related moments

Claim◆Audio · 28:07 · 1m

Epic's core philosophy — building both awesome entertainment and awesome tools, and sharing those tools with everybody — is the sole reason the company survived and succeeded through every financial downturn.

Tim Sweeney · Lex Fridman

Claim◆Article · 27 words

The Lobsters migration is a useful case study showing that a single server running SQLite can accomplish a lot in 2026.

Simon Willison · Simon Willison's Weblog

Fact◆Article · 23 words

sqlite-utils now follows SQLite's own convention for treating column names as case insensitive, a change that turned out to touch a bunch of different places in the codebase.

Simon Willison · Simon Willison's Weblog