TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Recovering deleted records from an SQLite database

38 pointsby 2510c39011c5about 10 years ago

5 comments

mox1about 10 years ago
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;
评论 #9328197 未加载
mayoffabout 10 years ago
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>
killnineabout 10 years ago
<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>
gtrubetskoyabout 10 years ago
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>
nczaabout 10 years ago
Does a simple VACUUM prevent this?
评论 #9328599 未加载