📄️ 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.