Upgrade sqlite3
Jump to navigation
Jump to search
This is a quick guide to upgrade sqlite3 on server and in python
Download sqlite3 source code
cd /tmp wget https://sqlite.org/2022/sqlite-autoconf-<version>.tar.gz tar xvf sqlite-autoconf-<version>.tar.gz
Compile
cd sqlite-autoconf-<version> ./configure make make install ** the new sqlite3 library will be install into /usr/local/lib
Make server and python compiler "see" the new library
You must add this line to /root/.bashrc and/or /etc/profile
export LD_LIBRARY_PATH="/usr/local/lib"
To check:
python3 -c "import sqlite3; print(sqlite3.sqlite_version)"