Issue with Chroma and Sqlite - How to install pysqlite3-binary using poetry

I have a streamlit application that uses chroma vector database.
The app works perfectly fine on local.
However I want to deploy this in my internal Kubernetes ecosystem, I went with poetry approach to install the python dependencies.

Encountered the issue described here: Issues with Chroma and Sqlite

Since I dont have a requirements.txt, i need to use

poetry add pysqlite3-binary=0.5.2

Getting the below error:
Unable to find installation candidates for pysqlite3-binary (0.5.2.post2)
Cannot install pysqlite3-binary.

Can anyone kindly help me resolve this on the poetry platform.

Thanks in advance.

  1. Are you running your app locally or is it deployed? Yes
  2. If your app is deployed:
    a. Is it deployed on Community Cloud or another hosting platform? Hosted on internal K8s
  3. Share the full text of the error message (not a screenshot).
  4. Share the Streamlit: latest and Python 3.10.
1 Like