Mark all as read

Welcome to Codidact Meta!

Codidact Meta is the meta-discussion site for the Codidact community network and the Codidact software. Whether you have bug reports or feature requests, support questions or rule discussions that touch the whole network – this is the site for you.

Indicate which posts in the category feed have unread updates


Right now, if a category has new/updated posts, a small dot appears next to the category name.

Could this feature be extended to posts within the category as well? While it's not that hard to just manually see which posts have unread changes, it would be convenient to have an indicator.

Why should this post be closed?


I don't know how things are tracked right now. My gut feeling (sometimes wrong) is that there is a per-user-per-category timestamp which is used to generate these magic dots. If you want it per-post then that jumps from users x categories to users x posts - potentially a huge table. manassehkatz‭ 3 months ago

@manassehkatz You wouldn't need to store timestamps, just read/unread status, so it would just be the table of users and the list of posts they've read. Updating the lists might be a pain though. Moshi‭ 3 months ago

@Moshi Whether it is UserId + PostId + Boolean or UserId + PostId + Timestamp makes very little difference. Timestamp would make for slightly larger records. Boolean would make the update process more complicated (because you would have to update all the little records each time). There are some other variants I can think of. But end result is a ton of little records for relatively little benefit. MySQL (and PostgreSQL too) doesn't handle that all that well when you manassehkatz‭ 3 months ago

scale from thousands up to millions. Been there, done that. Most of the actual disk spaces gets taken up by the indexes. No matter how you slice it, its a mess. Not worth doing IMHO. Personally, the way I read (here or SE) is I go to the relevant site/community/category and then start at the top and work my way down until I see stuff that I know I already read (based on displayed timestamps). manassehkatz‭ 3 months ago

@manassehkatz I didn't mean UserID + PostID, I meant having one record per userID with a list of postIDs that correspond to which posts the user has read. Moshi‭ 3 months ago

Show 4 more comments

0 answers

Sign up to answer this question »