Re: [sqlite] Occasional Database is Locked Error

2007-12-12 Thread Joanne Pham
sqlite-users@sqlite.org Sent: Wednesday, December 12, 2007 11:59:04 AM Subject: Re: [sqlite] Occasional Database is Locked Error Mark Riehl wrote: > Am I just getting [un]lucky and issuing selects at the same time I'm > writing from the other process? Yes. > I'm planning on using

Re: [sqlite] Occasional Database is Locked Error

2007-12-12 Thread Richard Klein
Mark Riehl wrote: Am I just getting [un]lucky and issuing selects at the same time I'm writing from the other process? Yes. I'm planning on using a web-based app to periodically poll the database (to provide summary information) while the C++ app performs the inserts. What is the best way

Re: [sqlite] Occasional Database is Locked Error

2007-12-12 Thread Dennis Cote
John Stanton wrote: Your application needs to handle the synchronization logic since there is no DB server to do it for you. When you get a busy check you can pause for a short time and relaunch the query. Mark Riehl wrote: I'm running SQLite 3.4.1 under Linux. I have a C++ application

Re: [sqlite] Occasional Database is Locked Error

2007-12-12 Thread John Stanton
Your application needs to handle the synchronization logic since there is no DB server to do it for you. When you get a busy check you can pause for a short time and relaunch the query. Mark Riehl wrote: I'm running SQLite 3.4.1 under Linux. I have a C++ application that inserts records

[sqlite] Occasional Database is Locked Error

2007-12-12 Thread Mark Riehl
I'm running SQLite 3.4.1 under Linux. I have a C++ application that inserts records into the database. During testing, I lauch the C++ app and I start sqlite3 from a console and open the database that is being written to by the C++ application. I perform selects using sqlite3 (no inserts) to