> When you do not use explicit transactions, SQLite will automatically create > implicit transactions.
But the documentation only says that an implicit transaction is created for data-changing queries like INSERT: https://www.sqlite.org/lang_transaction.html > Any command that changes the database (basically, any SQL command other than > SELECT) will automatically start a transaction if one is not already in effect it more or less explicitly says that a SELECT does not need a transaction. So it should be documented that a SELECT is also an implicit transaction or that a SELECT statement is promoted to a READ transaction when a concurrent INSERT statement happens. mit freundlichen Grüßen, Kira Backes _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users