Skip to content

Week 3 — Proxy Pattern & Database Intro

Apr 14 – Apr 18

What We're Covering

The proxy pattern on Day 1 — how your API can act as a middleman to external services (like TMDB). Day 2 introduces databases with PostgreSQL and Prisma ORM.

Readings

Due This Week

Quiz 3 — Due: Sunday, April 19 at 11:59 PM

Canvas · Site

Covers: The Relational Model & Data Modeling

Check-Off: Proxy API — Due: Sunday, April 19 at 11:59 PM

Canvas · Site

Build an API that proxies data from an external source.

Sprint 1 — Due: Sunday, April 19 at 11:59 PM

Canvas · Site

Express server, TMDB proxy routes, OpenAPI started.

What You Should Be Working On

  • Sprint 1 — get your group's Express server running with TMDB proxy routes and start OpenAPI documentation.
  • Proxy API check-off — individual work demonstrating the proxy pattern.
  • Review the proxy pattern guideThe Proxy Pattern walks through building proxy routes with the lecture demo's weather API.
  • Review the middleware guideRouting & Middleware covers patterns you'll use in Sprint 1.
  • Read the Week 3 reading and take Quiz 3.
  • AI Diary — log your Week 3 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
  • LO6: Transfer object-oriented programming skills to a new language and ecosystem

Course Outcomes:

  • Inquiry and Critical Thinking — modes of inquiry, analysis, and critical synthesis

Lecture Recaps