Have read this. I was particularly heartened by the statement on that TransJustice site:
We have been totally overwhelmed by the number of responses to our survey on experiences of anti-trans hate in Australia. We will provide more information in time but wanted to thank everyone for the support this project has received.
This backs up what I was saying: You are surrounded by people who support you.
As to the downvoter: I did make an attempt at that. The database under the hood of Lemmy is overwhelming. Basically, it contains all the federated content. If a single aussie.zone user subscribes to a community on another instance, then that content is in the database. The example posted in the other thread doesn’t work for us: It shows who has upvoted/downvoted a single thread. But that’s not what we want to do in your case. I need to search comment tables for posts you have been in and then cross-reference the comment_like table for postid, userid and commentid.
I’m not a Database admin by trade, I’m ok at database stuff, but this is some complicated bit of table join logic. It might be beyond me, but I haven’t given up, yet.
That setting exists, but it’s instance-wide. It would be a pretty drastic change to all of aussie.zone. I wouldn’t personally be against it, I never use downvote anyway. But, it isn’t a change I could arbitarily make.
A fair question. And something that I have given thought to. It’ll depend on what is turned up. Downvoting a comment on its own is not against the rules. So, potentially nothing.
Stalking a user across multiple communities, downvoting all their comments while otherwise not being engaged at all in those communities takes us into bullying territory. Reddit had a built-in defense against that activity. If you go to a user profile there and just downvote all the comments, they don’t actually take effect against the target. Lemmy doesn’t have that feature yet.
From that point, we’ll see. I honestly don’t know if it’s even possible to do more than just see the vote records. If I delete a downvote, Lemmy may simply restore it through the next federation sync.
Whatever it is, I’ll be transparent about it. I’m also conscious of the precedent this might set. Neither Lodion nor I are much interested in poking through the database and manually touching anything lightly.
Have read this. I was particularly heartened by the statement on that TransJustice site:
This backs up what I was saying: You are surrounded by people who support you.
As to the downvoter: I did make an attempt at that. The database under the hood of Lemmy is overwhelming. Basically, it contains all the federated content. If a single aussie.zone user subscribes to a community on another instance, then that content is in the database. The example posted in the other thread doesn’t work for us: It shows who has upvoted/downvoted a single thread. But that’s not what we want to do in your case. I need to search comment tables for posts you have been in and then cross-reference the comment_like table for postid, userid and commentid.
I’m not a Database admin by trade, I’m ok at database stuff, but this is some complicated bit of table join logic. It might be beyond me, but I haven’t given up, yet.
Maybe fuck the downvote button off while you’re at it? Why do we need it in DT? Everyone defaults to sort by new anyway.
Definitely looks like downvotes can be switched off but might be a community- or instance-wide thing.
Well we could trial it in c/Melbourne then. The only action is the DT anyway.
That setting exists, but it’s instance-wide. It would be a pretty drastic change to all of aussie.zone. I wouldn’t personally be against it, I never use downvote anyway. But, it isn’t a change I could arbitarily make.
Assuming you are able to identify a serial downvoter (or downvoters), what do you intend to do with that information?
A fair question. And something that I have given thought to. It’ll depend on what is turned up. Downvoting a comment on its own is not against the rules. So, potentially nothing.
Stalking a user across multiple communities, downvoting all their comments while otherwise not being engaged at all in those communities takes us into bullying territory. Reddit had a built-in defense against that activity. If you go to a user profile there and just downvote all the comments, they don’t actually take effect against the target. Lemmy doesn’t have that feature yet. From that point, we’ll see. I honestly don’t know if it’s even possible to do more than just see the vote records. If I delete a downvote, Lemmy may simply restore it through the next federation sync.
Whatever it is, I’ll be transparent about it. I’m also conscious of the precedent this might set. Neither Lodion nor I are much interested in poking through the database and manually touching anything lightly.
You’re a legend Nath.