Conversation
Notices
-
Embed this notice
@kura it's the classic "db rot" thing. Pleroma has (from what I can tell) has these issues with its db design:
- Stores full JSON objects instead of normalizing them
- Stores every activity it receives, including Delete and Tombstone
- Doesn't really have any mechanism of auto-expiring stuff. There is an MRF that can auto expire objects globally, but I don't really like that solution.
-
Embed this notice
@kura also there's been a tendency to slap on indices whenever there's a db-related performance issue, which ends up causing the database size to bloat up and is really only a bandaid solution
-
Embed this notice
@mikoto @kura do misskey at al normalize things like recipient list
-
Embed this notice
@mikoto @kura I have tried really hard to figure out what the actual problem was with SPC but never did.
-
Embed this notice
@sun @kura it's been a while since I worked with the codebase so I might not be up to date with their current practices, but I do remember they do normalize posts and recipients years ago
-
Embed this notice
@sun @kura it does still have jsob objects in their db, but it's only for things like certain config options or their minigames