SQLite Frequently Asked Questions
(faq.html)
... For details,
read about atomic commit in SQLite..
By default, each INSERT statement is its own transaction. But if you
surround multiple INSERT statements with BEGIN...COMMIT then all the
inserts are grouped into a single transaction. The time needed ...
|
TH3
(th3.html)
4. Test Coverage
... The SQLite developers
are committed to maintaining 100% branch coverage and MC/DC for all
future releases of SQLite.
The cov1 test set used to obtain 100% branch test coverage are only a
subset of the tests currently implemented using ...
|
SQLite As An Application File Format
(appfileformat.html)
... SQLite is transactional, meaning that multiple changes can be grouped
together such that either all or none of them occur, and so that the
changes can be rolled back if a problem is found prior to commit.
This allows an ...
|
Syntax Diagrams For SQLite
(syntaxdiagrams.html)
... See also: lang_comment.html
commit-stmt:
Used by: sql-stmt
See also: lang_transaction.html
common-table-expression:
Used by: compound-select-stmt delete-stmt delete-stmt-limited  ...
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... when the
transaction is first started, during any write or update operations, or
when the transaction commits.
To avoid encountering SQLITE_BUSY errors in the middle of a transaction,
the application can use BEGIN IMMEDIATE instead of just BEGIN to
start ...
|
The Virtual Database Engine of SQLite
(vdbe.html)
... 11 Commit 0 0
The instruction Commit causes all
modifications to the database that have been made since the last
Transaction to ...
|
35% Faster Than The Filesystem
(fasterthanfs.html)
2.2. Write Performance Measurements
... The timer for the database writes is stopped after the transaction
commits, but before a checkpoint is run.
Note that the SQLite writes, unlike the direct-to-disk writes,
are transactional and power-safe, though because the synchronous
setting is ...
|
SQLite Session Module C/C++ Interface
(session.html)
... The
SAVEPOINT is committed if the changeset or patchset is successfully
applied, or rolled back if an error occurs. Specifying this flag
causes the sessions module to omit this savepoint. In this case, if the
caller has an open transaction ...
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.16. The xSync Method
int (*xSync)(sqlite3_vtab *pVTab);
This method signals the start of a two-phase commit on a virtual
table.
This is method is optional. The xSync pointer of sqlite3_module
may be NULL.
This method is only invoked after call to the ...
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... AutoCommit
Set the database auto-commit flag to P1 (1 or 0). If P2 is true, roll
back any currently active btree transactions. If there are any active
VMs (apart from this one), then a ROLLBACK fails. A COMMIT fails ...
|
Page generated by FTS5 in about 61.85 ms.