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.

  • snowe@programming.dev
    5·
    1 year ago

    ~~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…).

    • Dandroid@dandroid.app
      21·
      1 year ago

      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.

      • snowe@programming.dev
        3·
        1 year ago

        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.

        • Dandroid@dandroid.app
          6·
          1 year ago

          It is stored. I can see everyone that upvoted and downvoted your comment by looking into my database right now.

          It has to be, actually. Otherwise you could easily use the API to keep upvoting the same post or comment over and over.

        • Jay K@lemmy.ml
          5·
          1 year ago

          It also needs to show me how I voted in the UI. It’s stored somewhere.

        • livus@kbin.social
          2·
          1 year ago

          @Bishma I am on kbin. If you upvote my comment I can go into ‘activity’ and get a username list of everyone, from any instance, that upvoted me. The data is obviously there.

    • 𝒍𝒆𝒎𝒂𝒏𝒏
      1·
      1 year ago

      I was looking for vote for some reaason

      Happens to the best of us lol.

      What DBA program is that? It looks sexy clean 😍