sqlite更新

短命女 2022-09-01 07:57 155阅读 0赞

`查看当前版本`

[root@yx03 ~]# sqlite3 --version
    3.7.17 2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668

`linux自带版本为3.7.17，不符合airflow的最低要求3.15`  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI4Njg2OTEx_size_16_color_FFFFFF_t_70]  
`yum无法升级`  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI4Njg2OTEx_size_16_color_FFFFFF_t_70 1]  
`通过源码包安装`  
[下载sqlite-autoconf\*.tar.gz包][sqlite-autoconf_.tar.gz]

wget https://www.sqlite.org/2021/sqlite-autoconf-3360000.tar.gz

解压后编译安装

tar -xzf sqlite-autoconf-3360000.tar.gz -C /opt/
    ./configure --prefix=/usr/local
    make && make install

`软链接`  
查看当前版本还是老版本  
查看安装目录的sqlite版本  
![在这里插入图片描述][65ce115aacd24c1ca38e286f3077768b.png]  
移除默认文件后添加软链接  
![在这里插入图片描述][61b4c40e85bf404fb437ed297c7cb694.png]

`设置默认库路径`

echo 'export LD_LIBRARY_PATH=/usr/local/lib' >> /etc/profile

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI4Njg2OTEx_size_16_color_FFFFFF_t_70 2]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI4Njg2OTEx_size_16_color_FFFFFF_t_70]: /images/20220829/16f4cf9d93394f8db942c0cb65a9932a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI4Njg2OTEx_size_16_color_FFFFFF_t_70 1]: /images/20220829/09c1639b384d4c2193008b1003283167.png
[sqlite-autoconf_.tar.gz]: https://www.sqlite.org/download.html
[65ce115aacd24c1ca38e286f3077768b.png]: /images/20220829/28d96f988e3f450ca5fad8c6ff9d261c.png
[61b4c40e85bf404fb437ed297c7cb694.png]: /images/20220829/64f7d6a6d5664a3eb84897821f59d032.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI4Njg2OTEx_size_16_color_FFFFFF_t_70 2]: /images/20220829/1a03f108b8094bc19d49e9b51c002a9f.png