[sqlite] Multiple threads reading different data

2014-11-11 Thread Daniel Polski
I'm accessing a database from multiple threads, where each thread has a separate database connection. When some specific event happens, I want the threads to evaluate the situation and act accordingly. I have setup a temporary trigger which fires at the event and which in turn calls a

Re: [sqlite] Multiple threads reading different data

2014-11-11 Thread Clemens Ladisch
Daniel Polski wrote: this maybe has to do with me using WAL mode, and that the update is not yet processed enough for the other threads to fetch the new data (so they still selects the old data), even though the trigger is set to fire after update. Is this maybe the case? Yes; other

Re: [sqlite] Multiple threads reading different data

2014-11-11 Thread Hick Gunter
. -Ursprüngliche Nachricht- Von: Daniel Polski [mailto:dan...@agelektronik.se] Gesendet: Dienstag, 11. November 2014 12:59 An: General Discussion of SQLite Database Betreff: [sqlite] Multiple threads reading different data I'm accessing a database from multiple threads, where each thread