Expertov
November 2024 – PresentGraduation Thesis / Freelance / SaaS
Next.jstRPCDrizzle ORMClerkTailwind CSSTypeScriptPostgreSQL
About the Project
Expertov is a sports prediction application developed as my graduation thesis. It is a comprehensive SaaS platform designed for betting on sports results. The project was inspired by a real-world client requirement for a modern, scalable replacement for an existing, outdated solution.
The application is built using the modern T3 Stack: Next.js, tRPC, Drizzle ORM, Clerk, Tailwind CSS, TypeScript, and PostgreSQL.
Main Features
- Complete Event Management: Administrators can easily create sports events, manage teams, and set up individual matches.
- Automatic Scoring: Once a match result is entered, the system automatically recalculates points for all participants and updates the overall leaderboards.
- Roles and Permissions: An integrated role system (Admin, Helper, User) is managed through the Clerk platform.
- Statistics and History: Users can browse past events and track their prediction success with detailed statistics.
- Mobile-first Design: The application is fully responsive, ensuring a seamless experience for users predicting on the go.
Technical Solution
- Frontend & Backend: Built with Next.js using the App Router. tRPC is used for type-safe communication between the client and server.
- Database: PostgreSQL with Drizzle ORM, featuring a carefully designed schema for performance and scalability.
- Authentication: Secure and seamless user account management provided by Clerk.
- UI/UX: The interface is crafted with Tailwind CSS and the Radix UI / Shadcn/UI component libraries for a premium feel.
Graduation Thesis
The entire development of the application, including the design of the database schema, competitor analysis, and results from beta testing (2025 IIHF World Championship), is documented in my graduation thesis.