Chroma Issues: SQLite version

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

Step 1: Install pysqlite3-binary

pip install pysqlite3-binary

Step 2: Edit the init file /usr/local/lib/<'Your Python Version'>/site-packages/chromadb/__init__.py , add below 3 line at the head of the __init__.py file

__import__('pysqlite3')
import sys
sys.modules['sqlite3'] = sys.modules.pop('pysqlite3')
# Add above 3 lines

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