SQLite is Transactional A transactional database is one in which all changes and queries appear to be Atomic, Consistent, Isolated, and Durable (ACID). SQLite implements serializable transactions that are atomic, consistent, isolated, and durable, even if the transaction is interrupted ... 

 ... A zero-terminated string containing the text of one or more SQL statements and/or queries to be processed. A pointer to a callback function which is invoked once for each row in the result of a query. This argument ... 

3.20. The progress method This method registers a callback that is invoked periodically during query processing. There are two arguments: the number of SQLite virtual machine opcodes between invocations, and the TCL command to invoke. Setting the progress callback to an empty string disables ... 

 ... Improvements to the PRAGMA optimize command Enhancements to the date and time functions The ability to put "_" between digits in numeric literals for readability Added the json_pretty() function Improvements to the query planner, especially a new faster implementation for ... 

1. Introduction  ... An imposter table allows the content of an index to be queried or modified as if the index were an ordinary table. Imposter tables are intended for analysis and debugging only. This is not a feature that most application developers ... 

struct sqlite3_index_info, struct sqlite3_index_constraint, struct sqlite3_index_orderby ... 

 ... One such flag is SQLITE_INDEX_SCAN_HEX, which if set causes the EXPLAIN QUERY PLAN output to show the idxNum has hex instead of as decimal. Another flag is SQLITE_INDEX_SCAN_UNIQUE, which if set indicates that the query plan will return at most ... 

 ... This saves the application from having to issue a separate query to figure out exactly what values were inserted. 2. Details The RETURNING clause is followed by a comma-separated list of expressions. These expressions are similar to the expressions ... 

6. Aggregate Queries Can Contain Non-Aggregate Result Columns That Are Not In The GROUP BY Clause In most SQL implementations, output columns of an aggregate query may only reference aggregate functions or columns named in the GROUP BY clause. It does not make good sense to reference an ordinary column in an aggregate query because each ... 

4. Options To Set Default Parameter Values  ... For ordinary FTS3/FTS4 queries, the search tree depth is approximately the base-2 logarithm of the number of terms in the right-hand side of the MATCH operator. However, for phrase queries and NEAR queries the search tree depth ... 

6. Controlling Checksum Verification The cksumvfs extension implements a new PRAGMA statement that can be used to disable, re-enable, or query the status of checksum verification: PRAGMA checksum_verification; -- query status PRAGMA checksum_verification=OFF; -- disable verification PRAGMA checksum_verification=ON; -- re-enable verification The "checksum_verification ...