Guys what’s the best way to delete related data? :face_with_monocle: If I delete a Post I want to remove all the Comments this post used to have. To do this when I delete a Post as a second action in a workflow I delete a list of things (all Comments that have this Post as a field called Related P…

Hi there, @bestbubbledev … I’m not necessarily going to propose a best practice here, so you can stop reading now if you’d like. :slight_smile: If I understand your post correctly, there is really only one way for you to go when you consider how you structured your data types. You have no choice but…

Yeah I guess there are only these 2 options that we mentioned above. I was thinking Bubble would have a feature called Delete All Children, Delete Related Data or something similar. Since none of us has heard of such I guess I can consider it doesn’t exist :joy:

[image] Bulk Delete in Parent-Child Tables Tips Problem As has been mentioned previously (see here , here , and here , for example), bulk operations in Bubble are not performant. Even the recommended approach of recursive back-end workflows on a list are a frequen…

In alot of my data types I include an entry called parent (if you want it vague) with the unique ID or a more specific name. Example: I have a data called calendar event. which is the main event. then another entry for repeating events of the same. Like reoccurring events. And then i have another l…

I’ll add to this discussion the idea that if you’re deleting a lot of data then a backend workflow might be the best way to handle this. Feed it a list of what to delete and let it reschedule itself recursively to work its way through the list. Meanwhile, since you’ll be deleting the main post last,…

I have used backend workflows as a Scheduled API calls to get through this. But the challenge is to know in the workflow if a delete operation is still going before triggering the recursive call to avoid overloading. I have tried timing recursive calls after few minutes etc. But how to know if the w…

Deleting related data. Best practice? 🤔

Need help Database

ralphlasry June 30, 2022, 2:42pm 4

Topic		Replies	Views
Help with delete thing logic Database	2	492	May 3, 2023
Delete all data associated with a thing, when the thing is deleted Database	4	2486	July 12, 2021
Is there a cascade deletion setting somewhere I'm missing? Database	1	940	August 17, 2021
Delete data with (deleted thing) Database	1	35	November 5, 2024
Deleting "nested" data records Database	11	3818	March 14, 2020

Deleting related data. Best practice? 🤔

Related topics