2.2. Bytecode Is Easier To Debug  ... In debugging builds of SQLite, the PRAGMA vdbe_trace=ON; command will cause a trace of the bytecode execution to appear on the console.

3. Security Implications  ... Use the PRAGMA trusted_schema=OFF SQL statement to disable trusted schema. This has the same effect as the previous bullet, but does not require the use of C-code and hence can be performed in programs written in another programming ... 

2.2. Possible Enhancements  ... However, if in-memory database pInMemory has just been opened (and is therefore completely empty) before being passed to function loadOrSaveDb(), then it is still possible to change its page size using an SQLite "PRAGMA page_size" command. Function loadOrSaveDb() could ... 

 ... This allows options and parameters, such as the native text representation and default page size, to be set using PRAGMA statements. The sqlite3_errcode() routine returns a result code for the most recent major API call. sqlite3_errmsg() returns an English-language ... 

4. Foreign Key Enforcement Is Off By Default  ... Applications can activate foreign key enforcement at run-time using the PRAGMA foreign_keys statement. Or, foreign key enforcement can be activated at compile-time using the -DSQLITE_DEFAULT_FOREIGN_KEYS=1 compile-time option.

3. Status Of Recent SQLite CVEs  ... a NULL pointer dereference and denial-of-service. (details) CVE-2019-19646 3.31.0(2020-01-22) The PRAGMA integrity_check command might cause the byte-code for a prepared statement to loop indefinitely. This might enable a denial-of ... 

3.2. I/O Error Testing  ... In I/O error tests, after the I/O error simulation failure mechanism is disabled, the database is examined using PRAGMA integrity_check to make sure that the I/O error has not introduced database corruption.

 ... See also the compile_options pragma. sqlite_compileoption_used(X) The sqlite_compileoption_used() SQL function is a wrapper around the sqlite3_compileoption_used() C/C++ function. When the argument X to sqlite_compileoption_used(X) is a string which is the name of a compile-time option, this ... 

 ... The LIKE operator can be made case sensitive using the case_sensitive_like pragma. The GLOB operator is similar to LIKE but uses the Unix file globbing syntax for its wildcards. Also, GLOB is case sensitive, unlike LIKE. Both GLOB and LIKE ... 

1.5. Variations When PRAGMA locking_mode=EXCLUSIVE (exclusive locking mode) is set, only a single client is allowed to have the database open at one time. Since only a single client can use the database, the shm file is omitted. The single client ...