SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private.
SQLite is the most widely deployed database in the world with more applications than we can count, including several high-profile projects.
SQLite是一个进展中的库，它实现了一个自给自足，无服务器，零配置，事务SQL数据库引擎。 SQLite的代码开源，因此可以自由使用，无论商业化或是私人使用。 SQLite是世界上部署最广泛的数据库，拥有无数的应用程序，其中不乏一些知名项目。
SQLite is an embedded SQL database engine.
Unlike most other SQL databases, SQLite does not have a separate server process.
SQLite reads and writes directly to ordinary disk files.
A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures.
These features make SQLite a popular choice as an Application File Format.
Think of SQLite not as a replacement for Oracle but as a replacement for fopen()
SQLite是一个嵌入式SQL数据库引擎。 与其他大多数SQL数据库不同，SQLite没有单独的服务器进程。 SQLite直接读取和写入普通磁盘文件。具有多个表，索引，触发器和视图的一个完整SQL数据库可以被包含在单个磁盘文件中。 该数据库文件的格式是跨平台的 - 您可以在32位和64位系统之间或在大端和小端体系结构之间自由地复制数据库。 这些功能使SQLite成为应用程序文件格式的流行选择。 可以认为SQLite不是Oracle的替代品，而是作为系统调用fopen（）的替代
SQLite is a compact library.
With all features enabled, the library size can be less than 500KiB, depending on the target platform and compiler optimization settings.
(64-bit code is larger.
And some compiler optimizations such as aggressive function inlining and loop unrolling can cause the object code to be much larger.)
If optional features are omitted, the size of the SQLite library can be reduced below 300KiB.
SQLite can also be made to run in minimal stack space (4KiB) and very little heap (100KiB), making SQLite a popular database engine choice on memory constrained gadgets such as cellphones, PDAs, and MP3 players.
There is a tradeoff between memory usage and speed.
SQLite generally runs faster the more memory you give it.
Nevertheless, performance is usually quite good even in low-memory environments.
gadget 小装置
SQLite是一个紧凑的库。 启用所有功能后，库大小也可以小于500KiB，当然具体大小取决于目标平台和编译器优化设置。 （64位代码较大，并且一些编译器优化，如
积极的函数内联 aggressive function inlining
和循环展开可能导致目标代码更大）。如果省略可选功能，SQLite库的大小可以减少到300KiB以下。 SQLite也可以在最小栈空间（4KiB）和非常少的堆（100KiB）中运行，使SQLite成为内存受限设备（例如手机，PDA和MP3播放器）上流行的数据库。 通常需要开发者在内存分配和运行速度之间进行权衡。 ，你给它的内存越多，它就可以运行得越快。当然，即使在低内存环境中，SQLite的性能也是相当不错。
SQLite is very carefully tested prior to every release and has a reputation for being very reliable.
Most of the SQLite source code is devoted purely to testing and verification.
An automated test suite runs millions and millions of test cases involving hundreds of millions of individual SQL statements and achieves 100% branch test coverage.
SQLite responds gracefully to memory allocation failures and disk I/O errors.
Transactions are ACID even if interrupted by system crashes or power failures.
All of this is verified by the automated tests using special test harnesses which simulate system failures.
Of course, even with all this testing, there are still bugs.
But unlike some similar projects (especially commercial competitors) SQLite is open and honest about all bugs and provides bugs lists and minute-by-minute chronologies of code changes.
SQLite在每个版本发布之前都经过非常仔细的测试，并且被大家盛赞可靠性高。 大多数SQLite源代码发布出来是为了专门用于测试和验证。 而且SQLite有一套自动测试套件,可以运行数百万个总共涉及数亿个SQL语句的测试用例程序，并实现100％的分支测试覆盖率。 SQLite正常地响应内存分配故障和磁盘I/O错误。 事务是ACID，即使被系统崩溃或电源故障中断。 所有这些都通过使用模拟系统故障的特殊测试线束的自动化测试来验证。 当然，即使有这些测试，仍然有bug。 但不同于一些类似的项目（特别是商业竞争对手）SQLite以开放和诚实的态度对待所有错误，并提供错误列表和
minute-by-minute chronologies
分钟的代码更改的年代。
The SQLite code base is supported by an international team of developers who work on SQLite full-time.
The developers continue to expand the capabilities of SQLite and enhance its reliability and performance while maintaining backwards compatibility with the published interface spec, SQL syntax, and database file format.
The source code is absolutely free to anybody who wants it, but professional support is also available.
The SQLite project was started on 2000-05-09.
The future is always hard to predict, but the intent of the developers is to support SQLite through the year 2050.
Design decisions are made with that objective in mind.
We the developers hope that you find SQLite useful and we entreat you to use it well: to make good and beautiful products that are fast, reliable, and simple to use.
Seek forgiveness for yourself as you forgive others.
And just as you have received SQLite for free, so also freely give, paying the debt forward.
SQLite代码库由一个国际开发团队支持，他们全程工作于SQLite。 开发人员继续扩展SQLite的功能，增强其可靠性和性
能，同时保持与已发布的接口规范，SQL语法和数据库文件格式的向后兼容性。 源代码是绝对自由的任何人谁想要它，但专业的支持也是可用的。
SQLite项目于2000-05-09开始。 未来总是难以预测的，但是开发人员打算支持SQLite到2050年。所以在设计上的决定是基于这个目标的。
The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private.
SQLite is the most widely deployed database in the world with more applications than we can count, including several high-profile projects.
SQLite是一个进展中的库，它实现了一个自给自足，无服务器，零配置，事务SQL数据库引擎。 SQLite的代码开源，因此可以自由使用，无论商业化或是私人使用。 SQLite是世界上部署最广泛的数据库，拥有无数的应用程序，其中不乏一些知名项目。
SQLite is an embedded SQL database engine.
Unlike most other SQL databases, SQLite does not have a separate server process.
SQLite reads and writes directly to ordinary disk files.
A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures.
These features make SQLite a popular choice as an Application File Format.
Think of SQLite not as a replacement for Oracle but as a replacement for fopen()
SQLite是一个嵌入式SQL数据库引擎。 与其他大多数SQL数据库不同，SQLite没有单独的服务器进程。 SQLite直接读取和写入普通磁盘文件。具有多个表，索引，触发器和视图的一个完整SQL数据库可以被包含在单个磁盘文件中。 该数据库文件的格式是跨平台的 - 您可以在32位和64位系统之间或在大端和小端体系结构之间自由地复制数据库。 这些功能使SQLite成为应用程序文件格式的流行选择。 可以认为SQLite不是Oracle的替代品，而是作为系统调用fopen（）的替代
SQLite is a compact library.
With all features enabled, the library size can be less than 500KiB, depending on the target platform and compiler optimization settings.
(64-bit code is larger.
And some compiler optimizations such as aggressive function inlining and loop unrolling can cause the object code to be much larger.)
If optional features are omitted, the size of the SQLite library can be reduced below 300KiB.
SQLite can also be made to run in minimal stack space (4KiB) and very little heap (100KiB), making SQLite a popular database engine choice on memory constrained gadgets such as cellphones, PDAs, and MP3 players.
There is a tradeoff between memory usage and speed.
SQLite generally runs faster the more memory you give it.
Nevertheless, performance is usually quite good even in low-memory environments.
gadget 小装置
SQLite是一个紧凑的库。 启用所有功能后，库大小也可以小于500KiB，当然具体大小取决于目标平台和编译器优化设置。 （64位代码较大，并且一些编译器优化，如
积极的函数内联 aggressive function inlining
和循环展开可能导致目标代码更大）。如果省略可选功能，SQLite库的大小可以减少到300KiB以下。 SQLite也可以在最小栈空间（4KiB）和非常少的堆（100KiB）中运行，使SQLite成为内存受限设备（例如手机，PDA和MP3播放器）上流行的数据库。 通常需要开发者在内存分配和运行速度之间进行权衡。 ，你给它的内存越多，它就可以运行得越快。当然，即使在低内存环境中，SQLite的性能也是相当不错。
SQLite is very carefully tested prior to every release and has a reputation for being very reliable.
Most of the SQLite source code is devoted purely to testing and verification.
An automated test suite runs millions and millions of test cases involving hundreds of millions of individual SQL statements and achieves 100% branch test coverage.
SQLite responds gracefully to memory allocation failures and disk I/O errors.
Transactions are ACID even if interrupted by system crashes or power failures.
All of this is verified by the automated tests using special test harnesses which simulate system failures.
Of course, even with all this testing, there are still bugs.
But unlike some similar projects (especially commercial competitors) SQLite is open and honest about all bugs and provides bugs lists and minute-by-minute chronologies of code changes.
SQLite在每个版本发布之前都经过非常仔细的测试，并且被大家盛赞可靠性高。 大多数SQLite源代码发布出来是为了专门用于测试和验证。 而且SQLite有一套自动测试套件,可以运行数百万个总共涉及数亿个SQL语句的测试用例程序，并实现100％的分支测试覆盖率。 SQLite正常地响应内存分配故障和磁盘I/O错误。 事务是ACID，即使被系统崩溃或电源故障中断。 所有这些都通过使用模拟系统故障的特殊测试线束的自动化测试来验证。 当然，即使有这些测试，仍然有bug。 但不同于一些类似的项目（特别是商业竞争对手）SQLite以开放和诚实的态度对待所有错误，并提供错误列表和
minute-by-minute chronologies
分钟的代码更改的年代。
The SQLite code base is supported by an international team of developers who work on SQLite full-time.
The developers continue to expand the capabilities of SQLite and enhance its reliability and performance while maintaining backwards compatibility with the published interface spec, SQL syntax, and database file format.
The source code is absolutely free to anybody who wants it, but professional support is also available.
The SQLite project was started on 2000-05-09.
The future is always hard to predict, but the intent of the developers is to support SQLite through the year 2050.
Design decisions are made with that objective in mind.
We the developers hope that you find SQLite useful and we entreat you to use it well: to make good and beautiful products that are fast, reliable, and simple to use.
Seek forgiveness for yourself as you forgive others.
And just as you have received SQLite for free, so also freely give, paying the debt forward.
SQLite代码库由一个国际开发团队支持，他们全程工作于SQLite。 开发人员继续扩展SQLite的功能，增强其可靠性和性
能，同时保持与已发布的接口规范，SQL语法和数据库文件格式的向后兼容性。 源代码是绝对自由的任何人谁想要它，但专业的支持也是可用的。
SQLite项目于2000-05-09开始。 未来总是难以预测的，但是开发人员打算支持SQLite到2050年。所以在设计上的决定是基于这个目标的。
我们开发人员希望你觉得SQLite是有用的，并且我们希望你能够很好的使用它：去创建优秀，美观，快速，可靠，简单的应用。当然，如果你没有做好，也应该像原谅别人那样原谅自己。 正如你已经自由的使用SQLite，所以也请自由地发布。
官网地址SQLite官网
扫一扫
368
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
