[BUG] Cant install crewai, Your system has an unsupported version of sqlite3

[4F2E4A2E]

Description

Thank you for crewai. I have been trying all possible ways of installing crewai and none of them are working, specially the official ways of installation.

Steps to Reproduce

Thank you for crewai. I have been trying all possible ways of installing crewai and none of them are working, specially the official ways of installation.

Dockerfile

FROM python:3.12-bullseye

WORKDIR /app

RUN pip install --upgrade pip
RUN pip install crewai crewai-tools

CMD ["sleep", "infinity"]

Verify

$ pip freeze | grep crewai
crewai==0.86.0
crewai-tools==0.17.0

Try to run

$ crewai --help
Traceback (most recent call last):
  File "/usr/local/bin/crewai", line 5, in <module>
    from crewai.cli.cli import crewai
  File "/usr/local/lib/python3.12/site-packages/crewai/__init__.py", line 3, in <module>
    from crewai.agent import Agent
  File "/usr/local/lib/python3.12/site-packages/crewai/agent.py", line 8, in <module>
    from crewai.agents import CacheHandler
  File "/usr/local/lib/python3.12/site-packages/crewai/agents/__init__.py", line 2, in <module>
    from .parser import CrewAgentParser
  File "/usr/local/lib/python3.12/site-packages/crewai/agents/parser.py", line 5, in <module>
    from crewai.utilities import I18N
  File "/usr/local/lib/python3.12/site-packages/crewai/utilities/__init__.py", line 13, in <module>
    from .embedding_configurator import EmbeddingConfigurator
  File "/usr/local/lib/python3.12/site-packages/crewai/utilities/embedding_configurator.py", line 3, in <module>
    from chromadb import EmbeddingFunction, Documents, Embeddings
  File "/usr/local/lib/python3.12/site-packages/chromadb/__init__.py", line 86, in <module>
    raise RuntimeError(
RuntimeError: Your system has an unsupported version of sqlite3. Chroma                     requires sqlite3 >= 3.35.0.
Please visit                     https://docs.trychroma.com/troubleshooting#sqlite to learn how                     to upgrade.

Expected behavior

No error after installing crewai.

Screenshots/Code snippets

None

Operating System

Other (specify in additional context)

Python Version

3.12

crewAI Version

0.86.0

crewAI Tools Version

0.17.0

Virtual Environment

Venv

Evidence

Environment

FROM python:3.12-bullseye

WORKDIR /app

RUN pip install --upgrade pip
RUN pip install crewai crewai-tools

CMD ["sleep", "infinity"]

Verify

$ pip freeze | grep crewai
crewai==0.86.0
crewai-tools==0.17.0

Try to run

$ crewai --help
Traceback (most recent call last):
  File "/usr/local/bin/crewai", line 5, in <module>
    from crewai.cli.cli import crewai
  File "/usr/local/lib/python3.12/site-packages/crewai/__init__.py", line 3, in <module>
    from crewai.agent import Agent
  File "/usr/local/lib/python3.12/site-packages/crewai/agent.py", line 8, in <module>
    from crewai.agents import CacheHandler
  File "/usr/local/lib/python3.12/site-packages/crewai/agents/__init__.py", line 2, in <module>
    from .parser import CrewAgentParser
  File "/usr/local/lib/python3.12/site-packages/crewai/agents/parser.py", line 5, in <module>
    from crewai.utilities import I18N
  File "/usr/local/lib/python3.12/site-packages/crewai/utilities/__init__.py", line 13, in <module>
    from .embedding_configurator import EmbeddingConfigurator
  File "/usr/local/lib/python3.12/site-packages/crewai/utilities/embedding_configurator.py", line 3, in <module>
    from chromadb import EmbeddingFunction, Documents, Embeddings
  File "/usr/local/lib/python3.12/site-packages/chromadb/__init__.py", line 86, in <module>
    raise RuntimeError(
RuntimeError: Your system has an unsupported version of sqlite3. Chroma                     requires sqlite3 >= 3.35.0.
Please visit                     https://docs.trychroma.com/troubleshooting#sqlite to learn how                     to upgrade.

Possible Solution

None

Additional context

Same result with python 3.10, 3.11 and 3.12 or even installing sqlite3.47 by hand.

[pacowong]

I have to manually install pysqlite3-binary via

pip install pysqlite3-binary

and modified the site-packages/crewai/__init__.py by prepending the following:

__import__('pysqlite3')
import sys
sys.modules['sqlite3'] = sys.modules.pop('pysqlite3')

It is quite hacky but the problem seems to be around for 3 months.