Who have logs of how users vote?

andrew_bidlaw@sh.itjust.works to Asklemmy@lemmy.ml – 32 points –

Besides it's a very important question for our privacy, I suspect some of my comments getting downvoted at set periods of time from other accounts. I don't understand how the fediverse work and what I'm asking is who has vote logs? Who I can ask, if a bot, like on reddit, got dedicated to downvote every post from one user. How to avoid vote brigading on here? Can it be automated?

I'm not pissed and I do know I post literal shit sometimes. It's just I'm wondering, if our fedieverse have machanics against that.

44

You are viewing a single comment

~~We do not. Who voted on what is not stored at all. There’s not a database table for it nor is it logged in the logs. ~~

I am apparently too sick to be commenting on here. Comment likes are stored in the comment_like table (I was looking for vote for some reaason...).

This is absolutely not true. I just verified in my database that I can see how everyone voted on your comment. I can see that @Bishma@discuss.tchncs.de and @snowe@programming.dev (you) upvoted this comment, and that @dandroid@dandroid.app (me) downvoted this comment.

Edit: more people voted since my comment, and I can see all them, but I don't want to put those people on blast. I wrote a very short SQL query to get me this information for any comment id. It took about 3 minutes with zero previous knowledge of the lemmy database.

which table? Because I sure don't see that in the programming.dev db.

edit: nevermind, it's the comment_like table. I'll update my other comment with a retraction.

If nothing is stored, how are users prevented from voting multiple times?

5 more...