On 3 Aug 2011, at 1:49pm, LiranR wrote: > I want to use sqlite to store information every 3 seconds. I have to save a > lot of information for different time periods. Now, I am worry about a power > fault in the system. I know that when i enter data to the DB it makes a > journal so it can roll back if the power was shut down in the middle of the > process. But, is it the same thing when i want to add new columns or tables > to the DB ? can it corrupt the DB file?
The automatic recovery process will take care of new tables and columns just as well as it takes care of data entered into tables. Depending on exactly when power was lost, you might get the version before the schema change or after the schema change, but whichever you get, there should be no corruption and it should be possible to continue using that database without needing to run any sort of recovery process. It is important that nobody messes with the database file or the journal file(s) before a SQLite application opens the database after a crash. For example, moving, deleting or renaming the database or journal files may cause you to lose changes that might otherwise have been automatically recovered. A little tip for saving a chunk of information every three seconds: use one transaction to cover all changes made within those three seconds. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
