[sqlite] WAL and multiple writers?

2010-11-14 Thread Lynton Grice
Hi there, I have a "queue" implemented in C using SQLIte in WAL mode. When I send messages to the queueit is fine, and I can receive messages from the queue no problem. BUT when I try run BOTH applications at the same time the sender works 100% and the receiver seems to be able to r

Re: [sqlite] WAL and multiple writers?

2010-11-15 Thread Lynton Grice
Any ideas? Thanks Lynton -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Lynton Grice Sent: 14 November 2010 05:12 PM To: 'General Discussion of SQLite Database' Subject: [sqlite] WAL and multiple writers? Impor

Re: [sqlite] WAL and multiple writers?

2010-11-15 Thread Simon Slavin
On 15 Nov 2010, at 10:13am, Lynton Grice wrote: > Any ideas on having 2 separate applications accessing the same WAL enabled > database? > > Or does the first app get an entire lock? All SQLite locking is locking of the entire database. SQLite does not lock rows, or ranges, or anything like t

Re: [sqlite] WAL and multiple writers?

2010-11-15 Thread Richard Hipp
On Mon, Nov 15, 2010 at 5:40 AM, Simon Slavin wrote: > > On 15 Nov 2010, at 10:13am, Lynton Grice wrote: > > > Any ideas on having 2 separate applications accessing the same WAL > enabled > > database? > > > > Or does the first app get an entire lock? > > All SQLite locking is locking of the enti

Re: [sqlite] WAL and multiple writers?

2010-11-15 Thread Lynton Grice
te-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: 15 November 2010 02:05 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] WAL and multiple writers? On Mon, Nov 15, 2010 at 5:40 AM, Simon Slavin wrote: > > On 15 Nov 2010, at 10:13am, Lynton Grice wrote: > > >

Re: [sqlite] WAL and multiple writers?

2010-11-16 Thread Sylvain Pointeau
Are you sure that you are not keeping a transaction in the message sender? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL and multiple writers?

2010-11-16 Thread Lynton Grice
PM To: General Discussion of SQLite Database Subject: Re: [sqlite] WAL and multiple writers? Are you sure that you are not keeping a transaction in the message sender? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/