@alexandra@mk.nixnet.social i dont get what you want with these orphaned posts. why do you think they are all interesting? why should i keep a reply if the context of what it was replying to is lost?
social media is not an archive in my opinion.
technically misskey does something more complex than ON DELETE CASCADE, which is issuing delete activities for local content that will subsequently be deleted.
Conversation
Notices
-
Embed this notice
johann150@genau.qwertqwefsday.eu's status on Sunday, 21-Aug-2022 06:57:22 JST Johann150 - Hélène likes this.
-
Embed this notice
Alexandra(/Lilith?) (alexandra@mk.nixnet.social)'s status on Sunday, 21-Aug-2022 06:57:25 JST Alexandra(/Lilith?) @Johann150@genau.qwertqwefsday.eu ActivityPub has tombstones because there needs to be a stand-in for deleted objects so their references don't break or have to be cascade-deleted; rows whose children may remain interesting after the original is deleted should be able to be emptied of actual data and marked deleted without /actually deleting/ the row and breaking foreign keys, that or do something more complex than ON DELETE CASCADE for those kinds of tables.
It's the same thing, for the same reason. -
Embed this notice
johann150@genau.qwertqwefsday.eu's status on Sunday, 21-Aug-2022 06:57:26 JST Johann150 @alexandra@mk.nixnet.social because misskey isn't pleroma to store json objects in the database. database != activitypub
-
Embed this notice
Alexandra(/Lilith?) (alexandra@mk.nixnet.social)'s status on Sunday, 21-Aug-2022 06:57:29 JST Alexandra(/Lilith?) there is a reason ActivityPub has tombstone objects! WHY WOULD YOU DO THIS
-
Embed this notice
Alexandra(/Lilith?) (alexandra@mk.nixnet.social)'s status on Sunday, 21-Aug-2022 06:57:33 JST Alexandra(/Lilith?) it even deleted a quote of it so I don't even know what its URL was so I can't even hope to find it on another instance
-
Embed this notice
Alexandra(/Lilith?) (alexandra@mk.nixnet.social)'s status on Sunday, 21-Aug-2022 06:57:34 JST Alexandra(/Lilith?) aaargh misskey deleted the post I'm looking for because something somewhere on the in-reply-to chain was deleted
this is not good behavior misskey WTF are you doing??