I was managing my video game backlog/queue with a Google sheet and decided to make a web app to replace it.
Currently a WIP, but the API is functional. The UI needs to integrate with the API and be built.
- PostgreSQL database to hold all of the game data and the user-created data (lists, collections, etc)
- .NET Core C# command line program to fill the games database with information from the IGDB
- ASP.NET Core C# Web API to create an interface for the database
- React-based frontend for the UI
- Additional endpoint to update the game database with changes pushed by the IGDB
- Add a caching layer with a batching process to shrink the self-hosted game data size
- Creating ordered lists of games a user is interested in playing
- Creating a collection of games that a user owns
- Tracking the "play state" of games (Unplayed, In Progress, Completed, Paused)
- A finished user interface
- Support for game dependency play orders
- Auto-populated queue functionality using dependency graph to automatically surface the next games a user is interested in playing
- Per-entity privacy, e.g. lists, collection items, and played games can be private