CodingNic

Capstone: A Full CRUD API with a Real Database

Module Overview

Capstone: A Full CRUD API with a Real Database 5 min read

Module Overview

What You’ll Learn

  • Rebuild an MVC-structured Express app against a real, persistent database
  • Swap an in-memory model for a Prisma-backed model with minimal controller changes
  • Confirm a full CRUD API behaves correctly against real, persisted data

💡 Why this module matters: Node.js & Express Foundations ended with an MVC app backed by an in-memory array. Every module in this course since has built toward this: a real database underneath that exact same structure, this capstone puts it all together.

What’s Covered

  • Reusing the MVC structure, models, controllers, and routes, from Node.js & Express Foundations.
  • Swapping the data layer, replacing an in-memory model with one backed by Prisma and PostgreSQL.
  • A real, persistent CRUD API, confirmed to survive a server restart.
  • A MongoDB variant, the same API rebuilt on Mongoose, to compare both approaches directly.

Hands-On

By the end of this module, you’ll have a complete CRUD API, structured with MVC, backed by a real, persistent database, data that survives a restart, exactly what an in-memory array never could.

This is the final module of Databases & ORMs for Node.js. From here, the next course in this track picks up production-readiness: authentication, validation, security, and testing.