sqlite-utils-litecli

July 27, 2023 ยท View on GitHub

PyPI Changelog Tests License

Interactive shell for sqlite-utils using litecli.

Installation

Install this plugin in the same environment as sqlite-utils.

sqlite-utils install sqlite-utils-litecli

Usage

Start running the shell like this:

sqlite-utils litecli data.db

This will start a litecli interactive shell session.

Custom SQL functions provided by other plugins will be available in the shell.

Screenshot showing the plugin in action - it includes autocomplete of SQLite table names

Development

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

cd sqlite-utils-litecli
python3 -m venv venv
source venv/bin/activate

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests:

pytest