It would be super helpful if there was an option to automatically hard delete notifications from the database that are older than x amount of days.
I don’t think there is a feature to be able to handle this, so just want to ask if it is safe to do manually? i.e. just simply deleting all notifications that have an older timestamp.
Something like:
DELETE FROM notifications
WHERE created_at < NOW() - INTERVAL '1 year';
Or would that likely break something?
Would appreciate any insights!
For some context: