> To prevent deleting data by mistake, we invent soft-delete pattern by having a is_deleted column. However, this brings extra complexities around foreign key, unique index enforcement. Ideally, PostgreSQL could allow users to configure an archived table. The removed data is moved to the archived table first and purged after a configured retention period. This simplifies application logic and data compliance work.
You can get the same result by changing your is_deleted boolean field to a date_deleted date field. Then use a cron to purge all the records with dates older than the configured retention period.
> Anaphylaxis after COVID-19 vaccination is rare. It has occurred at a rate of approximately 5 cases per one million vaccine doses administered.
> Myocarditis and pericarditis after COVID-19 vaccination are rare... Data from VSD and from VAERS indicate that rates of myocarditis after COVID-19 vaccination are highest among males in their late teens and early 20s, usually following the second dose of the vaccine.
> Thrombosis with thrombocytopenia syndrome (TTS) has been rarely observed after J&J/Janssen COVID-19 vaccination and has occurred in approximately 4 cases per one million doses administered.
You can get the same result by changing your is_deleted boolean field to a date_deleted date field. Then use a cron to purge all the records with dates older than the configured retention period.