更新SQLite3
1、在主目录中获取源代码
cd ~
wget https://www.sqlite.org/2019/sqlite-autoconf-3270200.tar.gz
tar -zxvf sqlite-autoconf-3270200.tar.gz
2、构建并安装
cd sqlite-autoconf-3270200
./configure --prefix=/usr/local/sqlite
make && make install
rm -rf sqlite-autoconf-3270200.tar.gz
rm -rf sqlite-autoconf-3270200
3、查看对比版本
usr/local/sqlite/bin/sqlite3 --version
3.27.2
/usr/bin/sqlite3 --version
3.7.17
4、更改移除旧的sqlite
mv /usr/bin/sqlite3 /usr/bin/sqlite3_old
5 软链接将新的sqlite3设置到/usr/bin目录下
ln -s /usr/local/sqlite/bin/sqlite3 /usr/bin/sqlite3
6.查看当前全局sqlite3的版本
sqlite3 --version
7.将路径传递给共享库
export LD_LIBRARY_PATH="/usr/local/sqlite/lib"
8.查看python的sqlite3版本