sqlite-utils-shell
![License](https://img.shields.io/badge/license-Apache%202.0-blue.svg)
An interactive shell for sqlite-utils
Alternative: sqlite-utils-litecli is similar to this but better, because it includes full autocompletion against table and column names.
Installation
Install this plugin in the same environment as sqlite-utils.
sqlite-utils install sqlite-utils-shell
Usage
To start a new interactive shell session against a database:
sqlite-utils shell data.db
Type quit
or exit
to end the session.
Omit the filename to run against an in-memory database.
To load additional SQLite extensions pass their paths as one or more --load-extension
arguments:
sqlite-utils shell data.db \
--load-extension /path/to/extension.so
Development
To set up this plugin locally, first checkout the code. Then create a new virtual environment:
cd sqlite-utils-shell
python3 -m venv venv
source venv/bin/activate
Now install the dependencies and test dependencies:
pip install -e '.[test]'
To run the tests:
pytest