在好例子网,分享、交流、成长!
您当前所在位置:首页SQL 开发实例SQL基础 → SQLite 权威指南.pdf

SQLite 权威指南.pdf

SQL基础

下载此实例
  • 开发语言:SQL
  • 实例大小:0.94M
  • 下载次数:8
  • 浏览次数:39
  • 发布时间:2022-06-02
  • 实例类别:SQL基础
  • 发 布 人:GoodTimeGGB
  • 文件格式:.pdf
  • 所需积分:2
 相关标签: SQLite 权威指南 sql pdf

实例介绍

【实例简介】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

实例下载地址

SQLite 权威指南.pdf

不能下载?内容有错? 点击这里报错 + 投诉 + 提问

好例子网口号:伸出你的我的手 — 分享

网友评论

发表评论

(您的评论需要经过审核才能显示)

查看所有0条评论>>

小贴士

感谢您为本站写下的评论,您的评论对其它用户来说具有重要的参考价值,所以请认真填写。

  • 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  • 相信您也不想看到一排文字/表情墙,所以请不要反馈意义不大的重复字符,也请尽量不要纯表情的回复。
  • 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  • 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
;
报警