Updating The SQLite3 Build On My Python Install

February 05, 2023 Post a Comment

noob programmer here, I'm trying to get the SQLite3 on my Python installation up-to-date (I currently have version 3.6.11, whereas I need at least version 3.6.19, as that is the fi

Solution 1:

I suggest using the 'pip' command on the command line.

pip search sqlite
pip install pysqlite

Solution 2:

I just came fresh from installing this both in Mavericks and Mountain Lion.

This SO article mentions using the build_static method, which they say retrieves that latest version of the sqlite amalgamation. For some reason it didn't work (ie it didn't seem to download it or use it)

What I ended up doing was

Downloaded pysqlite as a tarball
Downloaded latest sqlite source amalgamation
Unzipped pysqlite into its folder
Unzipped sqlite and copied that to the pysqlite folder
Opened setup.cfg and commented out all of the directives
In Terminal, went to the pysqlite folder, and then:

$ python setup.py build_static install

This compiled pysqlite using the libraries from the latest sqlite sources. And then in Python, I used it as:

import pysqlite2.dbapi2 as sqlite3

Solution 3:

I recently installed python from source and used the following commands to install both SQLite from source and Python 2.7.13 from source.

for SQLite3 you can use the following commands $SQLITE_INSTALL_LOCATION

$ curl -O http://www.sqlite.org/sqlite-autoconf-3070603.tar.gz
$ tar xvfz sqlite-autoconf-3070603.tar.gz
$ cd sqlite-autoconf-3070603
$ ./configure --prefix=$SQLITE_INSTALL_LOCATION --disable-static CFLAGS="-g"
$ make && make install

Then when I compiled my python I edited the setup.py in the root of the Python source

$ curl -O https://www.python.org/ftp/python/2.7.13/Python-2.7.13.tgz
$ tar xvfz Python-2.7.13.tgz

Python-2.7.13/setup.py -- add the path to your SQLite install here: ```

...
# We hunt for #define SQLITE_VERSION "n.n.n"
# We need to find >= sqlite version 3.0.8
sqlite_incdir = sqlite_libdir = None
sqlite_inc_paths = [ '/usr/include',
                     '/usr/include/sqlite',
                     '/usr/include/sqlite3',
                     '/usr/local/include',
                     '/usr/local/include/sqlite',
                     '/usr/local/include/sqlite3',
                   $SQLITE_INSTALL_LOCATION/include,
                 ]
...

Once you've changed the setup.py in your python source finish up compiling and installing python assuming the install location is $PYTHON_INSTALL_LOCATION

$ cd  Python-2.7.13
$ LD_RUN_PATH=$SQLITE_INSTALL_LOCATION/lib ./configure --prefix=$PYTHON_INSTALL_LOCATION --enable-shared --enable-unicode=ucs4
$ LD_RUN_PATH=$SQLITE_INSTALL_LOCATION/lib make 
$ LD_RUN_PATH=$SQLITE_INSTALL_LOCATION/lib make install

Once you do that you should have a Python version with SQLite3 support installed at $PYTHON_INSTALL_LOCATION/bin/python

Hope this helps!

Baca Juga

Solution 4:

Disclaimer: I'm not a Mac User, but by common knowledge i give you this info.

You could follow the next instructions:

Use Homebrew

As this page mention: If you need to upgrade sqlite, you could use Homebrew.

Homebrew implies an aditional "software manager". So you should know how to use it before.

Install it from the source

As this page metion:

Download the sqlite-autoconf package
Compile it and install it:

$ tar xvfz sqlite-autoconf-3071502.tar.gz
$ cd sqlite-autoconf-3071502
$ ./configure --prefix=/usr/local
$ make
$ make install

Either Homebrew or Source, verfy it

>>> import sqlite3
>>> sqlite3.version_info
(2, 4, 1)
>>> sqlite3.sqlite_version_info
(3, 6, 11)

>>> from pysqlite2 import dbapi2 as sqlite3
>>> sqlite3.version_info
(2, 5, 5)
>>> sqlite3.sqlite_version_info
(3, 6, 18)

Maybe you need to uninstall previous version of pysqlite. In any way, you should read this answer to understand better the sqlite/python relationship.

Solution 5:

https://pip.pypa.io/en/latest/installing.html

python get-pip.py

python [complete path]

python c:\folder\get-pip.py

Python Dummy