Hopefully, this one is more informative, than another one from couple years ago, which was disappointingly untechnical (and SQLITE is not a trivial piece of software, despite what one may think, just try to understand the semantics of error handling when it comes to rollbacks, for example).