4 ms·
I would absolutely expect every vote to be recorded in a row with at least up/down, by whom, and when. You can browse your own votes on posts, I don't know if t
by extra88 8y ago
I would absolutely expect every vote to be recorded in a row with at least up/down, by whom, and when. You can browse your own votes on posts, I don't know if there's a way to browse votes on comments.
https://www.reddit.com/user/USERNAME/upvoted/ https://www.reddit.com/user/USERNAME/upvoted/
https://www.reddit.com/user/USERNAME/downvoted/ https://www.reddit.com/user/USERNAME/downvoted/
- threeseed 8y agoYou realise that Reddit is over 10 years old. There would have been trillions of votes since then. What database are you thinking that could store all of those and then I assume aggregate them ? Kind of curious about this proposed architecture.
- extra88 8y agoI would expect vote sums to be stored separately, you don't need to query a table containing all votes on every page load any more than a bank needs to query all transactions to show your account balance.
- jedberg 8y agoPostgres. And that's exactly how it has been. Every vote is a row that gets post-processed.
- intended 8y agoWouldn’t that database be just positively massive? How fast does the database grow?