Hi, I’m having some troubles with an LLM apps using Chroma for vector stores (via Langchain). This the run time error message: RuntimeError: �[91mYour system has an unsupported version of sqlite3. Chroma requires sqlite3 >= 3.35.0.�[0m�[94mPlease visit https://docs.trychroma.com/troubleshooting#s…

If that doesn’t work, you might instead be able to add pysqlite3-binary to your requirements.txt file, and add these lines to the top of your app __import__('pysqlite3') import sys sys.modules['sqlite3'] = sys.modules.pop('pysqlite3') in order to use that pip-installed package instead of the built…

Hello @AnhNgDo , welcome to our community! It seems that the version of SQLite on the deployment environment is not compatible with Chroma. The application seems to require SQLite version 3.35.0 or higher. Does the version of SQLite in your deployed environment match that? Thanks, Charly

@AnhNgDo According to this 🔍 Troubleshooting | Chroma you might try using a more recent version of python, which should come with a newer version of sqlite. Do you know what version you are using now on the app? You could try recreating the Cloud app with python 3.11 and see if that works.

Thanks @blackary . I’m not sure which version of Python running on the deployed apps or how to check it. But that explains why it still works fine on my local machine (running 3.11). How would I recreate the Cloud app with Python 3.11? Much appreciated!

Hi @AnhNgDo , I have the some issue with this sqlite3 version. I tried Python 11 to create the app on Streamlit Cloud. It didn’t work. The sqlite3 version is still 3.34.1. Actually, I tried Python 9, 10, 11 to create app on Streamlit cloud. The sqlite3 version is always 3.34.1.

Use pysqlite3-binary as explained above .

Hi @Goyo It’s not working. I got below error from streamlit cloud. [截屏2023-07-27 16.18.44] [error]

Of course sqlite3 is undefined in that scope. Uncomment import sqlite3 if you want to use the name there.

Hi @Goyo Ah, I’m stupid. It’s working now. Thanks a lot!

Issues with Chroma and Sqlite

LLMs and AI

AnhNgDo July 26, 2023, 9:54am 3

Thanks Charly!

I’m not sure, to be honest

I deployed to Streamlit Cloud via Github - is there a way to configure the Streamlit container to meet the SQLite requirement for Chroma? It has been working fine before

Topic		Replies	Views
Chroma and SQLite issue on Streamlit deployments LLMs and AI	4	2305	September 19, 2024
Chromadb, sqlite3, Your system has an unsupported version of sqlite3 Using Streamlit debugging	7	902	January 22, 2025
Error while deplyoying app on streamlit Deployment	1	1038	December 27, 2023
Keep getting this error for SQLite3 unsupported version Community Cloud debugging	7	936	December 20, 2024
Persistent Issue: Unsupported version of sqlite3. Chroma requires sqlite3 >= 3.35.0 Community Cloud streamlit-cloud , discussion	1	777	June 26, 2024

Issues with Chroma and Sqlite

Related topics