Datasette Tutorials

These tutorials are intended to complement the official Datasette documentation by providing step-by-step guides to learning Datasette and the Datasette ecosystem tools.

• Exploring a database with Datasette shows how to use the Datasette web interface to explore a new database.
• Learn SQL with Datasette introduces SQL, and shows how to use that query language to ask questions of your data.
• Cleaning data with sqlite-utils and Datasette shows how to use sqlite-utils to clean data, import it into SQLite and then explore it with Datasette. Includes a ten minute accompanying video.

Other tutorials

• Analyzing ScotRail audio announcements with Datasette—from prototype to production talks through the full process of creating an initial rapid prototype using Datasette Lite, building a custom plugin for it, then launching a full Datasette instance using GitHub Actions for build and deployment automation and Vercel for hosting. It also shows how to build features using complex SQL queries stored as Datasette canned queries.
• Using a self-rewriting README powered by GitHub Actions to track TILs is another example showing how to use GitHub Actions to store content in a repository and then build and deploy it using Datasette, illustrated by the implementation of til.simonwillison.net.

Suggestions for more tutorials are welcome! Please share those on the Datasette Discord.