Simon Willison’s Weblog

Subscribe

sqlite-page-explorer (via) Outstanding tool by Luke Rissacher for understanding the SQLite file format. Download the application (built using redbean and Cosmopolitan, so the same binary runs on Windows, Mac and Linux) and point it at a SQLite database to get a local web application with an interface for exploring how the file is structured.

Here's it running against the datasette.io/content database that runs the official Datasette website:

Animated demo. Starts on a page that shows the SQLite header information, then toggles hex display on and off, then navigates to an index of all the pages and clicks in to the details of one of those pages.

Posted 6th February 2025 at 8:39 pm

Recent articles

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe