How to override an old sqlite3 module with pysqlite3 in django settings.py

settings.py

# ⚠️ 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'),
    }
}

It seems like they know the issue. It just matters on them upgrading the Debian OS from bullseye to bookworm https://discuss.streamlit.io/t/debian-11-eol/80690/7

This seemed to work for me:

1. Download the Latest SQLite Source:
   wget https://www.sqlite.org/2023/sqlite-autoconf-3430100.tar.gz

2. Extract the Downloaded File:
   tar -xvf sqlite-autoconf-3430100.tar.gz
   cd sqlite-autoconf-3430100

3. Build and Install SQLite:
   ./configure
   make
   sudo make install

4. Verify the Installation:
   After installation, confirm that the new version is available:
   sqlite3 --version

5. Verify in Python:
   Ensure that Python picks up the updated SQLite version:

python -c "import sqlite3; print(sqlite3.sqlite_version)"

thanks, worked for me.

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

Worked perfectly for me too.

This gives the error
NameError: name 'sqlite3' is not defined

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

Hi, I tried the solutions above, I have pysqlite3-binary in requirements.txt. I have added the following to the streamlit_app.py code. I am on Python version 3.10.15. I have sqlite 3.43.2 available on my mac.

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

But the following gives me the error of "No module named 'pysqlite3'"

Running pip install pysqlite3 is unsuccessful, giving the error "ERROR: Failed to build installable wheels for some pyproject.toml based projects (pysqlite3)"

Can someone help. I face the issue when trying to deploy the app on streamlit. It worked perfectly for me on the local.