Open alnr opened 1 year ago
Hello contributors!
I am marking this issue as stale as it has not received any engagement from the community or maintainers for a year. That does not imply that the issue has no merit! If you feel strongly about this issue
Throughout its lifetime, Ory has received over 10.000 issues and PRs. To sustain that growth, we need to prioritize and focus on issues that are important to the community. A good indication of importance, and thus priority, is activity on a topic.
Unfortunately, burnout has become a topic of concern amongst open-source projects.
It can lead to severe personal and health issues as well as opening catastrophic attack vectors.
The motivation for this automation is to help prioritize issues in the backlog and not ignore, reject, or belittle anyone.
If this issue was marked as stale erroneously you can exempt it by adding the backlog
label, assigning someone, or setting a milestone for it.
Thank you for your understanding and to anyone who participated in the conversation! And as written above, please do participate in the conversation if this topic is important to you!
Thank you 🙏✌️
Preflight checklist
Ory Network Project
No response
Describe your problem
Deleting identities is slow because of cascading deletes through foreign keys.
Describe your ideal solution
Use the identity's
status
field to store a new state:deleted
.Use database triggers to make sure the
updated_at
column is always updated (bypassing pop).Implement async hard deletes. For CRDB, we can use row-level TTLs of
status
combined with theupdated_at
timestamp.Workarounds or alternatives
not sure
Version
master
Additional Context
No response