Re: [sqlite] Multithreading support approach

2010-07-02 Thread Cargnelutti, Pablo Fernando
at Oracle (so I'm a tad biased...) > -Original Message- > From: Simon Slavin [mailto:slav...@bigfraud.org] > Sent: Friday, July 02, 2010 1:46 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Multithreading support approach > > > On 2 Jul 2010

Re: [sqlite] Multithreading support approach

2010-07-02 Thread Greg Burd
I'm a tad biased...) > -Original Message- > From: Simon Slavin [mailto:slav...@bigfraud.org] > Sent: Friday, July 02, 2010 1:46 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Multithreading support approach > > > On 2 Jul 2010, at 6:

Re: [sqlite] Multithreading support approach

2010-07-02 Thread Simon Slavin
On 2 Jul 2010, at 6:14pm, Cargnelutti, Pablo Fernando wrote: > Sqlite implements table level lock? No. SQLite locks the entire database file with all tables and views in it. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Multithreading support approach

2010-07-02 Thread Cargnelutti, Pablo Fernando
Hi all, I'm a beginner user of this tool. I have to questions. What would be the better approach to multithread support for sqlite using C++ API? I'm currently try to block, using boost mutex, locks and condition variables, all calls to step method that attempts to modify the DB. Sqlite