Can I use a later of version of sqlite3 with python?

Question

I am using python 3.5.1 which comes with an sqlite version of 3.8.11. I wonder if I could use another version of sqlite (say the latest one as of now) with my current python. If the answer is yes then how do I do that? Learning from here I tried this but it does not do anything:

pip install sqlite3 --upgrade

I am using sqlite3 in my django project that needs full-text search. So I was reading this, and at a point I was tempted to use the latest version of sqlite3 as it said it had some improvements over the previous versions, which seemed interesting to me. Anyway, is it possible to use later version of sqlite3 without upgrading python?

Note: the question is almost completely re-written, so many comments may seem irrelevant. Thanks to Alasdair, I came to know that the previous question didn't make any sense, hence I re-wrote it.

sqlite3 is part of the Python *installation*, not an external library, so it's not upgradeable using pip. I'm not sure whether sqlite3 is upgradeable without upgrading to a new version of Python. Doing a quick google search suggests that some people have tried replacing dll files. That is Windows specific, and it seems very hacky to me. — Alasdair, Jan 25 '16 at 11:57

score 5 · Accepted Answer · answered Jan 26 '16 at 10:26

5

After some googling I found a way to do this. You need to download the sqlite3.dll (pre-compiled binary) file from here. Then copy over this file in the DLLs folder in the python installation directory. You may want to make a backup of your old sqlite3.dll file just in case you may decide to revert.

answered Jan 26 '16 at 10:26

Sнаđошƒаӽ

16,753
12
73
90

I've came up to the same solution but now the question is "is it possible to load this dll not from DLL folder"? – Serge Norin Oct 13 '17 at 10:45
@SergeNorin I am not sure, but somehow I don't think so. I think where to read DLLs from is something built into python. But who knows! – Sнаđошƒаӽ Oct 13 '17 at 12:29
1

But what if on a Linux machine? – Hanson May 27 '19 at 16:49
@hanson don't know how to do the same on a Linux machine. If you happen to find a way, do post as an answer. – Sнаđошƒаӽ Feb 21 '20 at 17:44

Can I use a later of version of sqlite3 with python?

1 Answers1

Linked