[sqlite] What is the proper use of threads?

2006-11-02 Thread Zimmer András
If you really need to invoke SQLite from a single handler, consider opening a separate database connection for use by the signal handler. I actually do. I'll try with a separate handler and get back to you -- hopefully in a couple of days. Eventually rather than experimenting with it, I dec

Re: Re: [sqlite] What is the proper use of threads?

2006-10-31 Thread Zimmer András
A single handler is like a separate thread. OK, this way I've got it. I ain't a weaver :-) You can call SQLite from within a single handler as long as the same database connection is not being used by the main thread when the single handler is invoked. It is supposedly so but the next point

Re: [sqlite] What is the proper use of threads?

2006-10-31 Thread drh
=?ISO-8859-2?Q?Zimmer_Andr=E1s?= <[EMAIL PROTECTED]> wrote: > > Maybe my mistake but I haven't found a notice in the docs that says I > mustn't use SQLite from within a signal handler... Is there any known > workaround to this? > A single handler is like a separate thread. You can call SQLit

Re: Re: [sqlite] What is the proper use of threads?

2006-10-31 Thread Zimmer András
OK, the code I have does not do any multithreading. I do, actually, use SQLite from within a signal handler: the timer interrupt (SIGALRM handler), and also to close the DB when I catch quit signals (like SIGINT, SIGHUP, SIGTERM) -- but that's not where the problem comes from. (The rest on yo

Re: [sqlite] What is the proper use of threads?

2006-10-31 Thread drh
=?ISO-8859-2?Q?Zimmer_Andr=E1s?= <[EMAIL PROTECTED]> wrote: > > However, at random times I keep getting "library routine called out of > sequence" errors (in the feeder). This is the SQLITE_MISUSE error. You can grep for SQLITE_MISUSE in the source code to find all the cases where this error c

Re: [sqlite] What is the proper use of threads?

2006-10-31 Thread Trevor Talbot
On 10/31/06, Zimmer András <[EMAIL PROTECTED]> wrote: I have a set of programs that use SQLite3 as a buffer (and an archive at the same time). One process (the "feeder") generates some data and puts it into an SQLite3 DB. (It opens the DB on its own, stores its own sqlite3 structure, etc.) In

[sqlite] What is the proper use of threads?

2006-10-31 Thread Zimmer András
Please help me with the following situation. I have a set of programs that use SQLite3 as a buffer (and an archive at the same time). One process (the "feeder") generates some data and puts it into an SQLite3 DB. (It opens the DB on its own, stores its own sqlite3 structure, etc.) In an asy