What it does
datasette-export-database is a plugin for Datasette, the open-source data exploration tool maintained by Simon Willison. The plugin adds an on-demand export capability for writable (mutable) on-disk SQLite databases. Users who hold the export-database permission see a new option in the database action menu that produces a fresh SQLite snapshot of any on-disk database. In-memory databases are excluded.
What changed in 0.3a2
Version 0.3a2 is an alpha pre-release following 0.3a1 (released April 15, 2026), continuing the 0.3 series with the core export capability. The release enables on-demand export of mutable SQLite databases from running Datasette instances.
Why it matters
SQLite databases used as application backing stores are often live and writable. Naive file-copy snapshots taken while writes are in progress can produce inconsistent or corrupted exports. The plugin uses SQLite's backup mechanism to produce a safe, consistent snapshot while the database remains online. For Datasette deployments used as writable data stores, this simplifies ad-hoc backup, migration, and testing workflows without requiring downtime or manual intervention.
Key Points
- 1What: 0.3a2 enables on-demand export of mutable `SQLite` databases from Datasette deployments.
- 2For practitioners: create ad-hoc writable database copies for backup, testing, and migration workflows.
- 3So what: simplifies handling live, mutable datasets and reduces friction exporting consistent `SQLite` snapshots.
Scoring Rationale
Routine plugin release adding on-demand export for mutable SQLite; valuable to Datasette users but limited broader impact.
Practice interview problems based on real data
1,625 SQL & Python problems across 15 industry datasets — the exact type of data you work with.
Try 250 free problems
