[sqlite] Multi-thread support

Hi all, Can anybody tell me how to handle concurrent write using sqlite3 database ? Does sqlite3 use table level locking ? Regards, Roushan

[sqlite] Multi-threading.

Hello all, Can we use single sqlite_open handle(global) across threads( if all database operations are serialized by using semaphore) ? Please help. Regards, Roushan

Re: [sqlite] Multi-threading.

serially and it worked. Thanking you again, Roushan On Fri, 2005-07-15 at 17:57, D. Richard Hipp wrote: > On Fri, 2005-07-15 at 16:41 +0530, Roushan Ali wrote: > > Hello all, > > Can we use single sqlite_open handle(global) across threads( > > if all database oper

Re: [sqlite] Multi-threading.

Hi, Thanks for your response. I don't have any idea how multiple connection objects work. Can you please tell us something about that. Thanks, Roushan On Fri, 2005-07-15 at 20:15, Dennis Jenkins wrote: > Roushan Ali wrote: > > >Thanks Richard for your reply. > > > >A

[sqlite] Libray routine called out of sequence

Hi all, I got an error message "library routine called out of sequence" during sqlite_step . Can anybody tell me what this error message does mean ? Regards, Roushan

[sqlite] Sqlite misuse

Hi all, Can anyone tell me exactly in which situation sqlite returns the following error message , "library routine called out of sequence" Regards, Roushan

[sqlite] commit transaction

Hi All, we are working on a multi-threaded application in linux 2.4.20 using sqlite(2.8.13) database. we use single database handle for all the threads to access the database and the handle is protected with mutex. The handle is kept open for the lifetime of the application. we have kept