Postgres Workshop

Prerequisites

• Docker Desktop (running)
• Node.js 20+
• Git

Install

cd frontend
npm install

Run

Make sure Docker Desktop is running, then:

docker compose up --build

Access

• App: http://localhost:3000
• pgweb (database UI): http://localhost:8081

Workshop

You have been hired by a superhero organization to create reports on their team's performance. Their superheroes have all taken an assessment, and now we have a database with their results. Here are your objectives.

1. Get Best and Worst Questions by Category
2. Get the top Weapon, Vehicle and Suit used
3. Search one year goals
4. Extra credit - Find the top performing superhero
5. Extra credit - Add a bar graph of average Mission Planning, Team Dynamics, Tech and Tactics scores
6. Extra credit - Add a dropdown to filter by superhero, so this report is individual rather than average results
7. Extra credit - Add a line under each goal with the name of the superhero who had that goal