On 11 Apr 2017, at 2:16pm, Reid Thompson <reid.thomp...@ateb.com> wrote:
> I/and the original implementer, am/were more familiar with PostgreSQL's > MVCC. So I think the issue was the assumption that the query being > stepped through would only ever see the rows as they were at the start > of the query and would walk through them from first to last. > > Would > PRAGMA journal_mode=WAL; > provide that? Your situation would be that you have a single connection to the database, and it’s being used by two statements at the same time ? You’re beyond what I can promise. I need someone else to answer that. The answer might be different if the SELECT was using a different connection to the one which was modifying the table. Again, I hope someone else can help. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
