Command-line tools

dux

datasette-ui-extras needs to create various hidden tables and triggers to maintain statistics about your data. This allows us to offer autosuggest and schema-specific editing controls.

These will be created automatically for you when you start Datasette, assuming your database is mutable.

If you want to publish a read-only database, but still benefit from the extra UI features of datasette-ui-extras, you can use the dux command to prepare your database:

datasette dux mydb.db

undux

If you no longer wish to use datasette-ui-extras, you can remove its hidden tables and statistics triggers by using the undux tool.

datasette undux mydb.db

yolo

You can use the yolo mode to enable a frictionless single-user mode:

datasette yolo mydb.db

Yolo mode will do the following:

• create mydb.db if it does not exist
• put mydb.db into WAL mode for increased concurrency during writes
• update or create Datesette's metadata.json file with a very permissive set of permissions for this database

Yolo mode is only suitable for Datasette instances that are protected at the network level. For example, if you are running Datasette on your laptop's loopback interface, or behind a load balancer that enforces authentication, such as oauth2-proxy.