Small. Fast. Reliable.
Choose any three.
关于 网站地图 文档 下载 许可 新闻 支持

SQLite 文档分类导航
Categorical Index Of SQLite Documents

文档概览
Overview Documents
关于 SQLite
About SQLite		 对SQLite的高度概览以及为何你会想使用它。
A high-level overview of what SQLite is and why you might be interested in using it.
适合SQLite的用户
Appropriate Uses For SQLite		 这篇文档描述了什么场景下合适使用SQLite数据库引擎以及什么场景下客户端/服务端型的数据库引擎更合适。
This document describes situations where SQLite is an appropriate database engine to use versus situations where a client/server database engine might be a better choice.
特点
Distinctive Features		 这篇文档列举并描述了SQLite有别于其他数据库引擎的一些特点。
This document enumerates and describes some of the features of SQLite that make it different from other SQL database engines.
如何测试SQLite
How SQLite Is Tested 		SQLite通过大量周密和详细的测试来保证其可靠性和鲁棒性。该文档确定了在发布SQLite之前需要做多少测试。
The reliability and robustness of SQLite is achieved in large part by thorough and careful testing. This document identifies the many tests that occur before every release of SQLite.
版权
Copyright		 SQLite是完全公开的。本文描述了这其中的含义以及贡献者们带来的影响。
SQLite is in the public domain. This document describes what that means and the implications for contributors.
常见问题
Frequently Asked Questions		 如题
The title of the document says all...
SQLite相关书籍
Books About SQLite		 罗列了关于SQLite的书籍。
A list of independently written books about SQLite.
字母序文档列表
Alphabetical Listing Of Documents		 按照标题字母序列出了本站点的所有页面。
A list of all titled pages on this website, sorted by title.
站点关键词索引
Website Keyword Index		 本站中关键词到页面的相互参照。 A cross-reference from keywords to various pages within this website.
标题索引
Permuted Title Index		 一般称为关键字上下文索引，本文按照关键字顺序列出了所有文档。
Also known as a "keyword in context" or "KWIC" index or as a concordance, this document is a listing of all other documents sorted by keyword.
SQLite编程接口
SQLite Programming Interfaces
文档记录了在编程中如何使用SQLite的API，以及SQL俗语的解释。
Documentation describing the APIs used to program SQLite, and the SQL dialect that it interprets.
SQLite 5分钟快速入门
SQLite In 5 Minutes Or Less		 关于如何使用SQLite的快速入门
A very quick introduction to programming with SQLite.
C/C++ API介绍
Introduction to the C/C++ API 		 本文介绍了C/C++ API。开发者应该先阅读本文，然后再阅读下面的C/C++参考手册。
This document introduces the C/C++ API. Users should read this document before the C/C++ API Reference Guide linked below.
C/C++参考手册
C/C++ API Reference		 本文详细描述了API中的每一个方法。
This document describes each API function separately.
Tcl API 介绍TCL的SQLite接口。
A description of the TCL interface bindings for SQLite.
SQL语法 SQL Syntax 本文介绍在SQLite下得SQL语法。
This document describes the SQL language that is understood by SQLite.
其它命令
Pragma commands		 本文介绍SQLite的性能调优参数和一些其它的数据库命令。
This document describes SQLite performance tuning options and other special purpose database commands.
SQLite3的数据类型
Version 3 DataTypes 		 SQLite3引入了弱类型的概念，值得类型只和值本身有关，而与所存储的列无关。本文更深入的讲解了SQLite3的数据类型。
SQLite version 3 introduces the concept of manifest typing, where the type of a value is associated with the value itself, not the column that it is stored in. This page describes data typing for SQLite version 3 in further detail.
处理Null
Null Handling		 不同的数据库处理NULL是不同的。SQL标准也是模糊不清的。本文对照着其他的数据库引擎介绍SQLite是如何处理NULL的。
Different SQL database engines handle NULLs in different ways. The SQL standards are ambiguous. This document describes how SQLite handles NULLs in comparison with other SQL database engines.
不支持的SQL
Unsupported SQL		 本文介绍SQLite不支持的SQL特性。
This page describes features of SQL that SQLite does not support.
SQLite的特性和扩展
SQLite Features and Extensions
本文介绍SQLite特有的特性以及扩展模块
Pages describing specific features or extension modules of SQLite.
异步IO模式
Asynchronous IO Mode		 本文介绍如何在SQLite做异步IO模块的开发。异步IO通过将数据库写入交个后台线程来换取更快的响应。
IOThis page describes the asynchronous IO extension developed alongside SQLite. Using asynchronous IO can cause SQLite to appear more responsive by delegating database writes to a background thread.
外键支持
Foreign Key Support		 本文介绍了在3.6.19版引入的对外键约束的支持。
This document describes the support for foreign key constraints introduced in version 3.6.19.
共享缓存模式
Shared Cache Mode		 在3.3.0版之后，SQLite能够支持在两个以上的数据库连接之间共享相同的页(page)和模式(schema)的缓存。这个特性对某些程序会特别有用。
Version 3.3.0 and later supports the ability for two or more database connections to share the same page and schema cache. This feature is useful for certain specialized applications.
解锁通知
Unlock Notify		 解锁通知(unlock notify)特性与共享缓存模式结合，能更有效的管理资源（数据库表锁）访问冲突问题。
The "unlock notify" feature can be used in conjunction with shared cache mode to more efficiently manage resource conflict (database table locks).
使用在线备份接口
Using The Online Backup Interface		 在线备份接口可以用来将磁盘数据库文件中的内容复制到内存数据库，反之亦然。还可以用来对正在使用的数据库做热备份。本文给出了一个示例讲解如何使用它。
The online-backup interface can be used to copy content from a disk file into an in-memory database or vice versa and it can make a hot backup of a live database. This application note gives examples of how.
R树(R-Trees)
R-Trees		 本文描述了SQLite 的R-Tree扩展。R-Tree是一种支持快速多维空间范围查询的特殊数据结构，经常用户地理信息系统。
A description of the SQLite R-Tree extension. An R-Tree is a specialized data structure that supports fast multi-dimensional range queries often used in geospatial systems.
全文搜索
Full Text Search		 本文介绍SQLite的 全文搜索（FTS3）扩展。
A description of the SQLite Full Text Search (FTS3) extension.
SQLite升级与向后兼容性
Upgrading SQLite, Backwards Compatibility
从SQLite 3.5迁移到3.6
Moving From SQLite 3.5 to 3.6		 本文介绍SQLite3.5.9与3.6.0版本之间的差别。
A document describing the differences between SQLite version 3.5.9 and 3.6.0.
从SQLite3.4迁移到3.5
Moving From SQLite 3.4 to 3.5		 本文介绍SQLite3.4.2与3.5.0版本之间的差别。
A document describing the differences between SQLite version 3.4.2 and 3.5.0.
发布历史
Release History		 一个从SQLite1.0.0至今的发布年表。
A chronology of SQLite releases going back to version 1.0.0
向后兼容性
Backwards Compatibility		 本文详细记录了SQLite文件格式从1.0.0至今的所有不兼容的变动。
This document details all of the incompatible changes to the SQLite file format that have occurred since version 1.0.0.
私有分支
Private Branches		 本文介绍维护一个私有分支的推荐流程，创建分支，以及如何与公共SQLite源码保持同步。
This document suggests procedures for maintaining a private branch or fork of SQLite and keeping that branch or fork in sync with the public SQLite source tree.
SQLite技术设计文档
SQLite Technical/Design Documentation
SQLite是如何使用临时文件的
Temporary Files Used By SQLite		 SQLite当处理某些SQL语句时可能会使用很多种临时文件。本文介绍许多种SQLite使用的临时文件以及在一些创建文件代价很高的机器上如何避免创建临时文件。
SQLite can potentially use many different temporary files when processing certain SQL statements. This document describes the many kinds of temporary files that SQLite uses and offers suggestions for avoiding them on systems where creating a temporary file is an expensive operation.
内存数据库
In-Memory Databases		 SQLite数据库通常存储在磁盘文件中，不过，SQLite同样也可以用做内存数据库。本文就是介绍如何使用内存数据库。
SQLite normally stores content in a disk file. However, it can also be used as an in-memory database engine. This document explains how.
SQLite是如何实现原子提交的
How SQLite Implements Atomic Commit		 本文介绍了SQLite内部实现事务原子提交的逻辑，即是面对断电也不会产生错误。
A description of the logic within SQLite that implements transactions with atomic commit, even in the face of power failures.
SQLite内部的动态内存分配
Dynamic Memory Allocation in SQLite		 SQLite有一个非常复杂的内存分配子系统，能够进行配置和定制以满足应用中不同的内存需求，并且在内存溢出时保持鲁棒性，防止内存泄露。本文就是介绍这个系统的。
SQLite has a sophisticated memory allocation subsystem that can be configured and customized to meet memory usage requirements of the application and that is robust against out-of-memory conditions and leak-free. This document provides the details.
定制和移植SQLite
Customizing And Porting SQLite		 本文介绍了如何定制构造一个SQLite以及如何移植到新的平台上。
This document explains how to customize the build of SQLite and how to port SQLite to new platforms.
SQLite3中的锁和并发
Locking And Concurrency
In SQLite Version 3		 本文介绍SQLite3中新的锁代码是如何增加并发能力并减少写饥饿的问题的。
A description of how the new locking code in version 3 increases concurrency and decreases the problem of writer starvation.
优化概览
Overview Of The Optimizer		 快速浏览SQLite代码生成器尝试的查询优化。
A quick overview of the various query optimizations that are attempted by the SQLite code generator.
体系结构
Architecture		 SQLite库的体系结构概览，用于方便需要修改源码的用户。
An architectural overview of the SQLite library, useful for those who want to hack the code.
虚拟数据库引擎(VDBE)操作码
VDBE Opcodes		 这是一篇自动生成的各种VDBE支持的操作码的描述。可以作为一个参考手册，方便更好的理解SQLite中EXPLAIN的输出。
This document is an automatically generated description of the various opcodes that the VDBE understands. Programmers can use this document as a reference to better understand the output of EXPLAIN listings from SQLite.
SQLite文件结构
SQLite File Format		 本文介绍了SQLite的数据库文件和日志文件的文件格式，以及使用非SQLite程序读写SQLite数据库的一些细节。
A description of the format used for SQLite database and journal files, and other details required to create software to read and write SQLite databases without using SQLite.
编译选项
Compilation Options		 本文介绍编译器选项，用户修改SQLite的一些默认行为或者去处一些可选的特性以减少库大小。
This document describes the compile time options that may be set to modify the default behavior of the library or omit optional features in order to reduce binary size.
SQLite的限制
Limits In SQLite		 本文介绍SQLite的一些限制（string和blob的最大长度，数据库的最大大小，表的最大数量等），以及如何在编译期和运行期修改这些限制。
This document describes limitations of SQLite (the maximum length of a string or blob, the maximum size of a database, the maximum number of tables in a database, etc.) and how these limits can be altered at compile-time and run-time.
旧文档
Old Documents
这些文档是属于SQLite2的或者是版本2到3过度期的。以及不完全适用于当前版本，不过一些信息依然是有用的缓存。
These documents either pertain to SQLite version 2 or were written during the transition period between versions 2 and 3. They are no longer strictly applicable to recent versions of SQLite, but the information found within may still be useful.
SQLite2的C/C++ API
Version 2 C/C++ API		 本文介绍SQLite 2.8的C/C++接口。
A description of the C/C++ interface bindings for SQLite through version 2.8
SQLite2数据类型
Version 2 DataTypes 		 介绍SQLite2是如何处理SQL数据类型的。简单说：所有都是string。
A description of how SQLite version 2 handles SQL datatypes. Short summary: Everything is a string.
VDBE教程
VDBE Tutorial		 VDBE是SQLite中真正负责执行SQL语句的子系统。本文介绍了SQLite2.7中VDBE的执行原则。对于想修改SQLite源码的人来说这是必读的。
The VDBE is the subsystem within SQLite that does the actual work of executing SQL statements. This page describes the principles of operation for the VDBE in SQLite version 2.7. This is essential reading for anyone who want to modify the SQLite sources.
SQLite3
SQLite Version 3		 SQLite2.8到SQlite3.0的改动概要。
A summary of of the changes between SQLite version 2.8 and SQLite version 3.0.
SQLite3的C/C++ API
Version 3 C/C++ API		 SQLite2.8到SQLite3.0，C/C++ API的修改概要。
A summary of of the API related changes between SQLite version 2.8 and SQLite version 3.0.
速度对比
Speed Comparison		 SQLite2.7.6与PostgreSQL和MySQL的速度对比。
The speed of version 2.7.6 of SQLite is compared against PostgreSQL and MySQL.