Introduction
介绍
SQLite is an embeddable SQL-driven database engine that implements both the database engine and its interface as a C/C++ library. Started in 2000 by D. Richard Hipp, it was written from the ground up and contains absolutely no legacy code, and the SQLite source code has been in the public domain since the first prerelease of version 2.0 in 2001.
SQLite是一个嵌入式的SQL驱动的数据库引擎,它可以作为数据库引擎或者C/C++库的接口使用。它由D. Richard Hipp在2000年创建,它是完全重写的绝对不包含任何的老程序。自从2001年的2.0版本SQLite的预发行版发布以来源代码就公开了。
The primary design goals when SQLite was conceived were that it should be
SQLite构想时候的主要设计目标是:
The fact that SQLite is small, fast, and reliable arguably its greatest strengthsis, according to Hipp, a happy coincidence. He concentrated on making SQLite simple, and reliability is a byproduct of having fewer things to go wrong. Having simpler code in the database engine makes it much easier to optimize.
按Hipp所说,事实上SQLite很小,很快和可以信赖的,并且证明有卓越的强度,a happy coincidence。他致力于使SQLite简单化,让更少的东西出错的副产品就是可信赖性。数据库引擎代码的简单化使得它的优化容易的多。
Note
注意
The acronym SQL is sometimes pronounced sequel, although in common usage it is most often said as three letters. SQLite, however, is pronounced sequel-lite by its creatorin the same way that Microsoft SQL Server is usually pronounced sequel-serverand therefore that is how we have assumed it is said in this book. As we will refer to a SQLite database and an SQL statement, it will help if you are used to hearing them this way as you read on.
首字母所写SQL有时候发音为sequel,虽然在平时使用当中它常常被说成是三个字母。然而,它的发明者的发音是sequel-lite,和微软的SQL Server通常的发音 sequel-server是一样的,因此本书里面假设是这样。当我们谈及SQLite数据库和SQL语句的时候,它将会很有帮助,如果你曾经听到过的它们和你阅读的一样。
摘自《SQLite》Chris Newman著