I post a lot of Datasette projects on my blog. Some of my recent favourites:
- Exploring the training data behind Stable Diffusion describes how I built laion-aesthetic.datasette.io to explore 12m training images used for Stable Diffusion.
- Analyzing ScotRail audio announcements with Datasette—from prototype to production explains the scotrail.datasette.io project.
- I built a ChatGPT plugin to answer questions about data hosted in Datasette is one of my earlier explorations at the intersection of LLM AI and Datasette.
- Building a location to time zone API with SpatiaLite shows how to use SpatiaLite and Datasette to create an API for looking up time zones based on latitude/longitude points.
- Drawing shapes on a map to query a SpatiaLite database introduces the
datasette-leaflet-freedrawplugin and introduces the calands.datasettes.com demo. - Joining CSV and JSON data with an in-memory SQLite database