Next.js + PostgreSQL + Drizzle ORM – Nextjs Full Stack Project

Learn how to add a PostgreSQL (aka Postgres) database to your Next.js app with Neon Postgres and Drizzle ORM in a step-by-step tutorial. This video is part 3 of a Nextjs 15 Full Stack Project series.

⭐ Use the code “davegray” for 3 months free on the Team plan of Sentry for any new accounts:
– Sentry Homepage: https://bit.ly/sentry-dg
– Sentry Sign-up: https://bit.ly/try-sentry-dg
– Sentry Next.js: https://bit.ly/sentry-nextjs-dg
– Sentry Next.js Docs: https://bit.ly/sentry-docs-dg

🔥 Neon Postgres: https://fyi.neon.tech/davegray

🔒 Kinde Auth: https://kinde.com/dgray-nextjsstack/

👉 Web Dev Roadmap for Beginners (Free!): https://bit.ly/DaveGrayWebDevRoadmap

💖 Support me on Patreon ➜ https://patreon.com/davegray

🚩 Subscribe ➜ https://bit.ly/3nGHmNn

📬 Course Updates ➜ https://courses.davegray.codes/

❓ Ask Questions & Discuss on Discord ➜ https://discord.gg/neKghyefqh

☕ Buy Me A Coffee ➜ https://www.buymeacoffee.com/davegray

🔗 Next.js Full Stack Project playlist: https://www.youtube.com/playlist?list=PL0Zuz27SZ-6PCLz7VMP2QQdeKa83rshe5

👇 Follow Me On Social Media:
GitHub: https://github.com/gitdagray
Twitter: https://twitter.com/yesdavidgray
LinkedIn: https://www.linkedin.com/in/davidagray/

🔗 Course Resources: https://github.com/gitdagray/nextjs-full-stack-project

Next.js + PostgreSQL + Drizzle ORM – Nextjs Full Stack Project

(0: 00: 00) Intro
(0: 01: 12) Tech Stack
(0: 01: 32) User Stories Checklist
(0: 04: 06) Create a Free Neon Account & Project
(0: 09: 45) Upgrading to Next.js 15 Stable Version
(0: 13: 21) Installing Drizzle ORM with Neon Postgres
(0: 15: 55) Create a database connection
(0: 19: 27) Create database table schemas
(0: 27: 55) Define table relationships
(0: 30: 56) Create a migration function
(0: 34: 30) Create the drizzle config
(0: 36: 49) Add scripts to package.json
(0: 37: 55) Generate and Migrate database changes
(0: 40: 18) Adding Data

📚 Tutorial References:
🔗 Next.js: https://nextjs.org/
🔗 ShadCN/ui: https://ui.shadcn.com/
🔗 Sentry Next.js: https://bit.ly/sentry-nextjs-dg
🔗 Tailwind CSS: https://tailwindcss.com/
🔗 TypeScript: https://www.typescriptlang.org/
🔗 Neon Postgres: https://fyi.neon.tech/davegray
🔗 Kinde Auth: https://kinde.com/dgray-nextjsstack/

Was this Next.js Full Stack PostgreSQL tutorial with Neon & Drizzle ORM helpful? If so, please share. Let me know your thoughts in the comments.

#nextjs #postgres #postgresql