On 24/11/62 00:05, Jens Alfke wrote:
On Nov 23, 2019, at 7:17 AM, Dan Kennedy <danielk1...@gmail.com> wrote:
This should only happen if you are using shared-cache mode. Don't use
shared-cache mode.
Shared-cache mode also breaks Isolation between connections — during a
transaction, other connections will see the writer’s intermediate state. (IIRC.
It’s been a few years.)
Only if you explicitly set "PRAGMA read_uncommitted" I think.
Dan.
In my experience, it’s only useful if all connections are read-only, or if
you’re willing to use your own mutexes to keep writers from screwing up readers
(in which case you might as well just share a single connection, right?)
—Jens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users