On 26 Jun 2015, at 2:06am, Wei, Catherine <Catherine.Wei at arris.com> wrote:
> I'm using the wal mode for my sqlite database. I have a problem > that since there's no copy of database file in wal, how does it support > transaction rollback if something bad happened to the database? Can wal > promise the data integrity? Thank you. WAL mode does support ROLLBACK. The uncommitted changes are written to the journal file. Committing them moves them to the database file. You may like to read this page <https://www.sqlite.org/wal.html> then if you have more questions please post again. Simon.
