If you actually read this article it should give you even more assurance that SQLite is very robust and trustworthy. It mostly deals with all the edge cases where something other than the quality and reliability of the SQLite code base can bite you.