linux环境下升级sqlite3

Step 1 - 下载源码

wget https://www.sqlite.org/2024/sqlite-autoconf-3460000.tar.gz

Step 2 - 解压tar包

tar -xvf sqlite-autoconf-3460000.tar.gz && cd sqlite-autoconf-3460000

Step 3 - Configure

sudo apt-get install libreadline-dev
./configure

Step 4 - Make

make

Step 4.5 - 删除老版本

sudo apt-get purge sqlite3

Step 5 - Make Install

sudo make install

Step 6 - 添加环境变量

export PATH="/usr/local/bin:$PATH"  # also add in your .bashrc

Step 7 - Verify the installation

sqlite3 --version
3.46.0 2024-05-23 13:25:27 96c92aba00c8375bc32fafcdf12429c58bd8aabfcadab6683e35bbb9cdebf19e (64-bit)