Upgrading SQLite3 version used in python3 on linux?
sqlite3 is kind of external library.so, you need to set external library path.
try next command
printenv LD_LIBRARY_PATHresult will be empty, if you never set before.
next command will work using installed sqlite3 for python
export LD_LIBRARY_PATH="/usr/local/lib"then, you can execute and get correct version you installed
import sqlite3print(sqlite3.sqlite_version)but this method will be reset when you logout and login again.so, if you want to do regist that environment variable every time you login, you should edit /etc/profile
sudo vi /etc/profileand add export code
export LD_LIBRARY_PATH="/usr/local/lib"then, if you log-out and log-in again, you can see LD_LIBRARY_PATH is registered.
In Ubuntu, you can add dqlite repository and update it using apt.
sudo add-apt-repository -y ppa:dqlite/stablesudo apt updatesudo apt install sqlite3