- Gani Begawala
- Sophia Caffery
- Jonathan Gilbert
- Maxwell Graeser
- Michael Vuolo
...and the original Senior Design Team that initially released the project
This project is an extension of a previous year's Senior Design Project located here.
We were tasked with improving the original source code, with the initial requirements proposed by our sponsor:
- Data Visualization
- Tailored Gantt Charts (With Multiple Projects)
- Dependency Visualizations
- User-Tailored Dashboard Views
- Based on User Roles/Interests
- Implementation of Tiles
- Incorporation of AI-Based Solutions
- Prediction of Issues
- Resolution of Backlog List Items
- Using Agile Approaches
- Switched our framework from React Router to Next.js
- Converted all JavaScript files to TypeScript
- Added Prisma for SQL Injection prevention (a serious issue that was present in the previous team's source code)
- Replaced Express with tRPC to ensure API type-safety from the front-end client to the back-end server
- Switched from React Bootstrap to Headless UI for more style customization
To run locally, follow the following steps:
- Download the SQL script that sets up the database table (Note: It's not hosted here yet, so use this file for now)
- Make sure to create two users named
usafandusaf_adminwith appropriate privileges
- Make sure to create two users named
- Run
npm installto install the node packages - Duplicate .env.example and rename it to
.env, and fill it in with the appropriate contents - Run
npx prisma db pushto push the new database schema (that includes authentication) to the SQL server - Run
npm run devto start the local development server
- MySQL (Azure SQL Database for production)