Datasette | Support by cloudimg

This is a repackaged open source software product wherein additional charges apply for cloudimg support services.

Overview Datasette is an open source multi tool for exploring and publishing data. It takes one or more SQLite databases and instantly publishes them as a browsable, searchable web interface with a faceted UI and a full JSON API over every table and query, so anyone can explore your data in a browser or query it programmatically. This image delivers Datasette fully installed in a dedicated virtual environment and run as a system service, so a working data explorer is serving within minutes of launch.

Application Stack Datasette installed into a dedicated Python virtual environment under /opt/datasette and run by an unprivileged service account. The served databases directory, holding the SQLite files Datasette publishes, stored on a dedicated data disk so it is independently resizable. A systemd service that starts Datasette on boot and restarts it on failure. An nginx reverse proxy that publishes the interface on port 80 behind HTTP Basic authentication.

Ready To Explore Demo Database A demo SQLite database ships at /var/lib/datasette/demo.db with a couple of tables and sample rows, so the interface is non empty out of the box and you can immediately browse tables, run filters, drill into facets and call the JSON API. It shows what Datasette looks like serving real data and gives you a working example. Copy your own .db files into the data directory and restart the service to publish them.

Secure First Boot On the first boot of your instance a one shot service generates a fresh admin password, unique to that instance, writes it into the nginx credentials file and writes the password to a root only file. The Datasette process itself binds to loopback only and is never exposed without authentication. No shared or default credentials ship in the image.

Explore And Publish Data Datasette renders every table as a filterable, sortable, facetable web page and exposes the same data and any custom SQL query as JSON, so it doubles as an instant read only API over your SQLite data. The databases are served read only, the safe default for a published data appliance, so the interface is ideal for sharing datasets, internal data catalogues and reproducible data publishing.

cloudimg Support 24/7 technical support by email and chat. Help with deployment, loading your own databases, plugins, faceting and full text search, the JSON API, TLS and authentication.

Use Cases Publishing open data and datasets for the public or a team to explore. An instant browsable interface and JSON API over any SQLite database. Internal data catalogues and reporting. Sharing the results of a data analysis as a reproducible, queryable site. Self hosted data exploration without building a front end.

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.