Datasette - a tool to automatically create web API by dropping in an SQLite file


#1

Hi everyone,

have you already heard of a tool called Datasette? I discovered it yesterday and find it really handy.

Github page:

The author presenting it (this is the best):

So basically you can just throw an SQLite database at it, and it creates a complete web-API for that dataset including facets, filtering, different output formats for filtered subsets, showing things on a map (if columns are called longitude and latitude), etc.

Does any of you have experience with it? I am considering to use it for out Open Power System Data project https://open-power-system-data.org/ where all our frictionless datapackage based Data Packages are also shipped with an SQLite database - so it would be a relatively easy set for us.

Best
Ingmar