I made a few changes for Pixelfed Groups, we now separate comments and replies and boosts/shares into their own tables (GroupComment, GroupCommentReply, GroupShare, GroupPostLike, GroupCommentLike)
This reduces load on main app APIs and allows for more efficient pagination and data structures that only apply to a groups like feature (multi tenant auth)
#pixelfed #groups
dansup /
npub1ln…7737w
2024-05-27 11:08:18
Author Public Key
npub1ln54yvwdtp88j8cltkthe6kpaahdk0f60g56mfdx27tesdktev0st7737wPublished at
2024-05-27 11:08:18Event JSON
{
"id": "74f16a4f00bb9ef1ee168d566bdb18fa17e5073550ad2c2ae5c3dc8878b6b2cc",
"pubkey": "fce95231cd584e791f1f5d977ceac1ef6edb3d3a7a29ada5a657979836cbcb1f",
"created_at": 1716808098,
"kind": 1,
"tags": [
[
"t",
"pixelfed"
],
[
"t",
"groups"
],
[
"proxy",
"https://mastodon.social/users/dansup/statuses/112512735574883060",
"activitypub"
]
],
"content": "I made a few changes for Pixelfed Groups, we now separate comments and replies and boosts/shares into their own tables (GroupComment, GroupCommentReply, GroupShare, GroupPostLike, GroupCommentLike)\n\nThis reduces load on main app APIs and allows for more efficient pagination and data structures that only apply to a groups like feature (multi tenant auth)\n\n#pixelfed #groups",
"sig": "26686148d1d52fb557e2dd110aeabc7de9a15ddb8ffa7176faca55b6ba84e0fd7c8477f5aee924849f16521cc653a0572e9482ad708f96caf3b7ae8086a56aa5"
}