rumcais wrote: > I've make some experiments around accessing the SQLite database fom concurent > processes at the same time and I find it work good when I'm using > transactions every time I touch the database. When I don't, it corrupt the > database file sometimes. >
The only ways to corrupt an SQLite database file should be these:
(1) Use a stray pointer to corrupt the internal memory of the SQLite library while it is running.
(2) Do a manual open() of the database file and write garbage into it.
It should be impossible to corrupt the database using just the SQLite API. If you think you are seeing database corruption, that could be a sign of a bug which you should report.
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]