Small. Fast. Reliable.
Choose any three.
*** 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*