centos7安装sqlite3

下载sqlite最新源码包安装:

wget http://www.sqlite.org/2020/sqlite-autoconf-3320200.tar.gz

解压:

[root@localhost ~]# tar zxvf sqlite-autoconf-3320200.tar.gz -C /usr/src

yum安装gcc

yum -y install gcc gcc-c++ kernel-devel

或者

yum groupinstall "Development Tools"

编译安装:

cd /usr/src
cd sqlite-autoconf-3320200/

./configure --prefix=/usr/local/sqlite

make && make install

替换版本

mv /usr/bin/sqlite3 /usr/bin/sqlite3_old
cd /usr/local/sqlite/bin/
ln -s /usr/local/sqlite/bin/sqlite3 /usr/bin/sqlite3

建立链接要写绝对路径，否则可能会造成链接不唯一错误。

共享库修改，注意sqlite的安装路径

vim /etc/profile

export LD_LIBRARY_PATH="/usr/local/sqlite/lib"

配置生效

source /etc/profile

查看sqlite版本信息

[root@localhost bin]# sqlite3 --version
3.32.2 2020-06-04 12:58:43 ec02243ea6ce33b090870ae55ab8aa2534b54d216d45c4aa2fdbb00e86861e8c

python查看sqlite版本信息:

[root@localhost ~]# python3
Python 3.6.8 (default, Apr  2 2020, 13:34:55)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-39)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> sqlite3.sqlite_version
'3.32.2'
>>>

进入sqlite3

(venv3) [root@localhost mysite]# sqlite3 db.sqlite3
SQLite version 3.32.2 2020-06-04 12:58:43
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.

查看当前数据库

sqlite> .databases
main: /root/mysite/db.sqlite3

查看当前表

sqlite> .tables
auth_group                  blog_blogpost
auth_group_permissions      django_admin_log
auth_permission             django_content_type
auth_user                   django_migrations
auth_user_groups            django_session
auth_user_user_permissions

查看表内容

sqlite> select * from django_migrations;
1|contenttypes|0001_initial|2020-06-21 01:59:45.159548
2|auth|0001_initial|2020-06-21 01:59:45.200128
3|admin|0001_initial|2020-06-21 01:59:45.253468
4|admin|0002_logentry_remove_auto_add|2020-06-21 01:59:45.319432
5|admin|0003_logentry_add_action_flag_choices|2020-06-21 01:59:45.380602