[mlvljr]

Should be noticed, the semantics of SQLite behavior in multithreaded mode is pretty cryptic, even to its long-term users (and others just silently give up, and hand-roll coarse-grained locks, I suspect):

http://sqlite.1065341.n5.nabble.com/think-I-need-better-erro...

[couchand]

The linked discussion has one of the most succinct comments about error handling I've seen.

You handle the result codes you know what to do with, and everything that remains means your program should explode immediately.

[mlvljr]

:) problem is, there's no clear understanding of how one can avoid the possibility of unwanted error codes ever returned in his program, but yes