Datasette on Ubuntu 24.04 LTS
by cloudimg
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.