sqlite3_get_autocommit()

 ... Autocommit mode is re-enabled by a COMMIT or ROLLBACK. If certain kinds of errors occur on a statement within a multi-statement transaction (errors including SQLITE_FULL, SQLITE_IOERR, SQLITE_NOMEM, SQLITE_BUSY, and SQLITE_INTERRUPT) then the transaction might be rolled back automatically ... 

sqlite3_commit_hook(), sqlite3_rollback_hook()

The sqlite3_commit_hook() interface registers a callback function to be invoked whenever a transaction is committed. Any callback set by a previous call to sqlite3_commit_hook() for the same database connection is overridden. The sqlite3_rollback_hook() interface registers a callback function to be ... 

sqlite3_wal_hook()

The sqlite3_wal_hook() function is used to register a callback that is invoked each time data is committed to a database in wal mode. The callback is invoked by SQLite after the commit has taken place and the associated write-lock ... 

1. Introduction An important feature of transactional databases like SQLite is "atomic commit". Atomic commit means that either all database changes within a single transaction occur or none of them occur. With atomic commit, it is as if many different writes to ... 

 ... If a RELEASE command releases the outermost savepoint, so that the transaction stack becomes empty, then RELEASE is the same as COMMIT. The COMMIT command may be used to release all savepoints and commit the transaction even if the transaction ... 

 ... The explicit COMMIT command runs immediately, even if there are pending SELECT statements. However, if there are pending write operations, the COMMIT command will fail with an error code SQLITE_BUSY. An attempt to execute COMMIT might also result in an ... 

SQLITE_TXN_NONE, SQLITE_TXN_READ, SQLITE_TXN_WRITE

 ... The transaction state will revert to SQLITE_TXN_NONE following a ROLLBACK or COMMIT. SQLITE_TXN_WRITE The SQLITE_TXN_WRITE state means that the database is currently in a write transaction. Content has been written to the database file but has not yet committed. The ... 

sqlite3_blob_close()

 ... If the blob handle being closed was opened for read-write access, and if the database is in auto-commit mode and there are no other open read-write blob handles or active write statements, the current transaction is committed ... 

 ... SELECT statements on a different database connection Y will show no changes until the X transaction commits. But SELECT statements in X will show the changes prior to the commit. Within a single database connection X, a SELECT statement always ... 

3.5. Adding Customizations To The Code In The Private Branch  ... Once you have finished making changes, commit those changes using this command: fossil commit You will be prompted once again to enter a commit describing your changes. Then the commit will occur. The commit creates a new checkin in the ...