*** 5,10 **** --- 5,21 ---- transactions work in SQLite so that the code for implementing transactions can be more easily read and understood. + The transaction mechanism in SQLite is designed so that even + if there is an OS crash or power failure in the middle of + the commit, the partially written changes will be automatically + rolled back the next time the database is opened. It will always + appear as if either the database was completely changed or + completely unchanged regardless of when the OS crash or + power failure occurred. The restoration process is described + in more detail on the CrashRecovery wiki page. It is recommented + that you read and understand this page before attempting to + study CrashRecovery. + ---- {rightimage: commit-0.gif} *Initial State*