Lemmy

2172 readers

57 users here now

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to [email protected].

founded 4 years ago

MODERATORS

[email protected]

171

Interesting difference from Reddit: Upvotes/Downvotes are not anonymous (programming.dev)

submitted 1 year ago by [email protected] to c/[email protected]

114 comments fedilink hide all child comments

Hey folks! Just realized something that makes Lemmy different from Reddit. Because of the federation, your votes are not technically anonymous on Lemmy. At least, I think.

Although there’s no UI to look at a user’s voting history yet, one could conceivably be built by an instance. Perhaps coincidentally, I hear there’s instances out there populated by mostly bots?

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

[–] [email protected] 2 points 1 year ago* (last edited 1 year ago)

The table that store upvote is named comment_like and post_like. Here, you have the vote’s unique id, the local user id that is linked to the it’s "global id", the local post id which is also linked to it’s "global id", the value of the vote (+/-1) and the date.

So votes are indeed totally not anonymous.

(and I run my server sinces less than a week, and the sum of entry in the two table is of 114 950 votes. Certainly enought for doing a bunch of analysis.)

Example of datas for the comment vote table (ids has been changed)

  id   | person_id | comment_id | post_id | score |         published          
-------+-----------+------------+---------+-------+----------------------------
     1 |        10 |          3 |      61 |     1 | 2023-06-17 20:01:20.948684
     2 |        34 |          1 |      22 |     1 | 2023-06-17 20:01:26.346783
     3 |        12 |          2 |      54 |     1 | 2023-06-17 20:01:27.627144
     4 |        20 |          7 |      91 |     1 | 2023-06-17 20:01:36.570636

Ping @[email protected]