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