Add pip as a dependency to ensure plugins work with uv

[simonw]

Reported on Discord: https://discord.com/channels/823971286308356157/997738192360964156/1440396106658873416

I think plugin installation may fail if you installed sqlite-utils with uv because pip may not be available.

Datasette has pip as a dependency for that reason:

• Datasette cannot be installed with Rye datasette#2065

[simonw]

Steps to reproduce:

/tmp % mkdir t
/tmp % cd t
t % uv init
Initialized project `t`
t % uv venv
Using CPython 3.10.10 interpreter at: /opt/homebrew/Caskroom/miniconda/base/bin/python3
Creating virtual environment at: .venv
Activate with: source .venv/bin/activate
t % uv add sqlite-utils
Resolved 10 packages in 568ms
Installed 8 packages in 6ms
 + click==8.3.1
 + click-default-group==1.2.4
 + pluggy==1.6.0
 + python-dateutil==2.9.0.post0
 + six==1.17.0
 + sqlite-fts4==1.0.3
 + sqlite-utils==3.38
 + tabulate==0.9.0
t % uv run sqlite-utils --version
sqlite-utils, version 3.38
t % uv run sqlite-utils install sqlite-utils-ask
Traceback (most recent call last):
  File "/private/tmp/t/.venv/bin/sqlite-utils", line 10, in <module>
    sys.exit(cli())
  File "/private/tmp/t/.venv/lib/python3.10/site-packages/click/core.py", line 1485, in __call__
    return self.main(*args, **kwargs)
  File "/private/tmp/t/.venv/lib/python3.10/site-packages/click/core.py", line 1406, in main
    rv = self.invoke(ctx)
  File "/private/tmp/t/.venv/lib/python3.10/site-packages/click/core.py", line 1873, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/private/tmp/t/.venv/lib/python3.10/site-packages/click/core.py", line 1269, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/private/tmp/t/.venv/lib/python3.10/site-packages/click/core.py", line 824, in invoke
    return callback(*args, **kwargs)
  File "/private/tmp/t/.venv/lib/python3.10/site-packages/sqlite_utils/cli.py", line 2867, in install
    run_module("pip", run_name="__main__")
  File "/opt/homebrew/Caskroom/miniconda/base/lib/python3.10/runpy.py", line 220, in run_module
    mod_name, mod_spec, code = _get_module_details(mod_name)
  File "/opt/homebrew/Caskroom/miniconda/base/lib/python3.10/runpy.py", line 140, in _get_module_details
    raise error("No module named %s" % mod_name)
ImportError: No module named pip

[simonw]

I added pip as a dependency and ran python -m build and tested it like this:

~ % cd /tmp
/tmp % mkdir t2
/tmp % cd t2
t2 % uv venv
Using CPython 3.10.10 interpreter at: /opt/homebrew/Caskroom/miniconda/base/bin/python3
Creating virtual environment at: .venv
Activate with: source .venv/bin/activate
t2 % uv init
Initialized project `t2`
t2 % uv add ~/dev/sqlite-utils/dist/sqlite_utils-4.0a1-py3-none-any.whl 
Resolved 11 packages in 168ms
Installed 9 packages in 28ms
 + click==8.3.1
 + click-default-group==1.2.4
 + pip==25.3
 + pluggy==1.6.0
 + python-dateutil==2.9.0.post0
 + six==1.17.0
 + sqlite-fts4==1.0.3
 + sqlite-utils==4.0a1 (from file:///Users/simon/dev/sqlite-utils/dist/sqlite_utils-4.0a1-py3-none-any.whl)
 + tabulate==0.9.0
t2 % uv run sqlite-utils --version                                     
sqlite-utils, version 4.0a1
t2 % uv run sqlite-utils install sqlite-utils-ask
Collecting sqlite-utils-ask
...

[simonw]

I'm going to ship a dot-release of this for the 3.x branch.