Comment

I don’t follow the development super closely so I don’t know if those issues were resolved or not. I just remember a lot of discussion on it when I was first on Lemmy on a different instance.

not that i’m aware of, and fixing a database schema once it’s already in place tends to be a clusterfuck so i’m very skeptical it will get better any time soon

source

Sort:hotnew top

skullgiver@popplesburger.hilciferous.nl ⁨8⁩ ⁨months⁩ ago
[deleted]
source
- Penguincoder@beehaw.org ⁨8⁩ ⁨months⁩ ago
  That query by itself in a vacuum is fine. Combined with many other triggers on the DB, and then federating that out before actually deleting from the local DB… well that is what creates all sorts of headaches.
  
  source
  - skullgiver@popplesburger.hilciferous.nl ⁨8⁩ ⁨months⁩ ago
    [deleted]
    source
    Lionir@beehaw.org ⁨8⁩ ⁨months⁩ ago
    
    Images aren’t federated through ActivityPub so I don’t really see how deleting media is supposed to work.
    
    Yes, they are. Every instance downloads everyone’s images for a “cached” version that is currently never used. This is what makes this problem especially insidious and straight up dangerous in cases like CSAM.
    
    source