RE: https://mastodon.social/@dansup/116737700778340063
When I built Loops, I created a separate Comments table and CommentReplies table, along with CommentLikes, CommentHashtags, CommentReposts, CommentReplyLikes, CommentReplyHashtags, CommentReplyReposts and a few other tables.
This is vastly […]
When I first started Pixelfed, I copied Mastodon database schema.
Every post, reply and boost/share all in the same table.
I regret that.
It's now 264.43 GB for pixelfed.social, with a wildly inefficient schema that is my fault, because I thought storing the plaintext version AND the html […]