SQLite Forum

Statements outside of explicit transactions in SQLite
This "auto-release" process and the flag are called "auto-commit".  What it means is that lock levels that are no longer required are "automatically released and associated data is committed to the database in the case of a WRITE lock" when a statement ends.  BEGIN and COMMIT merely disable and enable this flag.  The process of lock acquisition by a connection and the statements executing on it is unchanged.