Upgrade sqlite3

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)"