Datasette

Datasette is an open-source data discovery and publishing tool that allows you to convert data of any size into an interactive website and an accompanying API. Python requires version 3.8 or higher and can be installed using Homebrew, pip, pipx, or Docker. It makes it easy to offer and distribute local SQLite databases for data journalists, researchers, and anyone who wants to share their data.

DA

simonw · Low-Code & Internal Tools

STARS11.5K
FORKS941
COMMITS—
CONTRIBUTORS89
VERSION1.0a9
UPDATEDtoday
sqlitedata-explorationapipythonApache-2.0

Common commercial products in this category: Retool, Microsoft Power Apps, Airtable

What can it do?
  • You run SQLite database files from the command line on a local web server and examine them through the interface
  • Add license and source information to the data published with metadata files in the JSON format
  • Using Heroku or Google Cloud Run services, you post databases to the Internet in one command.
Heads up
  • • High number of open issues (715)
User reviews
  • ↑ PositiveHacker News

    Architecture Notes: Datasette

    “My ultimate dream is that providers like that will use Datasette itself - or a similar system that has the same characteristics: make it really easy for people to slice and dice the data using querystring parameters or even SQL queries and get back out just the data they want as…”

  • • NeutralHacker News

    Architecture Notes: Datasette

    “Simon thanks for taking the time to explain Datasette internals. Not a Python developer myself, I was intrigued by the use of hooks to extend Datasette and ended up looking into pluggy and how Datasette plugins use hooks. I noticed some Datasette hooks like 'extra_template_vars'…”

My note

Alternative pages

More in: Low-Code & Internal Tools