SQLite 权威指南.pdf

【实例截图】

【核心代码】

总目录
■前言
■第 1 章 SQLite 介绍
■第 2 章 入门
■第 3 章 关系模型
■第 4 章 SQL
■第 5 章 设计和概念
■第 6 章 核心 C API
■第 7 章 扩充 C API
■第 8 章 语言扩展
■第 9 章 SQLite 内核
■附录 A SQL 参考
■附录 B C API 参考
■附录 C Codd 的 12 条准则
■索引
 4
目录
SQLite 权威指南..............................................................................................................................1
总目录..............................................................................................................................................3
目录..................................................................................................................................................4
前言..................................................................................................................................................1
第 1 章 SQLite 介绍......................................................................................................................2
内嵌式数据库 ..........................................................................................................................2
开发者的数据库 ......................................................................................................................3
管理员的数据库 ......................................................................................................................3
SQLite 的历史..........................................................................................................................3
谁使用 SQLite..........................................................................................................................4
体系结构 ..................................................................................................................................4
接口(Interface)..................................................................................................................5
编译器(Compiler).............................................................................................................5
虚拟机(Virtual Machine)..................................................................................................5
后端(Back-end) ................................................................................................................6
工具和测试代码(Utilities and Test Code) .......................................................................7
SQLite 的特色..........................................................................................................................7
零配置 ..............................................................................................................................7
兼容性 ..............................................................................................................................7
紧凑性 ..............................................................................................................................7
简单 ..................................................................................................................................8
适应性 ..............................................................................................................................8
不受拘束的授权 ..............................................................................................................8
可靠性 ..............................................................................................................................8
易用性 ..............................................................................................................................8
性能和限制 ..............................................................................................................................9
附加信息 ..................................................................................................................................9
第 2 章 入门 ................................................................................................................................10
从哪得到 SQLite....................................................................................................................10
在 Windows 上使用 SQLite...................................................................................................10
获得命令行程序 ............................................................................................................10
获得 SQLite 的动态链接库(DLL).................................................................................10
在 Windows 环境下编译 SQLite 源代码......................................................................10
用 Microsoft Visual C 构建 SQLite DLL...................................................................11
用 Microsoft Visual C 构建 SQLite CLP....................................................................11
使用 SQLite 数据库...............................................................................................................11
Shell 模式下使用 CLP...................................................................................................11
在命令行方式下执行 CLP............................................................................................15
数据库管理 ............................................................................................................................15
创建、备份和删除数据库.............................................................................................15
 5
获得数据库文件的信息.................................................................................................15
其它 SQLite 工具...................................................................................................................16
第 3 章 关系模型 ........................................................................................................................17
第 4 章 SQL.................................................................................................................................18
关系模型 ................................................................................................................................18
查询语言 ........................................................................................................................18
SQL 的发展....................................................................................................................18
示例数据库 ............................................................................................................................18
建立 ................................................................................................................................19
运行示例 ........................................................................................................................19
语法........................................................................................................................................19
命令 ................................................................................................................................20
常量 ................................................................................................................................20
保留字和标识符 ............................................................................................................20
注释 ................................................................................................................................20
创建一个数据库 ....................................................................................................................21
创建表 ............................................................................................................................21
改变表 ............................................................................................................................21
在数据库中查询 ....................................................................................................................22
关系操作 ........................................................................................................................22
操作管道 ........................................................................................................................23
过滤 ................................................................................................................................23
限定和排序 ....................................................................................................................25
函数(Function)和聚合(Aggregate) ................................................................................26
分组(Grouping) ..............................................................................................................27
去掉重复 ........................................................................................................................27
多表连接 ........................................................................................................................27
名称和别名 ....................................................................................................................28
修改数据 ................................................................................................................................28
插入记录 ........................................................................................................................28
修改记录 ........................................................................................................................28
删除记录 ........................................................................................................................29
数据完整性 ............................................................................................................................29
实体完整性 ....................................................................................................................29
域完整性 ........................................................................................................................30
存储类(Storage Classes).................................................................................................31
弱类型(manifest typing).................................................................................................32
类型亲和性(Type Affinity) ............................................................................................33
事务........................................................................................................................................35
事务的范围 ....................................................................................................................36
冲突解决 ........................................................................................................................36
数据库锁 ........................................................................................................................36
死锁 ................................................................................................................................37
事务的种类 ....................................................................................................................38
 6
数据库管理 ............................................................................................................................38
视图 ................................................................................................................................38
索引 ................................................................................................................................39
触发器 ............................................................................................................................39
附加(Attaching)数据库..................................................................................................40
清洁数据库 ....................................................................................................................40
数据库配置 ....................................................................................................................40
系统表 ............................................................................................................................42
查看 Query 的执行.........................................................................................................42
第 5 章 设计和概念 ....................................................................................................................44
API..........................................................................................................................................44
SQLite 版本 3 的新特性................................................................................................44
主要的数据结构 ............................................................................................................45
核心 API.........................................................................................................................46
操作控制 ........................................................................................................................52
扩充 API.........................................................................................................................53
事务........................................................................................................................................54
事务的生命周期 ............................................................................................................54
锁的状态 ........................................................................................................................55
读事务 ............................................................................................................................56
写事务 ............................................................................................................................56
调整页缓冲区 ................................................................................................................58
等待加锁 ........................................................................................................................59
编码........................................................................................................................................60
使用多个连接 ................................................................................................................60
表锁 ................................................................................................................................61
有趣的临时表 ................................................................................................................62
定案的重要性 ................................................................................................................63
共享缓冲区模式 ............................................................................................................63
第 6 章 核心 C API......................................................................................................................65
封装的查询 ............................................................................................................................65
连接和断开连接 ............................................................................................................65
执行 Query .....................................................................................................................66
字符串处理 ....................................................................................................................69
Get Table 查询................................................................................................................70
预处理的查询 ........................................................................................................................71
取记录 ............................................................................................................................73
参数化的查询 ................................................................................................................76
错误和意外 ............................................................................................................................76
处理错误 ........................................................................................................................76
处理忙状态 ....................................................................................................................78
操作控制 ................................................................................................................................78
提交 Hook 函数..............................................................................................................78
回卷 Hook 函数..............................................................................................................78
 7
修改 Hook 函数..............................................................................................................78
授权函数 ........................................................................................................................79
线程........................................................................................................................................84
共享缓冲区模式 ............................................................................................................85
线程和内存管理 ............................................................................................................85
第 7 章 扩充 C API......................................................................................................................86
API..........................................................................................................................................86
注册函数 ........................................................................................................................86
步进函数 ........................................................................................................................86
返回值 ............................................................................................................................86
函数........................................................................................................................................86
返回值 ............................................................................................................................86
一个完整的例子 ............................................................................................................86
一个实际的应用程序.....................................................................................................88
聚合........................................................................................................................................88
一个实际的例子 ............................................................................................................88
排序法....................................................................................................................................90
排序法定义 ....................................................................................................................90
一个简单的例子 ............................................................................................................90
按需排序(Collation on Demand)....................................................................................93
一个实际的应用程序.....................................................................................................93
第 8 章 语言扩展 ......................................................................................................................100
第 9 章 SQLite 内核..................................................................................................................101
虚拟数据库引擎(VDBE).....................................................................................................101
栈(Stack).......................................................................................................................103
程序体 ..........................................................................................................................103
程序开始与停止 ..........................................................................................................104
指令的类型 ..................................................................................................................105
B-Tree 和 Pager 模型...........................................................................................................105
数据库文件格式 ..........................................................................................................106
B-Tree API....................................................................................................................109
编译器..................................................................................................................................111
分词器(Tokenizer)........................................................................................................111
分析器(Parser)..............................................................................................................112
代码生成器(Code Generator).......................................................................................113
优化 ..............................................................................................................................114