Installation

Minimum requirements

SQLite 3.27.0 or newer
- We use modern features of SQL like the JSON1 extension, VACUUM INTO (3.27.0), window functions (3.25.0), and row values (3.15.0)

Need a newer SQLite?

Try pip install pysqlite3-binary.

Datasette will then use the SQLite from the pysqlite3-binary package, which is an up-to-date version.

WAL mode

datasette-ui-extras works best if your database is in write-ahead logging (WAL) mode with the synchronous flag set to NORMAL.

You must take action to enable this mode:

sqlite3 mydatabase.db "pragma journal_mode = wal"

WAL mode with NORMAL is recommended by the SQLite developers. It is faster and supports more concurrency than the default settings. It is not the default due to their long-standing commitment to backwards compatibility.