Who have logs of how users vote?
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.
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 forvote
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?
It is stored, obv, but where? Where my likes come from when I see the same post?
Happens to the best of us lol.
What DBA program is that? It looks sexy clean π
DataGrip. best database tool on the planet. JetBrains really does make the best stuff.