Was wondering how secure sqlite is. I am well aware of the passphrase that needs to be passed (either by using ChangePassword() or SetPassword(). Assuming the database is encrypted, and the application is writing to the database or reading from the database. Suddenly the application stops working, what happens to the database? When it reads from database does it decrypt it? Will it remain decrypted if the application hangs? I am using System.Data.Sqlite dll for visual studio 2010.
Thanks.