[sqlite] Multithreaded SQLite

2016-03-10 Thread Kees Nuyt
On Wed, 9 Mar 2016 17:18:15 -0500, Philippe Riand wrote: > Yes, I?m using prepare(), step and finalize(). The 2 threads should > actually have no interaction between them, but isolated. > I mean the 2 threads should be able to do very different > things (read data, write data?), within separated

[sqlite] Multithreaded SQLite

2016-03-09 Thread Simon Slavin
On 9 Mar 2016, at 10:15pm, Philippe Riand wrote: > I tries busy_timeout but that was unsuccessful. What did you set the time to ? Try 5 minutes. You should definitely remove all the unusual PRAGMAs apart from that one and see if that makes the problem go away. Simon.

[sqlite] Multithreaded SQLite

2016-03-09 Thread Philippe Riand
Yes, I?m using prepare(), step and finalize(). The 2 threads should actually have no interaction between them, but isolated. I mean the 2 threads should be able to do very different things (read data, write data?), within separated transactions.

[sqlite] Multithreaded SQLite

2016-03-09 Thread Philippe Riand
On the OS standpoint, we are using multiple ones: Android, iOS and desktop (Windows, OSX and Linux). So we need to figure a solution that works with all these OSes. when I used the WAL mode, I got a schema locked, while in DELETE mode i got database locked. >>>If WAL is supported, then you can

[sqlite] Multithreaded SQLite

2016-03-09 Thread Simon Slavin
On 9 Mar 2016, at 5:00am, Philippe Riand wrote: > 1- Is it safe to share a single connection between all these threads > (assuming serialized mode)? In addition to Keith's excellent reply ... Are you using _prepare(), _step(), _finalize() ? If so then make sure you understand the

[sqlite] Multithreaded SQLite

2016-03-09 Thread Philippe Riand
I?m a bit lost with the multi-threaded concurrent access errors I?m getting, and looking for an advise on the best solution. Basically, I have a desktop/mobile app (single user) that embeds a tiny local http server. The UI is done through an embedded browser, calling the server for pages and

[sqlite] Multithreaded SQLite

2016-03-08 Thread Keith Medcalf
On Tuesday, 8 March, 2016 22:00 +07:00, Philippe Riand said: > I?m a bit lost with the multi-threaded concurrent access errors I?m > getting, and looking for an advise on the best solution. > Basically, I have a desktop/mobile app (single user) that embeds a tiny > local http server. The UI is

Re: [sqlite] Multithreaded SQLite

2008-09-10 Thread Igor Tandetnik
"Gene Allen" <[EMAIL PROTECTED]> wrote in message news:!&[EMAIL PROTECTED] > I'm using SQLite v. 3.5 in my multithreaded application. > > I have 2 threads both writing to the same database, different tables > but same database. All is good until one of the threads goes under > HEAVY load, then