well if a complete database deletion of the posts is not an option, is there a simple solution to overwrite the post and its revisions?
I understood from other posts in this forum that destroying just the post in the table posts might result in database inconsistencies due to the links to other tables. So that is not an option.
But would it be possible to overwrite the “deleted” post in the table posts and its revisions in the table post_revisions with a short text like “permanently deleted data” by a background job for all “deleted” posts older then for example 30 days based on the deleted_at timestamp?
Are there more tables to consider like quoted_posts?
With such a solution at least the original data would be “deleted” without the possibility by any admin to view and to restore old “not really deleted” data. No user could then complain that his or her data has not been deleted and even for the authorities the data would be “deleted”.
So if someone could tell me which tables should be taken into consideration I would ask the programmer I know, who has already programmed plugins for discourse, if he could program such a plugin to overwrite the “deleted” post data with “permanently deleted data” text.