To be fair, after further research, most databases actually do not delete data properly. If you wanna get rid of sensible data, in Postgres and Sqlite you have to run an extra "Vacuum" command, in Mysql you have to "Purge".
Feels like the only scalable way for guaranteed deletion is to either use no db at all or to go multi-tenant and create dbs per entity. E.g. in my app I wanna properly delete chat rooms after some expiration time, so maybe the way to solve this is to create one db per chat room 🤔.
nostr:nevent1qqs0fta3qla77g0jgy9mvlhpfm22zph9nupct5gcut32dz9y5dsjdscpzamhxue69uhhyetvv9ujumn0wd68ytnzv9hxgtczyr90pdmvtm7vyjvt6aaty0y68axxfvfl0x5u6a3necy064t0339yxqcyqqqqqqg0t0plj