Premise

OpenModServer is a web application for managing and hosting modifications for popular video games. It provides an easy-to-use interface for game players to download new mods for their favourite games, a simple way for mod developers to upload their mods, and a way for site administrators to moderate and verify submissions. It is built using ASP.NET Core, with a PostgreSQL database for storing user data.

Moderation

Accepting arbitrary user uploads has always been a challenge for websites, and OpenModServer is no exception. To combat this, OpenModServer uses a moderation system, where users can submit mods for approval, and site administrators can review and approve or reject them.

This system is built using a PostgreSQL database, with a table for mods, releases, verifications, and users. In addition, OpenModServer automatically submits uploads to virus-checking site VirusTotal, and periodically pings VirusTotal to check if it has finished processing the file. Once it has been processed, OpenModServer will show the result to the site administrators in the review process.

Premise

Gradekeeper is a free and easy-to-use website and Progressive Web App (PWA) that allows university students to track their course progress.

It provides helpful information about average grades, grades needed to reach a certain goal, and projected grades, based on what they've already achieved.

Infrastructure

Gradekeeper is a Next.js app, using React and Chakra UI on the frontend, with Prisma ORM connected to a PlanetScale MySQL database for storing user data. It uses Google for authentication and account management.