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

ReactReact RouterPostgreSQLRailwayBootstrapVercel

What you learn, checkpoint by checkpoint

  1. 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
  2. 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
  3. 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.

Free · no card needed

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 trial

Ready for the real thing?

The AI-Native Software Development Programme - all 12 missions with a live cohort, daily Buildroom, and mentors watching your back.