SQLite Forum

classic save possibility
Login
RichardDamond thanks for your answer. So if I understood the only problematic case is rolling back transaction written in WAL file. Your description is due to deleting WAL file directly on disk. Yes it could be dangerous to do that. I hope that option SQLITE_FCNTL_PERSIST_WAL with turning off autosevepoint prohibit transvering data from WAL to orginal file after closing all connections and therefore I sill stay only in documented behaviour. Unfortunately, I cannot find equivalent of this option in PRAGAs and haven't yet tested it because I used System.Data.Sqlite provider. Meybe someone aready used the flag SQLITE_FCNTL_PERSIST_WAL and already know its behaviour in described case.