datasette

Datasette is a tool for exploring and publishing data. Uses sqlite for storing data and is written in python and exposes the db over a web interface. support adhoc querying (made posible by mounting the database file in Readonly mode, so destructive operations are possible).

The author – Simon Willison has substack newsletter for the project.

How he uses datasette – “What is the killer app for datasette”; Oct 2022.

datasette.io, an official project website for Datasette – a blog post detailing how datasette is used to publish a website, in this case the website of the project itself. which uses the The Baked Data architectural pattern.