PieFed Meta

1026 readers

14 users here now

Discuss PieFed project direction, provide feedback, ask questions, suggest improvements, and engage in conversations related to the platform organization, policies, features, and community dynamics.

Wiki

founded 1 year ago

MODERATORS

rimu@piefed.social

What Features Make PieFed Better/Worse (piefed.ca)

submitted 3 days ago by Paige@piefed.ca to c/piefed_meta@piefed.social

34 comments fedilink hide all child comments

What features made you choose PieFed over Mbin/Lemmy?
What features do they have that you’d like to see in PieFed?

you are viewing a single comment's thread
view the rest of the comments

[–] wjs018@piefed.social 2 points 3 days ago (1 children)

The scale of LW is impressive as always.

Is the post_read table where info on what a user has or has not read is stored? I am wondering now if a huge db like that is the cost of implementing features like marking unread comments or posts.

...not that I have a great idea of how to do that since I don't know js at all, but db size is something to keep in mind when the intention is to have federated instances, each with their own infrastructure.

[–] MrKaplan@lemmy.world 2 points 3 days ago* (last edited 3 days ago)

yes, post_read marks which posts a user has marked as read. it links post ids with user ids and adds a timestamp on top to allow for sorting.

edit:

for comments, lemmy only stores the number of read comments per post, which is what goes into person_post_aggregates. this is a tradeoff, it has some limitations, e.g. when comments are deleted or removed, which affects the total count. as there is also a timestamp attached it might be possible to use that in combination with comment creation times, though this would likely impact query performance quite a bit more.