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 語句的時候，它將會很有幫助，如果你曾經聽到過的它們和你閱讀的一樣。