World: r3wp

I haven't yet seen a corrupt sqlite db so far. I am having like separate 
1000 databases "running". On what OS are you seeing this?

I"d bet it's being used on a desktop ....

xp and vista. I just had the issue on vista. I do not remember if 
it has occured on my xp machine.

Why Graham? desktop as opposed to server?

What version of SQLite are you using?  What is the pragma setting 
for synchronous? 2 is the safest. Are any processes that use the 
database still running when you have the problem trying to delete 
the database files?

Not sure on the version? (you are talking about the dll? or .r?)
Pragma setting? Not familiar with this.


Yes, my script is running still. That's my problem. I wanted to over 
write without having to close script down...I worked that out with 
a restart...good enough for now.

.r = 1.0.4

i see its up to 1.0.6... I'll try out the newer version...thanks

I'm regularly having corruption in my Firefox 3.5 bookmarks, which 
are stored in SQLite

I'm referring to the SQLite version. The current is 3.7.5. You can 
check the synchronous setting by executing the following query -- 
pragma synchronous. It will return a 0 (off), 1(normal) or 2 (full). 
See http://sqlite.org/pragma.html#pragma_synchronous.


I've had database corruption before because I didn't backup the files 
correctly. It's best to use the backup API and not just copy the 
files.

Is there just one process accessing the files? I also use the WAL 
journal mode for better concurrency. Much less chance of getting 
SQLIte file locks when multiple processes are reading/writing the 
database. See http://sqlite.org/pragma.html#pragma_journal_mode.

desktop because people run all sorts of junk on their PCs causing 
corruption!