On 03/30/2017 12:52 AM, Olivier Mascia wrote:
Le 29 mars 2017 à 19:40, Simon Slavin <slav...@bigfraud.org> a écrit :
Since I’m using WAL, will this db handle keep a snapshot of the time before the
blob’s row was deleted, allowing the blob handle to keep working?
As Simon said wisely, a word of the developers would clarify this better.
Yet, since you're using WAL it should work. Else the implementation of the
blob API would not obey the transactional/isolation rules and I suppose it
would qualify as a (horrible) bug.
Transactions are isolated in SQLite, and in WAL mode readers do not
block writers. So it will work.
Separate database connections for the reader and writer of course.
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
