S.l.e!ep.￠%

SQLite 的介绍 ( 翻译 )

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 构想时候的主要设计目标是：

Simple to administer

易于管理

Simple to operate

易于操作

Simple to use in a program

易于在程序中使用

Simple to maintain and customize

易于维护和定制

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 语句的时候，它将会很有帮助，如果你曾经听到过的它们和你阅读的一样。