Re: [sqlite] Multiple Writers and Database is Locked Problems

2009-07-20 Thread Edzard Pasma
To: kennethinbox-sql...@yahoo.com; General Discussion of SQLite Database Cc: sqlite-users@sqlite.org Subject: Re: [sqlite] Multiple Writers and Database is Locked Problems I'd also make sure that all read-cursors are finished before starting a transaction. Or, take the exclusive lock already before

Re: [sqlite] Multiple Writers and Database is Locked Problems

2009-07-19 Thread Edzard Pasma
Database sqlite-users@sqlite.org Subject: Re: [sqlite] Multiple Writers and Database is Locked Problems Date: Sat, 18 Jul 2009 12:29:33 -0700 (PDT) I like to start each of my transactions with a Begin Immediate that way the database file is locked at that point. And its relatively simple to test

Re: [sqlite] Multiple Writers and Database is Locked Problems

2009-07-18 Thread Ken
...@opteqint.net Subject: [sqlite] Multiple Writers and Database is Locked Problems To: sqlite-users@sqlite.org Date: Friday, July 17, 2009, 6:38 AM Hi. Im hoping someone might be able to help me with the problems im having, or suggest a better method of doing what im trying to achieve

[sqlite] Multiple Writers and Database is Locked Problems

2009-07-17 Thread Cole
Hi. Im hoping someone might be able to help me with the problems im having, or suggest a better method of doing what im trying to achieve. Currently im using sqlite3 3.6.10. I don't mind updating or downgrading it if needed. I have a program that I run multiple instances of. When they start,