I've long assumed that when using the online backup API on a SQLite
database, other processes will not be able to write to the source database
for the duration of the sqlite3_backup_step call. However under some
testing I've been performing, I've found that this doesn't appear to be the
case. Instead writes are prevented for a very small subset of that time,
if at all.
Is that the expected behaviour, or is there a flaw in my testing
somewhere? What defines the subset of time if it is correct?
I'm testing a WAL database if that affects it.
sqlite-users mailing list