yum安装

  1. yum install sqlite-devel

查看sqlite3的版本

sqlite3 -version

升级

下载安装包，https://www.sqlite.org/index.html

wget  https://www.sqlite.org/2019/sqlite-autoconf-3290000.tar.gz

安装

tar zxvf sqlite-autoconf-3290000.tar.gz
cd sqlite-autoconf-3290000/
./configure --prefix=/usr/local/sqlite
make && make install

替换

mv /usr/bin/sqlite3 /usr/bin/sqlite3_old
ln -s /usr/local/bin/sqlite3 /usr/bin/sqlite3
echo"/usr/local/lib" > /etc/ld.so.conf.d/sqlite3.conf
ldconfig
sqlite3 -version

添加环境变量

vim /etc/profile

export SQLITE3_CFLAGS="-I/home/soft/sqlite/include"
export SQLITE3_LIBS="-L/home/soft/sqlite/lib -lsqlite3"
source /etc/profile

修改python中版本

python3
// 分别输入以下内容
import sqlite3
sqlite3.sqlite_version
exit()

image.png

问题

undefined reference to `sqlite3_bind_int’：

// 环境变量添加-I参数
export SQLITE3_CFLAGS="-I/home/soft/sqlite/include"
export SQLITE3_LIBS="-L/home/soft/sqlite/lib -lsqlite3"

https://github.com/OSGeo/PROJ/issues/1847

引用

https://gooyuit.blog.csdn.net/article/details/119780604?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.none-task-blog-2~default~CTRLIST~Rate-1.pc_relevant_aa&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2~default~CTRLIST~Rate-1.pc_relevant_aa&utm_relevant_index=2

https://www.cnblogs.com/iverson-3/p/12381788.html