3.1. Disk drives that do not honor sync requests  ... One can easily see this by committing a large transaction to an SQLite database on a USB memory stick. The COMMIT command will return relatively quickly, indicating that the memory stick has told the operating system and the operating system ... 

 ... The writer must still obtain an exclusive lock on the database for a brief interval in order to commit its changes, but the exclusive lock is no longer required for the entire write operation. A more detailed report on the ... 

sqlite3_unlock_notify()

 ... Shared-cache locks are released when a database connection concludes its current transaction, either by committing it or rolling it back. When a connection (known as the blocked connection) fails to obtain a shared-cache lock and SQLITE_LOCKED is returned ... 

3.23. The commit_hook method This method registers a callback routine that is invoked just before SQLite tries to commit changes to a database. If the callback throws an exception or returns a non-zero result, then the transaction rolls back rather than commit.

3. The AUTOINCREMENT Keyword  ... Only ROWID values from previous transactions that were committed are considered. ROWID values that were rolled back are ignored and can be reused. SQLite keeps track of the largest ROWID using an internal table named "sqlite_sequence". The sqlite_sequence table is ... 

 ... originally enabled then run PRAGMA foreign_key_check to verify that the schema change did not break any foreign key constraints. Commit the transaction started in step 2. If foreign keys constraints were originally enabled, reenable them now. Caution: Take care to ... 

2.4. Git does not track historical branch names  ... https://github.com/sqlite/sqlite/commits/prefer-coroutine-sort-subquery Fossil: https://sqlite.org/src/timeline?r=prefer-coroutine-sort-subquery The Fossil view clearly shows that the branch was eventually merged back into trunk. It shows where the branch ... 

 ... First, changes to the database are not supposed to be visible to other processes until after the transaction commits and so the changes must occur in private memory. Second, SQLite uses a read-only memory map to prevent stray pointers ... 

4.5. Reader Algorithm  ... If so, then the last valid instance of page P that is followed by a commit frame or is a commit frame itself becomes the value read. If the WAL contains no copies of page P that are valid and ... 

3. Further Reading The Atomic Commit document describes how SQLite implements transactions. The bytecode engine document has more information on the bytecode format used by SQLite, and how to view and interpret an SQLite prepared statement. The SQLite query planner and Next Generation ...