升级sqlite

 

1.安装依赖包
yum install sqlite-devel
yum install gcc

 

2.查看当前的版本
[root@localhost db_dir]# sqlite3 -version
3.7.17 2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668

 

3.下载相应的版本
wget --no-check-certificate https://www.sqlite.org/2023/sqlite-autoconf-3420000.tar.gz

4.编译安装
tar zxvf sqlite-autoconf-3420000.tar.gz
cd sqlite-autoconf-3420000/
./configure --prefix=/usr/local
make && make install

 

5.删除旧版，替换新版
mv /usr/bin/sqlite3 /usr/bin/sqlite3_old
ln -s /usr/local/bin/sqlite3 /usr/bin/sqlite3

6.查看新版本:
[root@localhost db_dir]# sqlite3 -version
3.42.0 2023-05-16 12:36:15 831d0fb2836b71c9bc51067c49fee4b8f18047814f2ff22d817d25195cf350b0

7.打开db文件并查询
[root@localhost db_dir]# sqlite3
.open logstash_sqlite.db
sqlite> select * from since_table;
logstash_since_app_message_all|65445a021d992ec438987ead