datasette-ephemeral-tables by simonw

40 downloads this week        Star

README source code


PyPI Changelog Tests License

Provide tables that expire after a time limit


Install this plugin in the same environment as Datasette.

datasette install datasette-ephemeral-tables


Once installed, this plugin will ensure Datasette starts running with a new named in-memory database called ephemeral.

Any tables created in this database will be automatically dropped five minutes after creation.


All plugin settings are optional. The full set of settings in metadata.yml looks like this:

        # The name of the in-memory database created by the plugin:
        database: ephemeral
        # After how many seconds should tables be dropped?
        table_ttl: 300
        # How often should the plugin check for expired tables (in seconds)?
        check_interval: 2

The figures shown here are the default values.


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

cd datasette-ephemeral-tables
python3 -m venv venv
source venv/bin/activate

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests: