On Mon, 21 Jan 2019 at 07:21, Keith Medcalf <kmedc...@dessus.com> wrote:
> In DELETE or TRUNCATE (that is, all modes except WAL) a READ transaction > in progress blocks a WRITE transaction and a WRITE transaction in progress > blocks all other attempts to commence a transaction of any type on any > other connection. > Nitpick: an active READ transaction blocks the COMMIT stage of a WRITE transaction. An active WRITE transaction blocks all attempts to start another WRITE transaction, and once it is ready to COMMIT blocks attempts to start READ transactions. -Rowan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users