Mission 5 of 12
Build a Game Collection Dashboard
Rebuild the collection idea properly - this time in React with routing and a real cloud database: a PostgreSQL database on Railway, with full add, edit and delete.
By the end of this mission: “I can build a React app with routing that reads and writes to a cloud PostgreSQL database.”
The tech stack for this mission
What you learn, checkpoint by checkpoint
Checkpoint A
Build the React UI with routes and reusable components
- Set up a React project and split the UI into reusable components
- Add React Router so the app has multiple views and clean URLs
- Pass data with props and manage local state with useState
Checkpoint B
Connect a PostgreSQL database on Railway and load the collection
- Provision a PostgreSQL database on Railway and connect it to your app
- Read the game collection from PostgreSQL and render it live
- Model your PostgreSQL tables and columns sensibly
Checkpoint C
Add, edit and delete games, then deploy
- Add new games and update existing ones in PostgreSQL
- Delete games and reflect every change in the UI immediately
- Handle loading and error states, then deploy to Vercel
AI companion mode · AI as Reviewer
You write the code · AI reviews it
Companion suggests refactors and reviews PRs. You write the code; AI catches what you miss. You decide what to accept.
What proves you’re done
Deployed React + PostgreSQL game dashboard + architecture note
Every mission ships something real and public. If you can’t explain it, you can’t submit it.
Reading is not building.
This mission is part of the paid 12-week programme - but the way we teach is free to try. The free trial puts you inside Sigmo, the learning portal our students use daily, with the 6 Projects in 6 Days precourse: real projects, real code, published to your own GitHub.
Start the free trialReady for the real thing?
The AI-Native Software Development Programme - all 12 missions with a live cohort, daily Buildroom, and mentors watching your back.