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.