Re: [sqlite] Multiple *processes* accessing one database

2007-06-14 Thread Andrew Roark
From: Andrew Finkenstadt [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Thursday, June 14, 2007 12:39:46 AM Subject: Re: [sqlite] Multiple *processes* accessing one database On 6/13/07, Andrew Roark [EMAIL PROTECTED] wrote: My question: how well does sqlite handle one database file

Re: [sqlite] Multiple *processes* accessing one database

2007-06-13 Thread Andrew Finkenstadt
On 6/13/07, Andrew Roark [EMAIL PROTECTED] wrote: My question: how well does sqlite handle one database file being accessed by multiple processes? Very well, so far. You'll want to make sure you use an appropriate locking (transaction) strategy, and accomodate SQLITE_BUSY even when you