Prerequisites to install (Frontend)

Node.js (v18+)

Running the front end:

  cd client
  npm install
  npm run dev

Prerequisites to install (Backend)

• MySQL Workbench
• Postman
• IntelliJ IDEA
• Java 21
• Maven (bundled with IntelliJ)

Backend setup:

1. Open the backend in IntelliJ

   cd server/FinalDatabaseProjectBackend
   

2. Create your local configuration file Inside this folder

    src/main/resources/
   

   There's a file named

   application-local.properties.example
   

   Make a copy of it in the same folder (resources) and rename it to

   application-local.properties
   

   This .properties file is ignored by Git, so we can all have our own local settings without exposing anything

3. Fill in your local database credentials If you did the MySQL setup instructions, just drop the same credentials in here

   spring.datasource.url=${DB_URL}
   spring.datasource.username=${DB_USER}
   spring.datasource.password=${DB_PASS}
   spring.jpa.hibernate.ddl-auto=update
   spring.jpa.generate=true
   

Use Postman to test the API requests

Important notes:

• Frontend: work inside /client with VS Code
• Backend: work inside /server with IntelliJ

• DO NOT commit your personal application-local.properties file — only application-local.properties.example