On Mon, Dec 21, 2009 at 10:59:10AM +0000, Othman Guessous scratched on the wall: > Hello, > > I have a problem with a sqlitedb file. So there is some data in this > sqlitedb file (on notepad or pspad we can found easily these data) but they > don't appear on a sqlite application browser (i use SQLite Database Browser > 2.0 b1)...it seems that these data are ignored.
If data is deleted from the database, the database pages inside the file are simply marked "free." Normally they are not over-written, nor are they removed from the file (unless you run VACUUM). In short, yes... they are ignored. If the data you're looking at was in a table that was dropped or had rows deleted from it, then the data is no longer part of the proper database structure. You may still see fragments of the data if you do a raw file dump, however. Make a copy of the database file. Run the VACUUM command on the copy. If the data is gone from the raw file dump, it has already been deleted from the database structure. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
