Hi!
# spicedbc
Conviley
09/29/2025, 12:05 PMHi!
I read in a previous thread that there is no notion/concept of cascading deletes of relationships, is this still the case and if so what is the best way to deal with this?
Thanks!
y
yetitwo
09/29/2025, 1:12 PMthat's still the case. what's the use case you're dealing with?
c
Conviley
09/29/2025, 2:19 PMI just have a bunch of nested object type definitions and want the nested relationships to be deleted when i delete the root of the nested definitions.
consider a nesting structure like
- X
- Y
- Z
If i delete X i would want the X to Y and the Z to Y relationship to be deleted as well.
Right now i just went ahead and created a util called
deleteXRelationsCascadingy
yetitwo
09/29/2025, 2:54 PMhmm
yetitwo
09/29/2025, 2:54 PMthere is a syntax change that we were considering that would be somewhat related
yetitwo
09/29/2025, 2:54 PMlemme see if i can dig up any documentation of that
yetitwo
09/29/2025, 5:23 PMah, it's an internal doc, but we're talking about a way to extend the schema syntax to mark that one definition is a "parent" of another, which would indicate that the same object can't have two distinct subjects (among other concerns)
yetitwo
09/29/2025, 5:24 PMit'd help ensure that (say) a file couldn't be included in multiple folders, or that a team couldn't be attached to multiple organizations, and the associated authz concerns that would come with that
yetitwo
09/29/2025, 5:24 PMand we talked about how it could also enable this sort of cascading delete behavior
yetitwo
09/29/2025, 5:25 PMwe're tracking the issue on the public repo here https://github.com/authzed/spicedb/issues/204
if you want to provide some input
yetitwo
09/29/2025, 5:25 PMthough i will say that one of the weirdnesses here is that SpiceDB doesn't hold nodes, only edges, so the question of whether a resource exists is kind of a weird one
2 Views