Quested

About the project

Letterboxd-style app for tracking video games, free, ad-free and open source. Search automatically imports games from IGDB and RAWG (deduplicated by title and year), and each game can be logged with a status, a rating out of 10 to the decimal, and a text review, with filters by genre, platform and year. Every account has a public profile with its games (paginated by status), reviews, likes and custom lists, plus 4 pinned favorite games. A follow system powers an activity feed with recommendations based on your follows' ratings and a taste-compatibility score between players, backed by notifications (follows, likes) and rate limiting on public endpoints. Available in French and English, a personal project still under active development.

The challenge

The main challenge was making game imports from two external sources (IGDB and RAWG) reliable while avoiding duplicates, matching games by title and year rather than exact ID. I also built authentication via Google and Discord with the ability to link both to the same account, plus a follow, like and real-time notification system. The whole thing is built with security and scalability in mind: rate limiting via Upstash Redis on public endpoints, security headers, and a Postgres database on Neon with the Vercel server region aligned to avoid network latency.

Technologies used