Datasette

Datasette is a tool for exploring and publishing data. It helps people take data of any shape or size, analyze and explore it, and publish it as an interactive website and accompanying API. Datasette is aimed at data journalists, museum curators, archivists, local governments, scientists, researchers and anyone else who has data that they wish to share with the world. It is part of a wider ecosystem of 38 tools and 88 plugins dedicated to making working with structured data as productive as possible. https://datasette.io/ By Simon Willison.

• Datasette Desktop - a macOS desktop application for easily running Datasette on your own computer!
• Datasette Lite is a new way to run Datasette: entirely in your browser, thanks to the Pyodide project which provides a full Python environment compiled to WebAssembly. You can use it to explore any SQLite database file hosted on a CORS-enabled static hosting provider, which includes GitHub and GitHub Pages.
• Dogsheep is a collection of tools for personal analytics using SQLite and Datasette. https://dogsheep.github.io/ includes connectors for Twitter archives, Evernote, Apple Photos, Apple Notes, Pinboard, TodoIst, etc.