Transaction Basics
Learn what transactions are in SQLite and why grouping related writes protects data consistency.
BEGIN TRANSACTION
Start explicit SQLite transactions with BEGIN variants and understand when each mode is useful.
COMMIT
Finalize SQLite transactions with COMMIT so pending changes become durable and visible as completed work.
ROLLBACK
Cancel in-progress SQLite transactions with ROLLBACK so partial or invalid changes are safely discarded.
Savepoints
Use SQLite savepoints for partial rollback inside larger transactions without discarding all progress.