This repository hosts the code for a comprehensive tutorial on building a Project Management Dashboard using Next.js, Node.js, and AWS services. Follow the video tutorial on YouTube for detailed setup, configuration, and deployment instructions.

For discussion and support for this specific app, join our Discord community.

• Frontend: Next.js, Tailwind CSS, Redux Toolkit, Redux Toolkit Query, Material UI Data Grid
• Backend: Node.js with Express, Prisma (PostgreSQL ORM)
• Database: PostgreSQL, managed with PgAdmin
• Cloud: AWS EC2, AWS RDS, AWS API Gateway, AWS Amplify, AWS S3, AWS Lambda, AWS Cognito

Ensure you have these tools installed:

• Git
• Node.js
• npm (Node Package Manager)
• PostgreSQL (download)
• PgAdmin (download)

1. Clone the repository: git clone [git url] cd project-management

2. Install dependencies in both client and server: cd client npm i cd .. cd server npm i

3. Set up the database: npx prisma generate npx prisma migrate dev --name init npm run seed

4. Configure environment variables:

• .env for server settings (PORT, DATABASE_URL)
• .env.local for client settings (NEXT_PUBLIC_API_BASE_URL)

5. Run the project npm run dev

• Complete project code on GitHub
• Tailwind CSS configuration
• Redux Toolkit setup
• Database seed files
• Image files
• globals.css file (to copy for Gantt charts)
• AWS EC2 Instruction file

• Data model diagram
• AWS architecture diagram
• AWS Cognito flow diagram

• Command for resetting ID in database:

  SELECT setval(pg_get_serial_sequence('"[DATA_MODEL_NAME_HERE]"', 'id'), coalesce(max(id)+1, 1), false) FROM "[DATA_MODEL_NAME_HERE]";