Use sqlite-chronicle with tables in Datasette

Install this plugin in the same environment as Datasette.

datasette install datasette-chronicle

Once installed, users with the enable-chronicle and disable-chronicle permissions (granted to the root user by default) will have access to new table action menu options for enabling and disabling row version tracking for a table.

Tables that have had row version tracking enabled will now support a new ?_since=X query string parameter on the table page, which will filter for just rows that have been inserted or updated since the specified chronicle version.

See the sqlite-chronicle documentation for more details on what this is and how it works.

To set up this plugin locally, first checkout the code. Then create a new virtual environment:

cd datasette-chronicle
python3 -m venv venv
source venv/bin/activate

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests:

pytest