SQLite Forum

unable to open a database file in a btrfs readonly snapshot filesystem
Login
What you could do is, after a snapshot, mount it as read-write, and open the db so the state is consistent, and maybe also changing the journaling mode.

Note that this will increase the storage since it will rewrite some blocks that can no longer be shared with other snapshots.