datasette-upload-dbs 0.5a0

Simon Willison's Blog Tools

Summary

datasette-upload-dbs 0.5a0 adds a formalized API for uploading or swapping SQLite databases on a hosted Datasette instance, enabling automated database updates via curl.

No content available
Original Article
View Cached Full Text

Cached at: 08/12/26, 08:21 AM

# Release: datasette-upload-dbs 0.5a0 Source: [https://simonwillison.net/2026/Aug/11/datasette-upload-dbs/](https://simonwillison.net/2026/Aug/11/datasette-upload-dbs/) This plugin has been around for a while \- it lets users upload a brand new SQLite database to a hosted Datasette instance, at which point that database will start being served by that instance\. It can also be used to atomically swap a database with a more recent version\. The uploaded database is saved to a file, verified, then swapped in so`/name`starts serving the new one\. The new release adds a formalized API, so you can replace an existing database \(or add a new one\) like this: ``` curl -X POST \ -H "Authorization: Bearer $API_TOKEN" \ -H "Accept: application/json" \ -F "[email protected]" \ -F "db_name=content" \ https://your-instance.example.com/-/upload-dbs ``` This means you can build fresh databases in an environment such as GitHub Actions and swap them in production as soon as that build has completed\.

Similar Articles

datasette-export-database 0.3a1

Simon Willison's Blog

datasette-export-database version 0.3a1 released, providing database export functionality as part of the Datasette ecosystem.

datasette 1.0a31

Simon Willison's Blog

Datasette 1.0a31 introduces the ability to execute write queries and save stored queries (renamed from canned queries) for users with appropriate permissions, enhancing data editing capabilities.

datasette-agent 0.3a0

Simon Willison's Blog

Datasette Agent 0.3a0 adds an execute_write_sql tool that requests user approval before writing to a database, along with CLI enhancements and unsafe mode for auto-approval.

datasette 1.0a34

Simon Willison's Blog

Datasette 1.0a34 introduces built-in tools for inserting, editing, and deleting rows directly in the Datasette interface, a feature long overdue and inspired by Datasette Agent.

datasette 1.0a38

Simon Willison's Blog

Datasette 1.0a38 fixes a SQL injection vulnerability affecting instances that serve mixed public and private tables, with the fix also backported to Datasette 0.65.3.