On 20 Dec 2018, at 11:19am, Carsten Müncheberg <[email protected]> wrote:
> I am experimenting with EXCLUSIVE transactions today, and was confused that > after one connection began an EXCLUSIVE transaction, another one could still > execute a SELECT statement Your database is probably in WAL mode: <https://www.sqlite.org/wal.html> This is the newer, arguably better, mode which allows the programmer to do exactly what you describe. A database only locks up if more than one connection tries to write at the same time. Find out which mode it's in using this PRAGMA: <https://www.sqlite.org/pragma.html#pragma_journal_mode> Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
