9.3.2. Segment B-Tree Interior Nodes The following diagram depicts the format of a segment b-tree interior (non-leaf) node. Segment B-Tree Interior Node Format

sqlite3_sleep()

 ... In SQLite version 3.42.0 and later, a negative argument passed into sqlite3_sleep() is changed to zero before it is relayed down into the xSleep method of the VFS. See also lists of Objects, Constants, and Functions.

3. Platform Configuration _HAVE_SQLITE_CONFIG_H If the _HAVE_SQLITE_CONFIG_H macro is defined then the SQLite source code will attempt to #include a file named "sqlite_cfg.h". The "sqlite_cfg.h" file usually contains other configuration options, especially "HAVE_INTERFACE" type options generated by the configure process. Note ... 

3.3. FTS5 Prefix Queries If a "*" character follows a string within an FTS expression, then the final token extracted from the string is marked as a prefix token. As you might expect, a prefix token matches any document token of which it is a ... 

sqlite3_uri_parameter(), sqlite3_uri_boolean(), sqlite3_uri_int64(), sqlite3_uri_key()

 ... Beginning with SQLite version 3.31.0 (2020-01-22) the input F parameter can also be the name of a rollback journal file or WAL file in addition to the main database file. Prior to version 3.31.0 ... 

 ... History UPSERT syntax was added to SQLite with version 3.24.0 (2018-06-04). The original implementation closely followed the PostgreSQL syntax in that it only permitted a single ON CONFLICT clause and it required a conflict target for ... 

 ... For all versions of SQLite up to and including 3.6.23.1, a call to sqlite3_reset() was required after sqlite3_step() returned anything other than SQLITE_ROW before any subsequent invocation of sqlite3_step(). Failure to reset the prepared statement using sqlite3_reset ... 

3.3. Finding The Best Query Plan Prior to version 3.8.0 (2013-08-26), SQLite always used the "Nearest Neighbor" or "NN" heuristic when searching for the best query plan. The NN heuristic makes a single traversal of the graph, always choosing the lowest-cost ... 

 ... The Test Harness #3 (TH3) is an alternative set of test vectors for SQLite that verify the operation of SQLite in an as-deployed configuration on embedded platforms with 100% branch test coverage.

2.3. Variations The -DSQLITE_DIRECT_OVERFLOW_READ compile-time option causes SQLite to bypass its page cache when reading content from overflow pages. This helps database reads of 10K blobs run a little faster, but not all that much faster. SQLite still holds a speed ...