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.

  • snoweA
    517·
    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
      22·
      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 @[email protected] and @[email protected] (you) upvoted this comment, and that @[email protected] (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.

      • snoweA
        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
          3·
          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.

      • snoweA
        2·
        1 year ago

        DataGrip. best database tool on the planet. JetBrains really does make the best stuff.