Baked Data

The The Baked Data architectural pattern describes this approach, which is key to taking full advantage of SQLite and Datasette.

I like to build my databases in GitHub Actions.

Niche Museums and TILs

Both of these sites have Atom feeds that are defined using a Datasette canned query, in conjunction with the datasette-atom plugin.

Generating a newsletter with an Observable notebook

I wrote about this in Semi-automating a Substack newsletter with an Observable notebook: