Week 4 — Prisma Deep Dive & Migrations¶
Apr 21 – Apr 25
What We're Covering¶
Going deeper with Prisma ORM — schema design, migrations, relations, and type-safe queries. This is where your group project connects to a real database.
Readings¶
Due This Week¶
Check-Off: Prisma Intro — Due: Sunday, April 26 at 11:59 PM
Define a Prisma schema, run migrations, and write type-safe queries.
Sprint 2 — Due: Sunday, April 26 at 11:59 PM
Prisma schema, PostgreSQL connected, user find-or-create, ratings CRUD.
What You Should Be Working On¶
- Sprint 2 — connect your group project to PostgreSQL via Prisma. Implement user provisioning and ratings CRUD.
- Prisma Intro check-off — individual hands-on with Prisma.
- Review the data access guides — SQL Fundamentals, PostgreSQL Setup, and Prisma ORM cover everything you need for Sprint 2.
- Read the Week 4 reading and take Quiz 4.
- AI Diary — log your Week 4 entry.
Learning Objectives & Course Outcomes¶
Syllabus Learning Objectives addressed this week:
- LO1: Design and implement RESTful web APIs using a server-side framework
- LO2: Model and access relational data using an ORM backed by a relational database
- LO7: Collaborate in teams using version control workflows, sprint milestones, and code review
Course Outcomes:
- Inquiry and Critical Thinking — modes of inquiry, analysis, and critical synthesis
Lecture Recaps¶
- Tuesday — Coming soon
- Thursday — Coming soon