Re: [sqlite] Corrupt Database Problems

On 5/18/09, Kevin Gale wrote: > According to the PRAGMA command documentation the database might become > corrupted if the o/s crashes or the computer loses power before the data has > been written to the disk surface. From the information we have from the > customer

Re: [sqlite] Corrupt Database Problems

to a previous version. Regards, Kev. From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] On Behalf Of Jim Wilcoxson [pri...@gmail.com] Sent: 15 May 2009 18:08 To: General Discussion of SQLite Database Subject: Re: [sqlite] Corrupt Database

Re: [sqlite] Corrupt Database Problems

On 16/05/2009 3:08 AM, Jim Wilcoxson wrote: > I think you have answered your own question. If you use > synchronous=off, you are saying "I don't care much about this > database." When you "save" documents, you are merely putting them in > a computer's cache (memory) and then confirming to the

Re: [sqlite] Corrupt Database Problems

I think you have answered your own question. If you use synchronous=off, you are saying "I don't care much about this database." When you "save" documents, you are merely putting them in a computer's cache (memory) and then confirming to the user that they are on the hard drive, when they aren't

[sqlite] Corrupt Database Problems

Hi. We are using SQLite 3.3.6 via Realbasic & the REALSQLDatabase plug-in. Over the past few weeks we have had calls from different customers stating that the documents that they have been saving from our application (a sqlite database) are now empty. I have received the database from the