search

coleifer / pysqlite3

SQLite3 DB-API 2.0 driver from Python 3, packaged separately, with improvements
zlib License
183 stars 51 forks source link

pysqlite3-binary still using old SQLite version #39

Closed isratmir closed 2 years ago

isratmir commented 2 years ago

Hi. Want to use SQLite v3.38.

Installed library and expected there'll be the new version of SQLite. But

pipenv install pysqlite3-binary

"version": "==0.4.7.post5"

image

Am I missing something?

coleifer commented 2 years ago

It works on my machine, not sure what to tell you.

$ pip install pysqlite3-binary
Collecting pysqlite3-binary
  Downloading pysqlite3_binary-0.4.7.post5-cp37-cp37m-manylinux_2_24_x86_64.whl (3.6 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.6/3.6 MB 4.3 MB/s eta 0:00:00
Installing collected packages: pysqlite3-binary
Successfully installed pysqlite3-binary-0.4.7.post5

$ python
Python 3.7.3 (default, Jan 22 2021, 20:04:44) 
[GCC 8.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> from pysqlite3 import dbapi2 as sqlite3
>>> sqlite3.sqlite_version
'3.38.5'
AbdealiLoKo commented 2 years ago

I came across this cause I thought I had a similar issue. Digging a bit more I realized I had mixed up which environment I has pysqlite3 and which environment I had pysqlite3-binary Once I opened the python shell in the correct environment - it worked fine :+1: