Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Prepare Flags
(c3ref/c_prepare_dont_log.html)
SQLITE_PREPARE_PERSISTENT, SQLITE_PREPARE_NORMALIZE, SQLITE_PREPARE_NO_VTAB, SQLITE_PREPARE_DONT_LOG
... SQLITE_PREPARE_PERSISTENT
The SQLITE_PREPARE_PERSISTENT flag is a hint to the query planner
that the prepared statement will be retained for a long time and
probably reused many times. Without this flag, sqlite3_prepare_v3()
and sqlite3_prepare16_v3() assume that the prepared statement will
be ...
|
|
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... SQLITE_DBCONFIG_ENABLE_QPSG
The SQLITE_DBCONFIG_ENABLE_QPSG option activates or deactivates
the query planner stability guarantee (QPSG). When the QPSG is active,
a single SQL query statement will always use the same algorithm regardless
of values of bound parameters. The QPSG disables some query ...
|
|
Invalid UTF Policy
(invalidutf.html)
1. Garbage In, Garbage Out
... If you insert invalid UTF
into an SQLite database, then try to query that data, what you get back out
might not be exactly what you put in. If you put garbage in, then you
may not complain if you ...
|
|
C API: Run-time Limits
(c3ref/limit.html)
sqlite3_limit()
... The first parameter is the
database connection whose limit is to be set or queried. The
second parameter is one of the limit categories that define a
class of constructs to be size limited. The third parameter is the
new ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... High-Level Query Language.
SQLite is a complete relational database engine, which means that the
application can access content using high-level queries. Application
developers need not spend time thinking about "how" to retrieve the
information they need from a ...
|
|
How SQLite Works
(howitworks.html)
3. Further Reading
... The SQLite query planner and
Next Generation Query Planner documents have further details
on the algorithms SQLite uses to implement SQL statements and
how it goes above choosing an appropriate algorithm for each
individual SQL statement.
This page last modified ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... Consider the following
query:
CREATE TABLE t1(a);
CREATE TABLE t2(x);
SELECT * FROM (SELECT t1.a FROM t1 JOIN t2 ORDER BY t2.x LIMIT 1) ORDER BY 1;
In version 3.5.9 the query above would return ...
|
|
C API: Create and Destroy VFS Filenames
(c3ref/create_filename.html)
sqlite3_create_filename(), sqlite3_free_filename()
... Each pair of pointers in this array corresponds
to a key and value for a query parameter. The P parameter may be a NULL
pointer if N is zero. None of the 2*N pointers in the P array may ...
|
|
Write-Ahead Logging
(wal.html)
9. Sometimes Queries Return SQLITE_BUSY In WAL Mode
... But there are some obscure cases where a query against a WAL-mode
database can return SQLITE_BUSY, so applications should be prepared
for that happenstance.
Cases where a query against a WAL-mode database can return SQLITE_BUSY
include the following ...
|
|
CREATE TABLE
(lang_createtable.html)
... NOT NULL
constraints are not verified during queries, so a query of a column might
produce a NULL value even though the column is marked as NOT NULL, if the
database file is corrupt.
4. Constraint enforcement
Constraints are checked ...
|
Page generated by FTS5 in about 207.19 ms.