Real time backup

(1) By ouiouiphoto on 2025-01-08 09:35:23 [link] [source]

Dear all

I'm a photographer using Lightroom that use SQLite. I have no way to change any code inside Lightroom, so I cannot activate or deactivate features.

I see in my lightroom folder shm and wal files that, as far as i have understood, are sort of redo logs system

What I try to find is a tool or a way to make a real time backup of the SQLite database. Something like

make a backup when the WAL is committed
Make a real time backup of the WAL each time the WAL is changed

So if there is any issue I take the last Database backup and WAL backup and apply the WAL and i'm done

Sorry if all this seems stupid or obvious I'm new to SQLite ;) I have searched in the forum "Real Time Backup" but with no success

Kind regards

(2) By Nuno Cruces (ncruces) on 2025-01-08 10:21:48 in reply to 1 [source]

You can try to see if you can use Litestream to backup that database. No idea if it works, or if it corrupts your data beyond repair.

(4) By ouiouiphoto on 2025-01-08 12:08:25 in reply to 2 [link] [source]

Thanks. I will look at it

(3) By Richard Hipp (drh) on 2025-01-08 11:41:48 in reply to 1 [link] [source]

You can perhaps use sqlite3_rsync to make backups. This utility only makes backups when you request them, though. It does not automatically make a backup every time you make a change to the database.

(5) By ouiouiphoto on 2025-01-08 12:09:13 in reply to 3 [link] [source]

Thanks. I will look at it