Next.js + Postgres Setup Walkthrough: Dev/Production

Complete walkthrough of how to set up Next.js with Postgres for both local development (with Docker Compose) and production (with Vercel Postgres). We'll set up Prisma as our ORM and Knex for migrations. We'll even hit a touch on React Server Components and the brand new Server Actions.

By the end of this video, you'll have a complete dev and prod Next.js with database set up and ready to go!

0:00 - Intro
0:33 - Initialize Next.js Project
1:11 - Switch NPM to PNPM
1:48 - Postgres in Docker Compose for Development
3:50 - Prisma ORM Setup
9:07 - Knex Migrations Setup
15:33 - Next.js page to load data
18:12 - Generate data with Server Action
28:38 - Vercel Postgres Setup for Production
35:45 - Outro

---

Resources:

GitHub repo for this video:
https://github.com/mrwade/next-starte...

Ultimate Node Stack 2023 blog post:
https://kevinwwwade.medium.com/the-ul...