-
-
Save defulmere/8b9695e415a44271061cc8e272f3c300 to your computer and use it in GitHub Desktop.
# ⚠️ USE AT YOUR OWN RISK | |
# first: pip install pysqlite3-binary | |
# then in settings.py: | |
# these three lines swap the stdlib sqlite3 lib with the pysqlite3 package | |
__import__('pysqlite3') | |
import sys | |
sys.modules['sqlite3'] = sys.modules.pop('pysqlite3') | |
DATABASES = { | |
'default': { | |
'ENGINE': 'django.db.backends.sqlite3', | |
'NAME': os.path.join(BASE_DIR, 'db.sqlite3'), | |
} | |
} |
@cmosta0 Hey what is the pip install command you used to successfully install the binary? Thanks in advance
thinks , u solve my problem, very thinks
@defulmere Thank you very much. This worked for me as well.
This was helpful, worked for me as well !
I was getting following error while trying to run chromadb example code using my python3.10.8 venv3.10:
File "~/venv3.10/lib/python3.10/site-packages/chromadb/__init__.py", line 36, in <module> raise RuntimeError( RuntimeError: Your system has an unsupported version of sqlite3. Chroma requires sqlite3 >= 3.35.0.
I executed following steps to resolve this error:
- Inside my python3.10.8's virtual environment i.e. venv3.10, installed pysqlite3-binary using command:
pip install pysqlite3-binary
- Added these 3 lines in
venv3.10/lib/python3.10/site-packages/chromadb/__init__.py
at the beginning:__import__('pysqlite3') import sys sys.modules['sqlite3'] = sys.modules.pop('pysqlite3')
worked like magic! Thank you!
I tried this couple of months ago and worked, however now it doesn't. the issue is that I'm not even able to install the dependency:
pip install pysqlite3-binary ERROR: Could not find a version that satisfies the requirement pysqlite3-binary (from versions: none) ERROR: No matching distribution found for pysqlite3-binary
I saw the packages are still with the same name on pypi and they were not removed, but not sure what changed and does not work now.
Any ideas?
It also happened to me, until I realized it only works on Linux.
What do we have to do, if we are deploying on streamlit?
Hi. In my case, the issue seems to be related the OS. Actually to be able to install using pip, I needed to use
--platform
onpip install
command, otherwise every attempt just returned the same error mentioned above. (I'm using macbook-pro M2)