Datasette

"An open source multi-tool for exploring and publishing data" - https://docs.datasette.io

Links

• https://github.com/simonw/datasette
• https://docs.datasette.io
• sqlite

Examples

Start a server

If you're starting from scratch, just touch existing-file.db before running this. -o opens your browser automatically.

datasette existing-file.db -o

Ingest a json file

You can use sqlite-utils to ingest a json file into a sqlite table, which can then be explored in datasette

curl -s "https://hub.docker.com/v2/repositories/ubuntu/" |
jq .results |
sqlite-utils insert datasette.db docker/docker.io/ubuntu -