Next.js + PostgreSQL + Drizzle ORM - Nextjs Full Stack Project
Dave Gray
@davegrayteachescodeAbout
Web Development tutorials with full courses on HTML, CSS, JavaScript, React, Node.js and more! My goal is to help you learn how to build the web. Teaching helps me learn, too. I work full-time as a Solutions Architect / Developer and part-time as a university web dev instructor. Thank you for subscribing, supporting my channel and sharing the videos you think may help others. Keep striving for progress over perfection. And a little progress every day goes a very long way. Milestones: July 20, 2020 - 1st video Jan 1, 2021 - 1k subs April 2021 - 4k watch hours Nov 2021 - 10k subs Jan 21, 2022 - Video at 100k views Feb 16, 2022 - 100k watch hours Feb 19, 2022 - 1m views Dec 13, 2022 - 100k subs Dec 2022 - Over 1m views in 1 month April 7, 2023 - 10m views May 26, 2023 - 1m watch hours Sept 22, 2023 - Video at 1m views Dec 25, 2023 - 250k subs
Latest Posts
Video Description
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/ 🔗 Drizzle ORM: https://orm.drizzle.team/ 🔗 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
Drone Essential Upgrades
AI-recommended products based on this video

SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314

NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048

SmallRig Baseplate for Sony Alpha 6700, Bottom Mount Plate Built-in Quick Release Plate for Arca, Supporting Quick Switch Between Tripod and Stabilizer (for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro) - 4338

SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314

NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048

SmallRig Baseplate for Sony Alpha 6700, Bottom Mount Plate Built-in Quick Release Plate for Arca, Supporting Quick Switch Between Tripod and Stabilizer (for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro) - 4338

SanDisk 128GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXD-128G-GN4IN

SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314

NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048

SmallRig Baseplate for Sony Alpha 6700, Bottom Mount Plate Built-in Quick Release Plate for Arca, Supporting Quick Switch Between Tripod and Stabilizer (for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro) - 4338

DJI Mic Mini (2 TX + 1 RX), Detail-Rich Audio, Wireless Lavalier Microphone for Camera/Android, 2-Person Vlog, Team Production

Frizzlife M3005 Replacement Filter Cartridge Set (4 Pack) for SK99,SP99,SK99 New and SP99 New Under Sink Water Filter System

Anker Nano USB C Wall Charger,45W Fast Charging Smart Display Charger,with 180°Foldable Plug,Smart Recognition,Built-in Care Mode,for iPhone17/16/15 (Non-Battery,One USB-C Port,No Cable Included) ClimatePartner certified

eazpower for Magsafe Power Bank 10000mAh, Magnetic Battery Pack Wireless, 20W PD Fast Charging, Compact Portable Charger with Built-in Cables and Stand for iPhone 16/15/14/13/12/ Apple Watch/Airpods



















