More demos and further reading

Fun demos

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.

SpatiaLite

• 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-freedraw plugin and introduces the calands.datasettes.com demo.

• Joining CSV and JSON data with an in-memory SQLite database