> given that I am dealing with an application crash An application crash on a working file-system should not cause you to lose any data already committed to the db, regardless of the "PRAGMA synchronous" setting. Are you sure you're losing data written before the most recent "COMMIT" on the same db handle? In this context "working file-system" means pretty much everything except perhaps some versions of some network file-systems.