Datasette on Ubuntu 24.04 LTS by cloudimg

## Datasette on Ubuntu 24.04 LTS by cloudimg

Datasette is an open-source tool for exploring and publishing data. It serves a web UI and a JSON API over one or more SQLite databases, with faceted browsing, full-text search and ad-hoc SQL queries. The cloudimg image installs Datasette in a Python virtualenv behind an nginx reverse proxy on port 80 with HTTP Basic auth, ships a sample SQLite database on a dedicated Azure data disk, and generates a unique password on the first boot of every VM. Drop your own .db files into the data directory and restart. Backed by 24/7 expert support.

Explore and Publish Data

Browse tables with faceted filtering, run full-text search and SQL queries, and consume everything as JSON for APIs and dashboards. Add your own SQLite databases to /var/lib/datasette and restart to publish them instantly.

Dedicated Data Disk

The SQLite databases live on a dedicated, independently resizable Azure data disk mounted at /var/lib/datasette, separate from the OS disk and re-provisioned with every VM.

Secured By nginx

Datasette is a read-only data explorer with no built-in auth, so nginx fronts it on port 80 with HTTP Basic auth and a unique per-VM password generated on first boot, written to a root-only file.

Why Choose cloudimg?

* 24/7 Expert Support with guaranteed 24 hour response. Contact support@cloudimg.co.uk

* Production Ready from Launch Pre configured, security patched, and validated before publication

* Azure Native Integration Built with Azure Linux Agent, cloud init, and Gen2 Hyper V

What is Included

* Datasette in a Python virtualenv, fronted by nginx on port 80

* nginx HTTP Basic auth with a unique per-VM password generated on first boot in a root-only file

* A sample SQLite database on a dedicated Azure data disk at /var/lib/datasette

* The JSON API alongside the web UI for every database and table

* datasette.service and nginx.service as systemd units, enabled and active

Use Cases

Exploring and publishing SQLite datasets, a read-only data API over your data, faceted data browsing and search, and a self-hosted data-exploration portal.

Datasette serves plain HTTP on port 80 - front it with TLS and your own domain before production.

Visit www.cloudimg.co.uk/guides/datasette-on-ubuntu-24-04-azure for the full user guide.

Datasette is a trademark of its respective owner. cloudimg is not affiliated with or endorsed by the Datasette project. All trademarks are the property of their respective holders.