Your system has an unsupported version of sqlite3. Chroma requires sqlite3 >= 3.35.0 error

[kok_007]

Hello All, If you are deploying Flask with chroma db in render

you might encounter this error - Your system has an unsupported version of sqlite3. Chroma requires sqlite3 >= 3.35.0

Solution is to add pysqlite3-binary in your requirements.txt and before importing chroma
add this

import pysqlite3
import sys
sys.modules["sqlite3"] = sys.modules.pop("pysqlite3")
#then import 
import chromadb

[al_ps]

Hi,

Thanks for taking the time to add a solution to the community.

I think there was also similar topic in the past: https://community.render.com/t/your-system-has-an-unsupported-version-of-sqlite3-chroma-requires-sqlite3-3-35-0/13807

Alan