Thanks @Tim Streater but I'm generally happy with the graphical sqlitebrowser. The warning message is confusing but there are no other problems using it. Or did you mean to say that there is some specific functionality of the sqlite3 terminal program that may be helpful for me? Like a "sanity check" for the database that provides extra information that could be used to validate my db?