https://docs.trychroma.com/troubleshooting#sqlite

Chroma requires SQLite > 3.35, if you encounter issues with having too low of a SQLite version please try the following.

1. Install the latest version of Python 3.10, sometimes lower versions of python are bundled with older versions of SQLite.
2. If you are on a Linux system, you can install pysqlite3-binary, pip install pysqlite3-binary and then override the default sqlite3 library before running Chroma with the steps here. Alternatively you can compile SQLite from scratch and replace the library in your python installation with the latest version as documented here.
3. If you are on Windows, you can manually download the latest version of SQLite from https://www.sqlite.org/download.html and replace the DLL in your python installation’s DLLs folder with the latest version. You can find your python installation path by running os.path.dirname(sys.executable) in python.
4. If you are using a Debian based Docker container, older Debian versions do not have an up to date SQLite, please use bookworm or higher.