• Blaze (he/him)@sopuli.xyz
      link
      fedilink
      English
      arrow-up
      3
      arrow-down
      1
      ·
      2 years ago

      For real civil identities, definitely.

      For alts I can create in a whim, not so much.

      And before you tell that spammers would create alts too, you can imagine some age or karma (because it exist, even if hidden) before being able to downvote.

    • cwagner@lemmy.cwagner.me
      link
      fedilink
      English
      arrow-up
      1
      arrow-down
      1
      ·
      edit-2
      2 years ago

      Just FYI, they are public, but not exposed. And the information federates. So I could check my server right now to see which users up and down voted.

      edit:

      Anyone with DB access on any server (that includes my single-user instance), can run this to see who upvoted and downvoted a post (similar queries exist for comments):

      SELECT public.post_like.score, public.person.name
      FROM public.post
               INNER JOIN public.post_like ON public.post.id = public.post_like.post_id
               INNER JOIN public.person ON public.post_like.person_id = public.person.id
      WHERE public.post.id = 33297
      ORDER BY public.person.name;
      

      You could probably also do public.post.name = 'Italy shocks banks with 40% windfall tax for 2023' to avoid the instance-specific id.