Full-Featured SQL
(fullsql.html)
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 ...
|
C API: Mutex Verification Routines
(c3ref/mutex_held.html)
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
(inmemorydb.html)
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 ...
|
NUL Characters In Strings
(nulinstr.html)
2. Unexpected Behavior
... But it is how SQLite works.
|
Contact Information
(contact.html)
1. Contact The Business Inquiries
Richard Hipp
<drh@sqlite.org>
6200 Maple Cove Lane
Charlotte NC 28269
+1-704-948-4565
|
C API: Determine If An SQL Statement Is Complete
(c3ref/complete.html)
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 ...
|
C API: Text Encodings
(c3ref/c_any.html)
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.
|
The INDEXED BY Clause
(lang_indexedby.html)
... 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 ...
|
C API: Enable Or Disable Extended Result Codes
(c3ref/extended_result_codes.html)
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.
|
C API: File Locking Levels
(c3ref/c_lock_exclusive.html)
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.
|
Page generated by FTS5 in about 458.69 ms.