Datasette by Simon Willison

5th January 2021 at 8:28am
automatic api data viz database

Datasette is a software that provides a web interface on top of any SQLite database. With the web interface you can query the data using SQL and it even provides a json, csv or GraphQL API.

Datasette can easily be extended thanks to plugins. Among many plugins, it has one to display data on a map and another one for data visualization using Vega.

Related to

Backlinks: Alternatives to the REST Architecture, Building a Design System Workbench by CHRISTOPH LABACHER, Dogsheep by Simon Willison, PostgREST: automatic API on top of PostgreSQL, rga: ripgrep search in a multitude of file types, Wikidata: the open knowledge database