On 20 Dec 2018, at 11:19am, Carsten Müncheberg <carsten.muencheb...@native-instruments.de> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users