Thanks!! You helped me a lot!!
Simon Slavin-3 wrote: > > > 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 > > -- View this message in context: http://old.nabble.com/New-columns-or-tables-corruption-tp32185981p32187033.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
