Source · Simon Willison
blog Simon Willison · 4h ago

Simon Willison converts MDN browser compatibility data into a SQLite database

Inspired by Mozilla's new MDN MCP service, Simon Willison has converted the comprehensive mdn/browser-compat-data repository into a SQLite database. The project utilizes a script generated by Claude Code for web (Opus 4.8) to perform this conversion using sqlite-utils. The resulting database is approximately 66MB in size and is hosted on GitHub with open CORS headers to facilitate direct access. To automate the process, a GitHub Actions workflow was built using Codex Desktop (GPT-5.5) to force-push the updated database to an orphan branch named db. Users can download the final browser-compat.db file directly from the repository or explore its contents via Datasette Lite.

blog Simon Willison · 3d ago

sqlite-utils 4.0rc1 Adds Migrations and Nested Transactions

sqlite-utils 4.0rc1 introduces database migrations and db.atomic() for nested transactions. Migrations support script-based schema changes using a simplified API, while db.atomic() enables nested transactions via savepoints, improving error handling and data integrity. The release includes backwards-incompatible changes, such as updated upsert behavior and dropped Python 3.8 support, with options to maintain older behaviors.