centos7升级sqlite3

• 安装gcc

yum install gcc -y

• 下载sqlite源码包

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
make && make install
mv /usr/bin/sqlite3  /usr/bin/sqlite3_old    # 备份老版本的sqlite3
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 LD_LIBRARY_PATH="/usr/local/lib"


source /etc/profile

• 删除源码包

rm -rf sqlite-autoconf-3290000 sqlite-autoconf-3290000.tar.gz