• 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.