Perhaps someone in the know can answer this: How reliable is SQLite at retaining data integrity and avoiding data corruption, compared to say, flat text files?

If you were to use SQLite within conventional means the answer is very. SQLite does provide repair tools for when such mishap occurs.