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