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著