Datasette plugin providing a UI for writing to a database
Install this plugin in the same environment as Datasette.
$ pip install datasette-write
Having installed the plugin, visit
/-/write on your Datasette instance to submit SQL queries that will be executed against a write connection to the specified database.
By default only the
root user can access the page - so you'll need to run Datasette with the
--root option and click on the link shown in the terminal to sign in and access the page.
datasette-write permission governs access. You can use permission plugins such as datasette-permissions-sql to grant additional access to the write interface.
To set up this plugin locally, first checkout the code. Then create a new virtual environment:
cd datasette-write python3 -mvenv venv source venv/bin/activate
Or if you are using
Now install the dependencies and tests:
pip install -e '.[test]'
To run the tests: