datasette.io runs using a heavily customized Datasette instance implementing the Baked Data pattern. Read more about how it works in datasette.io, an official project website for Datasette and Building a search engine for datasette.io.

You can explore the database that powers this site at datasette.io/content.

github-to-sqlite is a tool for loading data from GitHub - repositories, issues, issue comments, commits and more - into a SQLite database.

github-to-sqlite.dogsheep.net provides a demo of that tool running against hundreds of Datasette repositories. It also demonstrates two plugins: datasette-graphql for providing a GraphQL API to Datasette, and datasette-search-all for searching multiple database tables at once.

• Try out the GraphQL API
• Search everything for render_cell

CPAD, the California Protected Areas Database, is a remarkable GIS dataset maintained by GreenInfo Network, an Oakland non-profit.

This example uses the shapefile-to-sqlite tool to import Shapefiles from that project into a SpatiaLite database, then demonstrates a number of different Datasette geospatial plugins, including:

• datasette-leaflet-geojson to render the data on a map
• datasette-leaflet-freedraw to allow users to draw shapes on the map and query the database for matching records

For more on this project, see California Protected Areas in Datasette and Drawing shapes on a map to query a SpatiaLite database.

Building a location to time zone API with SpatiaLite is a tutorial showing how to use SpatiaLite with Datasette.

The San Francisco Microscopical Society have archives dating back to 1870, and recently started digitizing them as scanned images in PDF files.

s3-ocr is a tool for bulk OCRing PDF files in an S3 bucket and extracting out the resulting text into a searchable SQLite database.

Their archive site uses a templated Datasette instance to allow people to search and browse through their archives.

Building a searchable archive for the San Francisco Microscopical Society describes in detail how this project was built.

The World Resources Institute publishes a Global Power Plants Database with information about over 30,000 power plants around the world.

This Datasette instance presents those power plants on a map, using the datasette-cluster-map plugin to support zooming in to see individual plants.