`sqlite-utils install` command

[simonw]

With the addition of --functions in:

• sqlite-utils query --functions mechanism for registering extra functions #471

In addition to the existing convert command, there are now very good reasons to want to install additional packages into the same virtual environment as sqlite-utils itself, to allow them to be used with those features.

This isn't easy if you installed the tool with pipx or brew install sqlite-utils.

Datasette solved this problem with the datasette install command:

• "datasette install" and "datasette uninstall" commands datasette#925

sqlite-utils could benefit from the same idea.

[simonw]

The implementation of this can be an almost exact copy of Datasette's, which was added in this commit: simonw/datasette@01fe5b7

Current code for that is here: https://github.com/simonw/datasette/blob/0.62/datasette/cli.py#L319-L340 - which is improved to use the from runpy import run_module function.

[simonw]

Documentation:

• https://sqlite-utils.datasette.io/en/latest/cli.html#cli-install
• https://sqlite-utils.datasette.io/en/latest/cli.html#cli-uninstall
• https://sqlite-utils.datasette.io/en/latest/cli-reference.html#install
• https://sqlite-utils.datasette.io/en/latest/cli-reference.html#uninstall