Soft deletion probably isn't worth it

Re:Soft deletion probably isn't worth it by dcow on Wednesday July 20, 2022 @04:09AM (#32162857)

Is there literature on this topic? I'd like to learn at what scale per-user/tenant keys becomes untenable and the characteristics of systems that exhibit pathologically poor performance due to such a design.

Naively, it sounds like individual entity keys does solve the problem of deletion, but that your argument is that the tradeoffs aren't generally worth it?

[ Parent | on HN ]

Re:Soft deletion probably isn't worth it by nicoburns on Wednesday July 20, 2022 @04:31AM (#32162976)

I’d imagine a pretty small scale. Imagine an endpoint that lists user accounts. You would have to individually decrypt each row! and you would never be able to do database joins of data in these tables because you it wouldn’t be possible to decrypt it until it had already left the database.

[ Parent | on HN ]