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 是一個(gè)嵌入式的 SQL 驅(qū)動(dòng)的數(shù)據(jù)庫引擎，它可以作為數(shù)據(jù)庫引擎或者 C/C++ 庫的接口使用。它由 D. Richard Hipp 在 2000 年創(chuàng)建，它是完全重寫的絕對不包含任何的老程序。自從 2001 年的 2.0 版本 SQLite 的預(yù)發(fā)行版發(fā)布以來源代碼就公開了。

?

The primary design goals when SQLite was conceived were that it should be

SQLite 構(gòu)想時(shí)候的主要設(shè)計(jì)目標(biāo)是：

?

Simple to administer

易于管理

Simple to operate

易于操作

Simple to use in a program

易于在程序中使用

Simple to maintain and customize

易于維護(hù)和定制

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 所說，事實(shí)上 SQLite 很小，很快和可以信賴的，并且證明有卓越的強(qiáng)度， a happy coincidence 。他致力于使 SQLite 簡單化，讓更少的東西出錯(cuò)的副產(chǎn)品就是可信賴性。數(shù)據(jù)庫引擎代碼的簡單化使得它的優(yōu)化容易的多。

?

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 有時(shí)候發(fā)音為 sequel ，雖然在平時(shí)使用當(dāng)中它常常被說成是三個(gè)字母。然而，它的發(fā)明者的發(fā)音是 sequel-lite ，和微軟的 SQL Server 通常的發(fā)音 sequel-server 是一樣的，因此本書里面假設(shè)是這樣。當(dāng)我們談及 SQLite 數(shù)據(jù)庫和 SQL 語句的時(shí)候，它將會(huì)很有幫助，如果你曾經(jīng)聽到過的它們和你閱讀的一樣。