Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The SQLite R*Tree Module
(rtree.html)
7.2. Integrity Check using the rtreecheck() SQL function
... Running rtreecheck() on an R*Tree
virtual table is similar to running PRAGMA integrity_check on a
database.
Example: To verify that an R*Tree named "demo_index" is well-formed
and internally consistent, run:
SELECT rtreecheck('demo_index');
The rtreecheck() function performs ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... The
sqlite3_busy_timeout() and sqlite3_busy_handler() interfaces and
the busy_timeout pragma are available to process B to help it deal
with SQLITE_BUSY errors.
An SQLITE_BUSY error can occur at any point in a transaction: when the
transaction is first started, during any ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
4.1. Computing and controlling parameters M and n
... Prior to the introduction of these new mechanisms, the only way
to control pagecache memory is using the cache_size pragma.
Safety-critical applications will usually want to modify the
default lookaside memory configuration so that when the initial
lookaside memory ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... Use "PRAGMA vdbe_trace=ON;" to turn tracing on and
"PRAGMA vdbe_trace=OFF" to turn tracing back off.
Like this:
sqlite> PRAGMA vdbe_trace=ON;
0 Halt ...
|
|
Command Line Shell For SQLite
(cli.html)
13. Database Content Self-Tests
... If there is no selftest table, the ".selftest" command runs
PRAGMA integrity_check.
The ".selftest --init" command creates the selftest table if it
does not already exists, then appends entries that check the SHA3
hash of the content of all tables ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
7.3. The "integrity-check" command
... The "integrity-check" command is similar in concept to
PRAGMA integrity_check. In a working system, the "integrity-command"
should always be successful. Possible causes of integrity-check
failures include:
The application has made changes to the FTS shadow tables
directly ...
|
|
SQLite FTS5 Extension
(fts5.html)
6.13. The 'secure-delete' Configuration Option
... To also ensure that they may
not be recovered by attackers with access to the SQLite database file
itself, the application must also enable the SQLite core secure-delete
option with a command like
"PRAGMA secure_delete = 1".
Warning: Once one ...
|
Page generated by FTS5 in about 129.48 ms.