divoxutils

divoxutils is a specialized tool designed for the Dark Age of Camelot gaming community. It offers a unique blend of features tailored to enhance the gaming experience for enthusiasts of this classic MMORPG.

Key Features

  • Character Lists: Users can compile all of their Dark Age of Camelot characters into a single, manageable list.
  • Leaderboards: See where you stand in both 'All Time' and 'Last Week' categories, offering competitive insight into your game standing.
  • Group Builder: A novel feature allowing users to create in-game group setups by adding other users and selecting characters for each participant.
  • Discord Bot: Seamlessly integrate with your Discord server, providing access to a range of commands that fetch information and statistics about users and their characters.
  • User Authentication: Discord SSO with Clerk to ensure ease of use and secure access for our users.

Technologies Used

NextJS & TypeScript, Clerk/NextJS for user management and authentication, Vercel for hosting, Prisma for database management, PostgreSQL for data storage, Playwright for testing

Purpose and Goal

To provide a comprehensive suite of tools for Dark Age of Camelot players to enhance their gaming experience and community engagement.

Role

Sole developer and project owner: Managed all aspects of the 'divoxutils' project from conception to deployment.

Technical Hurdles

  • Reducing request times and preventing timeout errors when loading large user lists, which became a significant issue as some users have lists with over 100 characters.

Solutions

  • Modified the database schema for optimized data handling and implemented cron jobs to periodically update and pre-process data, significantly reducing load times and preventing timeout errors.