I am using SQLite 3.6.x and higher for two apps for the iPhone/iPad. I do not use the built-in SQLite library because I need Rtree and FTS support. Therefore, I compile it by myself with the following preprocessor directives:
SQLITE_THREADSAFE=1 SQLITE_ENABLE_RTREE=1 SQLITE_ENABLE_FTS3=1 SQLITE_ENABLE_FTS3_PARENTHESIS=1 A few user have reported that when the iPhone/iPad runs out of batteries the SQLite3 database may become corrupted. I have received one database back and it is indeed defect and unrecoverable. Does anybody have an idea what is going wrong? I tried to reproduce the error by myself but I did not have any luck so far. For information: only the main thread is writing to the database. There is no other thread having access to the database and there is also no read operation from the main thread. The write operation is not within an explicit transaction. Any ideas are appreciated! Regards, Hartwig _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
