4 ms·
It is probably worth noting that while this may result in a database file that has no deleted content the raw storage medium very likely still has some of this
by kevincox 2y ago
It is probably worth noting that while this may result in a database file that has no deleted content the raw storage medium very likely still has some of this data if you know where to look.
It seems like this would fullfill a very niche use case. In most cases you would probably be better of do do a `.dump`, `.backup` or `VACUUM INTO` to produce a "clean" DB just before sharing it.
- PreInternet01 2y agoYeah, it seems a bit hard to figure out the use case for this one. If you're sharing data with an untrusted third party, you'd use a verifiably-clean export format. And if you're concerned about local storage, the remains of your dirty database pages after the FTL and/or other sector-remapping firmware is done with it are still a concern. But anyway, apparently someone felt they needed this badly enough to pay for it, so YOLO...