Overview
Follow along with a comprehensive step-by-step tutorial that demonstrates how to integrate a PostgreSQL database into a Next.js application using Neon Postgres and Drizzle ORM. Master essential concepts including setting up a Neon account, upgrading to Next.js 15, implementing Drizzle ORM, creating database connections, defining table schemas and relationships, managing migrations, and adding data. Learn through practical examples as you build a full-stack application while exploring database integration techniques, configuration management, and data manipulation strategies. Gain hands-on experience with modern web development tools and best practices for building scalable applications with Next.js and PostgreSQL.
Syllabus
Intro
Tech Stack
User Stories Checklist
Create a Free Neon Account & Project
Upgrading to Next.js 15 Stable Version
Installing Drizzle ORM with Neon Postgres
Create a database connection
Create database table schemas
Define table relationships
Create a migration function
Create the drizzle config
Add scripts to package.json
Generate and Migrate database changes
Adding Data
Taught by
Dave Gray