Re: [sqlite] SQLite DB Structure

Firstly I'm not an SQLite expert but, now you know that, I would guess SQLite marks deleted records waiting until some clean-up process removes them and re-writes the active data. I would therefore look for some bit that is set. Try setting up a new database, adding records - taking a copy, then d

Re: [sqlite] SQLite DB Structure

Regarding: "I NEED HELP! I have SQLite3 DB (contacts from iPhone), it contains 1 record, but when I open it with NOTEPAD.EXE, I see more than 1 record. I need to repair all records from it" С уважением, I received your db (via private email) and the good news is th

Re: [sqlite] SQLite DB Structure

Sqlite doesn't delete data from the database the way you expect. It marks space as deleted and overwrites it later as needed. The "other records" are probably just deleted blocks. Unless the VACUUM is deleting the 1 record, it hasn't reduced the file size too much. If the database is ACTUALLY