3 ms·
I'm not sure, but from the last sentence, it seems as though they're talking about what would happen if you backed it up but didn't also back up the journal or
by electroly 4y ago
I'm not sure, but from the last sentence, it seems as though they're talking about what would happen if you backed it up but didn't also back up the journal or WAL. I think the bit about SQLite being resistant to power failures assumes that the journal or WAL are present. This is supported by the next section on "Deleting a hot journal" which says "SQLite must see the journal files in order to recover from a crash or power failure."