Hacker News Reader

Nice article, but unless the database is "VACUUM"ed after the "DELETE" the rows are still readable in the database file. This kinda defeats the purpose of the whole article b/c the user didn't gain any more privacy than he had before the deletion :)

View on HN

can you share the command to do this?

sqlite3 ~/Library/Preferences/com.apple.LaunchServices.QuarantineEventsV* 'vacuum'

Tried this, but I still see all of the files in the list.

The idea is that first you run the DELETE statement from TFA, which marks the records as deleted and "hides" them but doesn't completely "forget" them, then you run the VACUUM one, which should basically erase any trace of those records ever existing in the sqlite db.

Reply on news.ycombinator.com