Problem upgrading Sqlite3 version on CentOS for Python

Question

I have CentOS 6 on my system and I'm trying to update SQLite for Python. I've installed it from source and executing sqlite --version returns version 3.33.0 as expected.

However, when I try to check the python SQLite version using import sqlite3; sqlite3.sqlite_version; I still get the previous SQLite version 3.6.20.

Software Locations:
     Python 3.6.9 - /usr/bin/python3
     Sqlite3 - /usr/bin/sqlite3

I've tried the solution here, this does not work at all, after updating LD_LIBRARY_PATH and checking the python SQLite version it still gives '3.6.20', and here, when I try sudo LD_RUN_PATH=, it gives me the error No such file or directory, but when I execute it without sudo LD_RUN_PATH=, it successfully compiles but still gives me SQLite '3.6.20' (Compiled python without uninstalling).

Note: I have multiple python3 versions.

What can I do to resolve this?

Can you go to /usr/bin/python3 and run sqlite3 --version? — Shradha
– Shradha, Commented Oct 3, 2020 at 19:38

Sarol · Accepted Answer · 2020-10-03 19:42:38Z

0

When I did it (specifically trying to find a way to update sqlite3 for a running python program; did not work...), I compiled sqlite and got libsqlite3.so.0.8.6, and then replaced the system-wide sqlite3 with that. For me on debian, that was in /usr/lib/x86_64-linux-gnu. I did see (though now I can't find where) that this way may cause issues when updating in the future. It did update python's sqlite3 for me though.

answered Oct 3, 2020 at 19:42

Sarol

1414 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sbluhm · Accepted Answer · 2020-10-06 05:45:39Z

0

You can import specific versions:

__requires__= 'sqlite3==3.6.20'
import pkg_resources
pkg_resources.require("sqlite3==3.6.20")
import sqlite

Note that this only works on the first import. If sqlite gets imported before pkg_resources, it will take the latest version.

answered Oct 6, 2020 at 5:45

sbluhm

132 bronze badges

Collectives™ on Stack Overflow

Problem upgrading Sqlite3 version on CentOS for Python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related