Re: [sqlite] SQLite3 and threading

2011-02-04 Thread Pavel Ivanov
> I cite from http://sqlite.org/faq.html#q6: > > "The restriction on moving database connections across threads was > relaxed somewhat in version 3.3.1. With that and subsequent versions, it > is safe to move a connection handle across threads as long as the > connection is not holding any fcntl()

Re: [sqlite] SQLite3 and threading

2011-02-03 Thread Ulrich Telle
Am 03.02.2011 15:53, schrieb Pavel Ivanov: > It seems that this explanation as well as all other statements in the > thread you linked are coming from the wrong assumption that SQLite's > handles cannot be used from any thread other than the one created that > handle. The explanation I gave to Ste

Re: [sqlite] SQLite3 and threading

2011-02-03 Thread Stefano Mtangoo
Thanks Pavel, I consider my case closed though any thought is welcomed! On 02/03/2011 05:53 PM, Pavel Ivanov wrote: > It seems that this explanation as well as all other statements in the > thread you linked are coming from the wrong assumption that SQLite's > handles cannot be used from any threa

Re: [sqlite] SQLite3 and threading

2011-02-03 Thread Pavel Ivanov
It seems that this explanation as well as all other statements in the thread you linked are coming from the wrong assumption that SQLite's handles cannot be used from any thread other than the one created that handle. Although this was true in some earlier versions of SQLite it's not true in the cu

Re: [sqlite] SQLite3 and threading

2011-02-03 Thread Stefano Mtangoo
From Urlich's explanation (I respect him as he is in the 'game of programming ' many years ahead me) is this, I quote: -- This decreases the chance of failure but doesn't eliminate it, since still SQLite handles are passed around. As soon as the database thread a

Re: [sqlite] SQLite3 and threading

2011-02-03 Thread Pavel Ivanov
What problems did you meet when you tried to do what you want? Pavel On Thu, Feb 3, 2011 at 4:39 AM, Stefano Mtangoo wrote: > Hi, > I use SQLite3 with wxSQLite3 wrapper and all is fine until I wanted to > shift the DB thing into the secondary thread. > What I want to do is send string containin

[sqlite] SQLite3 and threading

2011-02-03 Thread Stefano Mtangoo
Hi, I use SQLite3 with wxSQLite3 wrapper and all is fine until I wanted to shift the DB thing into the secondary thread. What I want to do is send string containing query to secondary thread and the secondary thread is supposed to query db and post back the resultset. Urlich had doubts about the