Keep in mind that when journal_mode=off crash safety isn’t guaranteed. If the process is killed you can’t be sure the DB is in a healthy state. This is unusual for SQLite; it’s crash-safe by default.
When there’s no journal, transaction rollback behavior is undefined and likely impossible. The docs make it sound scary.
Did you see this alternative method? It should only require as much additional space as the “good” data.
Library.db size more than doubled in latest version - #175 by raba1der
Library.db size more than doubled in latest version - #188 by hlve
