sqlite 需要彻底移除已删除的敏感字段,跑一下 VACUUM 就够物理删除了吗?

118 天前
 drymonfidelia
2137 次点击
所在节点    数据库
2 条回复
liuidetmks
118 天前
最稳妥的方法是,你自己试一试,用 hex 编辑器看看到底有没有删除
liuidetmks
118 天前
文档说了,确实是删了

When content is deleted from an SQLite database, the content is not usually erased but rather the space used to hold the content is marked as being available for reuse. This can allow deleted content to be recovered by a hacker or by forensic analysis. Running VACUUM will clean the database of all traces of deleted content, thus preventing an adversary from recovering deleted content. Using VACUUM in this way is an alternative to setting PRAGMA secure_delete=ON.

这是一个专为移动设备优化的页面(即为了让你能够在 Google 搜索结果里秒开这个页面),如果你希望参与 V2EX 社区的讨论,你可以继续到 V2EX 上打开本讨论主题的完整版本。

https://www.v2ex.com/t/1130528

V2EX 是创意工作者们的社区,是一个分享自己正在做的有趣事物、交流想法,可以遇见新朋友甚至新机会的地方。

V2EX is a community of developers, designers and creative people.

© 2021 V2EX