this post was submitted on 10 Nov 2023
32 points (82.0% liked)
Asklemmy
43908 readers
1308 users here now
A loosely moderated place to ask open-ended questions
Search asklemmy π
If your post meets the following criteria, it's welcome here!
- Open-ended question
- Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
- Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
- Not ad nauseam inducing: please make sure it is a question that would be new to most members
- An actual topic of discussion
Looking for support?
Looking for a community?
- Lemmyverse: community search
- sub.rehab: maps old subreddits to fediverse options, marks official as such
- [email protected]: a community for finding communities
~Icon~ ~by~ ~@Double_[email protected]~
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
~~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_liketable (I was looking forvotefor some reaason...).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.
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.
If nothing is stored, how are users prevented from voting multiple times?
It is stored, obv, but where? Where my likes come from when I see the same post?
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.
It also needs to show me how I voted in the UI. It's stored somewhere.
@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.
Happens to the best of us lol.
What DBA program is that? It looks sexy clean π
DataGrip. best database tool on the planet. JetBrains really does make the best stuff.