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.