SQLite Query Explainer
Interactive SQLite query explainer tool that annotates EXPLAIN and EXPLAIN QUERY PLAN output with plain-English descriptions.
Simon Willison — Independent developer and writer documenting practical experiments, tools, and deep analysis around large language models, generative AI, web development, security, and emerging programming workflows through detailed posts and daily TILs.
291 articles from this blog
Interactive SQLite query explainer tool that annotates EXPLAIN and EXPLAIN QUERY PLAN output with plain-English descriptions.
Anthropic reverses plan to remove Claude Fable 5 from subscriptions, now included in Max and Team Premium plans due to competition.
A blog post noting the recent commit to the Quixote web framework, which has a 21-year-old Git history.
A quote from Kimi K3 refusing to leak its system prompt, collected by Simon Willison.
A tool to detect and highlight clichéd phrases common in LLM-generated text, like 'no X, no Y' chains.
Puter compiles Firefox to WebAssembly, enabling a full browser to run inside another browser with encrypted WebSocket proxying.
Analysis of Moonshot AI's Kimi K3 model, a 2.8 trillion parameter open-weight AI, with benchmark comparisons and a pelican SVG test.
Mira Murati's Thinking Machines Lab releases Inkling, an open-weights multimodal AI model with 975B parameters, Apache-2.0 licensed.
Converts Mermaid diagrams to ASCII/Unicode box-drawing art in the browser using Go compiled to WebAssembly.
Converts Mermaid diagram syntax to Unicode box art in the browser using WebAssembly.
xAI open-sources Grok Build after privacy backlash over uploading user data to cloud storage.
A security researcher tricks Claude's web_fetch tool into leaking user data via a honeypot attack, bypassing Anthropic's protections.
GitHub Dependabot now waits three days before opening version update PRs, improving dependency security.
A developer creates a custom Codex Desktop pet called Pedalican, a pelican on a bicycle, using GPT-5.6 and image generation.
Lobste.rs migrates from MariaDB to SQLite, achieving lower CPU/memory usage and reduced costs.
A reflection on shared understanding in software projects, quoting Armin Ronacher on the role of friction in team synchronization.
Release notes for datasette 1.0a37, an open source multi-tool for exploring and publishing data.
Learn a cache-friendly method for using uvx in GitHub Actions to avoid repeated PyPI downloads and speed up workflows.
Simon Willison explores GitHub code-frequency charts to visualize the impact of coding agents and AI models on his Datasette project.