Google
 

关于SQLite

SQLite是一个小型的C程序库，实现了独立的，可嵌入的，零配置的SQL数据库引擎。特性包括：

  • 事务操作是原子，一致，孤立，并且持久的(ACID)，即使在系统崩溃和电源故障之后。
  • 零配置——不需要安装和管理。
  • 实现了绝大多数SQL92标准。 (不支持的特性)
  • 整个数据库存储在一个单一的文件中。
  • 数据库文件可以在不同字节序的机器之间自由地共享。
  • 支持最大可达2T的数据库。 (241 字节)
  • 字符串和BLOB类型的大小最大可达 2G 字节(231字节)。
  • 小的代码： 完整配置的少于250KB，忽略一些可选特性的少于150KB。
  • 在大多数常见操作上比流行的客户/服务器数据库引擎更快。
  • 简单，易于使用的API。
  • 内建TCL绑定。 另外提供可用于许多其他语言的绑定。
  • 具有良好注释的源代码，95%经过测试。
  • 独立：没有外部依赖。
  • 源代码位于公共域。 可用于任何用途。

SQLite发行版包含一个独立的命令行访问程序(sqlite)，可用于管理SQLite数据库，并适合作为一个如何使用SQLite库的例子。

新闻

2009-Aug-10 - Version 3.6.17

这是月度维护版本，集中在 bug 修复，性能提升以及测试覆盖。这是 SQLite 核心达到 100% 分支测试覆盖后的首个发布版本。

另外，为方便扩展开发人员，增加了一个新接口 sqlite3_strnicmp()。

这个版本修复的 bug 都不是严重的。所有已修复的 bug 都是不明显的。可选更新。

2009-Aug-10 - Version 3.6.17

This is a monthly maintenance release with a focus of bug fixes, performance improvements, and increased test coverage. This is the first release of SQLite since 100% branch test coverage was achieved on the SQLite core.

In addition, a new interface sqlite3_strnicmp() is provided for the convenience of extension writers.

None of the bugs fixed in this release are serious. All bugs are obscure. Upgrading is optional.

2009-July-25 - 100% Branch Test Coverage

A subset of the TH3 test suite was measured by gcov to provide 100% branch test coverage over the SQLite core (exclusive of the VFS backend and of extensions such as FTS3 and RTREE) when compiled for SuSE 10.1 Linux on x86. The SQLite developers pledge to maintain branch test coverage at 100% in all future releases. Ongoing work will strive for 100% branch test coverage on the operating-system backends and extensions as well.

2009-Jun-27 - Version 3.6.16

SQLite version 3.6.16 is another general maintenance relase containing performance and robustness enhancements. A single notable bug was fixed (ticket #3929). This bug cause cause INSERT or UPDATE statements to fail on indexed tables that have AFTER triggers that modify the same table and index.

2009-Jun-15 - Version 3.6.15

SQLite version 3.6.15 is a general maintenance release containing performance and robustness enhancements and fixes for various obscure bugs.

2009-May-25 - Version 3.6.14.2

SQLite version 3.6.14.2 fixes an obscure bug in the code generator (ticket #3879) section of SQLite which can potentially cause incorrect query results. The changes from the prior release consist of only this one bug fix, check-in [6676] and a change to the version number text.

The bug was introduced in version 3.6.14. It is recommended that users of version 3.6.14 and 3.6.14.1 upgrade to this release. Applications are unlikely to hit this bug, but since it is difficult to predict which applications might hit it and which might not, we recommend that all users of 3.6.14 and 3.5.14.1 upgrade to this release.

2009-May-19 - Version 3.6.14.1

SQLite version 3.6.14.1 is a patch release to version 3.6.14 with minimal changes that fixes three bugs. Upgrading is only necessary for users who are impacted by one or more of those bugs.

2009-May-07 - Version 3.6.14

SQLite version 3.6.14 provides new performance enhancements in the btree and pager layers and in the query optimizer. Certain workloads can be as much as twice as fast as the previous release, though 10% faster is a more typical result.

Queries against virtual tables that contain OR and IN operators in the WHERE clause are now able to use indexing.

A new optional asynchronous I/O backend is available for unix and windows. The asynchronous backend gives the illusion of faster response time by pushing slow write operations into a background thread. The tradeoff for faster response time is that more memory is required (to hold the content of the pending writes) and if a power failure or program crash occurs, some transactions that appeared to have committed might end up being rolled back upon restart.

This release also contains many minor bug fixes, documentation enhancements, new test cases, and cleanups and simplifications to the source code.

There is no compelling reason to upgrade from versions 3.6.12 or 3.6.13 if those prior versions are working. Though many users may benefit from the improved performance.

2009-Apr-14 - Version 3.6.13

SQLite version 3.6.13 fixes several minor issues that appeared in previous version, including Ticket #3774, ticket #3791, and ticket #3777. This is a bug-fix release only. There are no new features or enhancements.

2009-Mar-31 - Version 3.6.12

SQLite version 3.6.12 fixes a database corruption bug. If an incremental_vacuum is rolled back in an in-memory database, the database will often go corrupt. This only happens for in-memory databases. On-disk databases are unaffected. And the corruption only appears if an incremental vacuum is rolled back. Nevertheless, upgrading is recommended for all applications, especially those that make use of in-memory databases and/or incremental vacuum. See ticket #3761.

SQLite version 3.6.12 also adds support for the sqlite3_unlock_notify() interface and the reverse_unordered_selects pragma and the new ".genfkey" command in the CLI. There are also performance improvements in many count(*) SQL statements.

During testing of version 3.6.12, a bug in the lookaside memory allocator as it relates to shared cache mode was found that effects all prior versions of SQLite back to version 3.6.1. If you are using shared cache mode you should either disable lookaside memory allocation or upgrade to version 3.6.12. See ticket #3743.

2009-Feb-18 - Version 3.6.11

SQLite version 3.6.11 adds support for the hot-backup interface. This interface can be used to create a backup copy of an SQLite database while it is in use. The same interface can be used to initialize an in-memory database from a persistent disk image or to save an in-memory database into a persistent disk image. Usage examples can be found at Using the SQLite Online Backup API.

Old news...

SQLite中文站

京ICP备05007455号