Debian Question posted in
The oficial documentation can be found here.

How to change SQLite version used by Python? – Debian

I have Python 3.8 installed alongside SQLite 3.16.2 on Debian 9.12 and I need to upgrade to a newer version of SQLite. I’ve downloaded and compiled the amalgamation available on the SQLite’s site, and put it in /usr/bin, so when I do

$ sqlite3 --version

I get 3.32.3 in response (which is the version I compiled).

However, when I do

$ python3.8
>>> import sqlite3
>>> sqlite3.sqlite_version

I get 3.16.2, which is the earlier version. How do I change the SQLite version picked up by Python?

mkrieger1 suggested that this question may answer mine. It won’t work here, as the solution provided there is directed at Python 2, not Python 3. pysqlite2 does not work with Python 3.

Tags:

2

Answers


  1. 0

    The way I would go around it, is by finding out the path to the old sqlite version that you are importing:

    import sqlite3
print(sqlite3.__file__)

    For me, this outputs:

    C:UsersYOUR_USERNAME_HEREAppDataLocalProgramsPythonPython38libsqlite3__init__.py

    Go to the lib path:

    C:UsersYOUR_USERNAME_HEREAppDataLocalProgramsPythonPython38lib

    Then find the sqlite3 folder and delete it, then replace it with your up-to-date version. Re-try:

    >>> import sqlite3
>>> sqlite3.sqlite_version

    You should get your new version.

    Login or Signup to reply.
  2. 0

    In my case I cannot replace with newer version because I cannot find these files. (I installed the sqlite-autoconf-3350500)

    I used another manner to let it work just execute below command

    export LD_LIBRARY_PATH="/usr/local/lib"

>>> import sqlite3
>>> sqlite3.sqlite_version
'3.35.5'
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search