The best part of the fediverse is that anyone can run their own server. The downside of this is that anyone can easily create hordes of fake accounts, as I will now demonstrate.
Fighting fake accounts is hard and most implementations do not currently have an effective way of filtering out fake accounts. I’m sure that the developers will step in if this becomes a bigger problem. Until then, remember that votes are just a number.
Oh cool 👀 What’s the rest of that table? Is the
actor_idone column in like… anupvotestable or something?actor_id is just the full url of an user. It has the username at the end. That’s why I have censored it.