[container] sqlite install

[mikeldking]

sqllite ships with python but not sure if we can more closely control the version in the container. Worth investigating if we can control the version.

[axiomofjoy]

I think this issue affects more than just containers. We want to use features from SQLite 3.45, but some older versions of Python ship with older versions of the SQLite database engine.

Python 3.8.17 | packaged by conda-forge | (default, Jun 16 2023, 07:11:32)
[Clang 14.0.6 ] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> sqlite3.sqlite_version
'3.43.0'

[axiomofjoy]

This also affects the current container image, which ships with SQLite v3.40.1. We're going to need to install a custom version of SQLite, either via a third-party library or by packaging SQLite binaries into our own wheels.

[axiomofjoy]

The best option I've found is apsw.

• ships with each version of sqlite contained inside as an isolated dependency
• supports wheels for the mac, linux, windows
• on Conda Forge
• more specifically geared toward sqlite than built-in sqlite3 module
• no dependencies
• supports python 3.8 through 3.13

Alternatively, we can package an sqlite binary into phoenix ourselves if we don't need the apsw python wrapper, but I don't see much advantage to doing that aside from saving a marginal amount of space. The wheels are not too big.

[axiomofjoy]

Looks like it's been a few years since the Conda feedstock had a release.

conda-forge/apsw-feedstock#48

[mikeldking]

Need to determine if JSON binary is worth it
How to get JSON extension installed

[mikeldking]

too much work