SQLite Forum

open db in read only; explicitly store diff as WAL ?
Login
Is it possible to use sqlite in the following way:

1. we open "old.db' in READ ONLY mode

2. we do some changes, these changes are stored to "patch.wal"

At the end of the session:

3. old.db is unchanged

4. if we run "sqlite-patch old.db patch.wal", we get new.db


The goal here is that I want the old db to remain unchanged and have my changes be explicitly stored as a patch.wal .