Server Ratings (Upvote/Downvote)

[gamemann]

This issue will track progress on implementing server ratings (upvote/downvote).

[gamemann]

I'd like to do something similar to one of my other projects, Best Mods.

Unfortunately, this will more than likely require transitioning to utilizing raw Prisma/PostgreSQL queries when retrieving servers from the server browser due to lack of support for certain features our implementation will require in Prisma. That said, sorting by server ratings in Best Mods at the moment is very expensive on large tables due to aggregation. I'd really like to find a better performing query, but I'm unsure what we can do without periodically updating the server rating in the servers table, which might be a solution to consider, but won't provide real-time ratings like Best Mods does it at the moment.

I don't believe caching PSQL queries will help in our case since we use cursor-based pagination and with how often the server table will update from Spy, the cache will change so often that caching becomes pretty useless.