Do not be misled by the "Lite" in the name. SQLite has a full-featured SQL implementation, including: Tables, indexes, triggers, and views in unlimited quantity Up to 32K columns in a table and unlimited rows Multi-column indexes Indexes ... 

sqlite3_mutex_held(), sqlite3_mutex_notheld()

 ... The SQLite core never uses these routines except inside an assert() and applications are advised to follow the lead of the core. The SQLite core only provides implementations for these routines when it is compiled with the SQLITE_DEBUG flag. External ... 

In-Memory Databases An SQLite database is normally stored in a single ordinary disk file. However, in certain circumstances, the database might be stored in memory. The most common way to force an SQLite database to exist purely in memory ... 

2. Unexpected Behavior  ... But it is how SQLite works.

1. Contact The Business Inquiries Richard Hipp <drh@sqlite.org> 6200 Maple Cove Lane Charlotte NC 28269 +1-704-948-4565

sqlite3_complete(), sqlite3_complete16()

These routines are useful during command-line input to determine if the currently entered text seems to form a complete SQL statement or if additional input is needed before sending the text into SQLite for parsing. These routines return 1 ... 

SQLITE_UTF8, SQLITE_UTF16LE, SQLITE_UTF16BE, SQLITE_UTF16, SQLITE_ANY, SQLITE_UTF16_ALIGNED

These constant define integer codes that represent the various text encodings supported by SQLite. See also lists of Objects, Constants, and Functions.

 ... How INDEXED BY Works The INDEXED BY phrase forces the SQLite query planner to use a particular named index on a DELETE, SELECT, or UPDATE statement. The INDEXED BY phrase is an SQLite extension and is not portable to other ... 

sqlite3_extended_result_codes()

The sqlite3_extended_result_codes() routine enables or disables the extended result codes feature of SQLite. The extended result codes are disabled by default for historical compatibility. See also lists of Objects, Constants, and Functions.

SQLITE_LOCK_NONE, SQLITE_LOCK_SHARED, SQLITE_LOCK_RESERVED, SQLITE_LOCK_PENDING, SQLITE_LOCK_EXCLUSIVE

SQLite uses one of these integer values as the second argument to calls it makes to the xLock() and xUnlock() methods of an sqlite3_io_methods object. See also lists of Objects, Constants, and Functions.