Recovering deleted records from an SQLite database

Incase anyone is wondering why this is useful, lots and lots of android and iOS applications (including system apps , OS functionality) use SQLite for storing all kinds of things.<p>Mobile devices forensics quickly turns into &quot;What data is in this SQLite table?&quot;

Consider using PRAGMA SECURE_DELETE = 1 if you want to make these forensics more difficult&#x2F;impossible.<p><a href="https:&#x2F;&#x2F;www.sqlite.org&#x2F;pragma.html#pragma_secure_delete" rel="nofollow">https:&#x2F;&#x2F;www.sqlite.org&#x2F;pragma.html#pragma_secure_delete</a>

<a href="http:&#x2F;&#x2F;www.cyanline.com&#x2F;blog.php?entryT=Extracting%20Deleted%20Messages%20From%20An%20iPhone" rel="nofollow">http:&#x2F;&#x2F;www.cyanline.com&#x2F;blog.php?entryT=Extracting%20Deleted...</a>

The nice thing about SQLite which makes this kind of thing possible is that the file format is very well documented, for example: <a href="https:&#x2F;&#x2F;www.sqlite.org&#x2F;fileformat.html" rel="nofollow">https:&#x2F;&#x2F;www.sqlite.org&#x2F;fileformat.html</a> or <a href="https:&#x2F;&#x2F;github.com&#x2F;mackyle&#x2F;sqlite&#x2F;blob&#x2F;master&#x2F;src&#x2F;pager.c#L26" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;mackyle&#x2F;sqlite&#x2F;blob&#x2F;master&#x2F;src&#x2F;pager.c#L2...</a>

Does a simple VACUUM prevent this?