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.

I am facing similar kind of issue, when I try to install pysqlite3-binary

error in terminal looks like below
ERROR: Could not find a version that satisfies the requirement pysqlite3-binary (from versions: none)
ERROR: No matching distribution found for pysqlite3-binary

Any insights on how to address this would be greatly appreciated.

Thank you!

Same issue here as well…

Same issue! Has anybody come up with a solution please?