On 3 Feb 2014, at 7:51pm, Baruch Burstein <bmburst...@gmail.com> wrote:
> Thank you for the explanations. If I wrap a few SELECTs in a transaction, > does this guarantee that the data I read will be consistent across all of > the SELECTs? Yes. Unless the same connection that is doing all these SELECTs makes some changes itself. I believe that the first SELECT will lock the database, but I'm not sure about this, or about how it works with the different types of journal. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
