SQLite 基础1

2021-12-01 17:13:55 浏览数 (1)

前言

SQLite 是一个开源的进程内库,实现了自给自足、无服务端、零配置、事务性的 SQL 数据库引擎

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

目前 SQLite 应用极其广泛,我们几乎人手都使用着一个,因为它的轻量特性,IOS和Andriod终端里都嵌入了 SQLite 作为本地数据库,同时它还大量地使用在了各类嵌入式系统中

程序开发的过程中,也可以使用它来替代重量型的RDBMS,类似于Mysql或Postgresql,来进行简单功能测试 (然而sqlite本无意与去它们比较,只是想作一个更强大的fopen())

Think of SQLite not as a replacement for Oracle but as a replacement for fopen()

这里分享一下 SQLite 的相关操作基础,详细内容可以参考 官方文档 , 网络资料参考了 RUNOOB

Tip: 当前的最新版本为 SQLite Release 3.11.1 On 2016-03-03


概要


下载

SQLite下载地址

代码语言:javascript复制
[root@h102 sqlite]# wget http://www.sqlite.org/2016/sqlite-autoconf-3110100.tar.gz
--2016-03-11 23:28:10--  http://www.sqlite.org/2016/sqlite-autoconf-3110100.tar.gz
Resolving www.sqlite.org... 67.18.92.124, 2600:3c00::f03c:91ff:fe96:b959
Connecting to www.sqlite.org|67.18.92.124|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2359545 (2.2M) [application/x-gzip]
Saving to: “sqlite-autoconf-3110100.tar.gz”

100%[============================================================================================>] 2,359,545   16.4K/s   in 2m 3s   

2016-03-11 23:30:14 (18.7 KB/s) - “sqlite-autoconf-3110100.tar.gz” saved [2359545/2359545]

[root@h102 sqlite]# 
[root@h102 sqlite]# ls
sqlite-autoconf-3110100.tar.gz
[root@h102 sqlite]# sha1sum sqlite-autoconf-3110100.tar.gz 
c4b4dcd735a4daf5a2e2bb90f374484c8d4dad29  sqlite-autoconf-3110100.tar.gz
[root@h102 sqlite]# 

0 人点赞