3.2. Disabling sync using PRAGMAs The sync operations that SQLite performs to help ensure integrity can be disabled at run-time using the synchronous pragma. By setting PRAGMA synchronous=OFF, all sync operations are omitted. This makes SQLite seem to run faster, but it also ... 

sqlite3_snapshot_open()

 ... Run "PRAGMA application_id" against a newly opened database connection in order to make it ready to use snapshots.) The sqlite3_snapshot_open() interface is only available when the SQLITE_ENABLE_SNAPSHOT compile-time option is used. See also lists of Objects, Constants, and Functions.

2.3. Limitations  ... Generated columns are not included in the list of columns provided by the PRAGMA table_info statement. But they are included in the output of the newer PRAGMA table_xinfo statement.

2.2.1. Read-Uncommitted Isolation Mode The behaviour described above may be modified slightly by using the read_uncommitted pragma to change the isolation level from serialized (the default), to read-uncommitted. A database connection in read-uncommitted mode does not attempt to obtain read-locks before ... 

3. Limitations  ... Future enhancements will try to return new completions taken from function and pragma names and other sources, as well as consider more context. The completion table should be considered a work-in-progress.

4. The Need For Over 200 SQL Statements Per Webpage  ... The following is a log of all SQL used to generate one particular timeline (captured on 2016-09-16): -- sqlite3_open: /home/drh/sqlite/sqlite/.fslckout PRAGMA foreign_keys=OFF; SELECT sql FROM localdb.sqlite_schema WHERE name=='vfile'; -- sqlite3_open: /home/drh/.fossil ... 

 ... Constraint enforcement Constraints are checked during INSERT and UPDATE and by PRAGMA integrity_check and PRAGMA quick_check and sometimes by ALTER TABLE. Queries and DELETE statements do not normally verify constraints. Hence, if a database file has been corrupted (perhaps by ... 

 ... This release contains new pragmas: the secure_delete pragma, and the compile_options pragma. There are a new SQL functions: sqlite_compileoption_used() and sqlite_compileoption_get(). New C/C++ interfaces: sqlite3_compileoption_used(), sqlite3_compileoption_get(), SQLITE_CONFIG_LOG, and sqlite3_log(). This release also includes several minor bug fixes and performance ... 

 ... Any command that accesses the database (basically, any SQL command, except a few PRAGMA statements) will automatically start a transaction if one is not already in effect. Automatically started transactions are committed when the last SQL statement finishes. Transactions can ... 

2.1. Manually Created Imposter Tables  ... CREATE TABLE t2(b TEXT,c INT,a INT, PRIMARY KEY(b,c,a)) WITHOUT ROWID; To create a permanent imposter table "t2" against index "t1bc" one should first enable editing of the sqlite_schema table by running "PRAGMA writable_schema=ON ...