The Definitive Guide to SQLite When I first began coding SQLite in the spring of 2000, I never imagined that it would be so enthusiastically received by the programming community. Today, there are millions and millions of copies of SQLite running unnoticed inside computers and gadgets made by hundreds of companies from around the world. You have probably used SQLite before without realizing it. SQLite might be inside your new cell phone or MP3 player or in the set-top box from your cable company. At least one copy of SQLite is probably found on your home computer; it comes built in on Apple’s Mac OS X and on most versions of Linux, and it gets added to Windows when you install any of dozens of third-party software titles. SQLite backs many websites thanks in part to its inclusion in the PHP5 programming language. And SQLite is also known to be used in aircraft avionics, modeling and simulation programs, industrial controllers, smart cards, decision-support packages, and medical information systems. Since there are no reporting requirements on the use of SQLite, there are without doubt countless other deployments that are unknown to me. Much credit for the popularity of SQLite belongs to Michael Owens. Mike’s articles on SQLite in The Linux Journal (June 2003) and in The C/C++ Users Journal (March 2004) int- duced SQLite to countless programmers. The traffic at the SQLite website jumped noticeably after each of these articles appeared. |
Other editions - View all
 |
 |
Common terms and phrases
aggregate application argument attribute B-tree binary BLOB Bobka bytes cache callback function called chapter CHECK constraints Codd Codd's collation column names command-line compiled connection const char CREATE TABLE cursor database file declared default defined DELETE episodes example execute expression Figure filename food_types foods foods_episodes foreign key Fusilli Jerry implemented inner join INSERT install integer INTEGER PRIMARY KEY Jerry JujyFruit Junior Mints keyword logical manifest typing MinGW mode normal form NULL values outer join output pager parameters POSIX PRAGMA primary key provides query language records relational algebra relational databases relational model relational operations result set ROLLBACK ROWID rows schema SELECT clause shell source code specific SQL command SQL statement SQLite SQLite database SQLite DLL sqlite3_step storage class string subquery table name transaction trigger tuples type_id unique UPDATE user-defined users VDBE void Windows