topic
SQLITE
5 posts tagged SQLITE.
Datasette's Security Patch Shows What an AI-Run Audit Actually Looks Like
Datasette 1.0a39 and 0.65.4 close a batch of permission-bypass bugs found via a week-long audit that ran Claude Fable 5.1, GPT-5.6 Sol, and GPT-6 Astra against the codebase in parallel with human reviewers.
- vibecoding
- ai-security-audit
- sqlite
- agentic-dev-tooling
- appsec
Simon Willison's SQLite Trick: Vibecoding a 250x History Compressor
A dog-walk idea, a voice-mode brainstorm, and a 38-minute coding session produced a working pattern for storing full document revision histories in SQLite at a fraction of the raw size — a clean study in how to actually vibecode something.
- vibecoding
- sqlite
- ai-assisted-development
- dev-tooling
- llm-agents
Simon Willison Vibecoded a SQLite Query Explainer With Claude Fable 5
A browser tool that runs SQLite inside WebAssembly and translates query plans into plain English was built same-day by prompting an AI model, not hand-coding — and its creator was upfront about what he couldn't verify.
- vibecoding
- claude
- developer-tools
- sqlite
- ai-assisted-development
sqlite-utils 4.0: What Happens When Two AI Agents Review One Release
Simon Willison shipped the first major sqlite-utils version since 2020 by pitting Claude and GPT-5.5 against each other as pre-release testers — and they found wildly different numbers of bugs.
- vibecoding
- ai-coding-agents
- python
- sqlite
- dev-tooling
Browser-Native Python Data Persistence: What the OPFS + Pyodide Harness Proves
Simon Willison used Claude Code to build a cross-browser test harness exploring whether Datasette Lite can read and write persistent SQLite files via the browser's Origin Private File System — a small experiment with large implications for client-side data tooling.
- pyodide
- webassembly
- opfs
- sqlite
- vibecoding