Prisma in Next.js - My Fav Way to Work with Databases (CRUD, Dev/Prod Workflow, Relations, Indexes)

👉 Check out Prisma: www.prisma.io/... (paid sponsorship & I get commission from your purchases)
Disclaimer: this is a sponsored video (paid). It's your responsibility to evaluate safety, accuracy and other relevant parts of the reviewed product.
👉 NEW React & Next.js Course: bytegrad.com/c...
Hi, I'm Wesley. I'm a brand ambassador for Kinde (paid sponsorship).
👉 Check out Kinde for auth and more bit.ly/3QOe1Bh
👉 NEW React & Next.js Course: bytegrad.com/c...
👉 Professional JavaScript Course: bytegrad.com/c...
👉 Professional CSS Course: bytegrad.com/c...
👉 Web development roadmap 2024 & 2025: email.bytegrad...
👉 Email newsletter (BIG update soon): email.bytegrad...
👉 Discord: all my courses have a private Discord
⏱️ Timestamps:
00:00 Intro
01:07 Next.js architecture
02:02 Example app overview
03:15 Setup Prisma
06:09 Schema fundamentals
07:36 Prisma extension + defaultFormatter
08:34 Schema fundamentals (continued)
10:09 Create database
12:38 View database content (Prisma Studio)
14:13 GET data on page (findMany)
16:50 Prisma Client instantiation
18:29 GET data on page (findUnique)
22:18 Changing schema (Slug) - npx prisma db push
25:38 @unique
27:42 @map
28:04 @index
28:53 Filtering (where)
29:55 Ordering
30:18 Select
31:00 Pagination
32:29 Count
33:42 Writing data (POST / PUT / DELETE)
42:03 Relations (one-to-many)
43:54 Many-to-many
44:27 One-to-one
46:50 include & connect (relations queries)
49:12 Seeding database
51:10 Prisma types
53:13 Seeding database (continued)
55:50 Error handling
57:35 Caching in Next.js
59:59 Prisma Accelerate caching
1:00:34 Going to production
1:04:32 Migrations
1:06:15 npx prisma migrate
1:08:18 postinstall (prisma generate)
1:08:42 Push to Vercel
1:10:19 Serverless vs Edge
1:10:59 Middleware (edge)
1:13:07 Prisma Pulse
#webdevelopment #reactjs #nextjs

[@Ssmb-qj4df]

Man is the best teacher who doesn't give me anxiety while learning

[@rohitkochikkatfrancis]

THIS IS THE BEST EXPLAINED VIDEO FOR PRISMA !!!!! Thank you so much for dwelling into even the minor details so that people who dont even have a clue bout what it is can easily understand it.

[@rtx50700]

Bro read my mind, yesterday I was thinking about when you will make a video on Prisma..and here it is 🙏

[@enn_nj]

😂same with me bro..i love you so much bro, you read our mind😂🙏🏻🙏🏻🙏🏻 that's what i need..thankyou so muchh💐💐💐♥️

[@PrismaData]

Incredible video!

[@ByteGrad]

Any time!

[@CleverGeneration]

I'm only half way through and I've already learnt so many new things, thank you!!! Brilliant video ❤

[@Saradomin65]

Was planning to get back to full-stack dev using prisma with Nextjs to create some side projects and this video comes in. Definitely will help a ton, thanks! 😁

[@olusanyaolamide9764]

Nice one, will definitely check it out when I have time, I'm excited already, but we'll also love you to do a NodeJs Express course

[@aryaamootaghi3248]

this guy knows what he is doing 🚀🚀🚀🚀

[@ReDestro69]

Hey ByteGrad, love your videos. Would love to see you make a video on supabase and Nextjs

[@aloky247]

I was directed here from the Prisma docs. Thank you for the awesome tutorial.

[@abeybruck151]

very very very awesome. you sir is a natural born teacher. respect

[@u.chaudhry2147]

@ByteGrad can you next do tRPC with Next.js App Router? Also, you are the best teacher of the t3 stack out there. The way you teach us in such depth is awesome!

[@alarafatsiddique9362]

Could you please make a tutorial specifically on how to use Prisma from development, and testing to production with some concrete examples?

[@mistersir3185]

The timing of this video is divinely. Love you bro.

[@R3nxt]

Great video. You were right, caching deserves its own video. Could you please upload a video that handles caching?

[@ByteGrad]

Yes, coming soon!

[@armaandhanji2112]

Looking forward to the caching video alot too!

[@josephito27]

10 mins in and it is already solving me a lot of doubts about Next js omg, thank you

[@RobertBojor]

Great example for using Prisma, thank you! I do have a question, when using this over an existing database, with data, and I mean lots of it, wouldn't make more sense to instead use prisma generate, instead of the push, to update the client with the unique fields and so on?

[@GhostHack_1]

One warning about prisma that most developers (including myself) overlook, it does not support optimistic rowlocking API calls. You will have to use Raw SQL for that and it gets very messy / hard to do when accounting for race conditions in production.

[@JackTheZuluman]

Man,I really thought I can use Prisma. Thanks a lot for this🔥🔥🔥

[@ashfaqkabir]

Awesome Video, Please Do a video On Dashboard Tutorial with Next Auth, SeverActions, Prisma and Mongodb

[@jc2057]

good video, and definitely good commercial for copilot lol

[@vt1tov]

I love you man. Thanks! Great content :)

[@zainn7336]

Sir make a full video of supabase and next js as backend

[@nunzioasisto]

What would you suggest if the revalidatePath is not refreshing the input and content boxes after submitting a post? The new post appears but the data is not cleared from input nor content.

[@a4tech357]

Helpful video! Can we get a github repo?

[@RoyTjuh]

dankjewel voor de video kerel

[@jeffinj7707]

Please also consider the fact that there are use cases where we have a standalone node/nestjs backend with an ORM, a nextjs app maybe one of the clients using the APIs. so no point in implementing the ORM in the nextjs too. what would be a better solution here? RQ?

[@jfhandfield]

Wow great video Byte. Really well explained. The only question I have is what if I have 2 different database to access. How are you going to make your clients? Is it going to be in the same db.ts?

[@PolatjonQurbonov]

It is a very informative lesson! Thank you!

[@MrJohn360]

Thanks for sharing.

[@TenzDelek]

i am about to start out, should i go with Prisma or drizzle?

[@mostafashahat9760]

Awesome, keep up the great work 💖

[@Sagarclips]

When creating post, why client component was not used

[@ptk_001]

Thanks for this amazing content!

[@JacobPhillips-rf5db]

THANK YOU! You're AWESOME!

[@socarmm]

Excelente! Gracias

[@kdstudiogames3602]

sir your video is very helpfull to me. i have compleated the above video. but i have issue with the update post which i have tried in same way as server acton use for create post. how to pass the id in action={updatePost}. how to pass the id? please help

[@aberbaCodes]

Unrelated question, but how to you fast forward copy and paste code in your videos whilst the voice shows no break?

[@parkerboling666]

Hey bytegrad I really enjoy your content and recently have been following along in some of your content, and I like kinde authentication. I’m building a full stack application for a childcare company and it would be a good video idea to show admin authorization and interacting with the kinde API to manage users from a secured back end admin panel this would help me out tremendously! I really enjoy the content though keep up the good work!

[@assassingob7315]

Hey, everybody! Can someone explain why after the application build, the updated data in the database is not updated on the client? The component is server-side

[@true227]

i can't find data type cuid() in the description postgre, it's have only uuid()

[@ianc6418]

I am stuck on trying to figure out how sqlite runs on apple silicon. home-brew doesn't seem to work edit: It seems to come preinstalled on macOS. How weird is that!

[@victormustin2547]

I may be wrong but I don't think you talked about security and authorization which would have been great

[@AK-kq1mk]

Useful stuff

[@nikolas_beckel]

Good video 👌

[@mlavinb]

Great content! thanks for sharing

[@indimerz]

can you make a video to show recommended way of doing filtering, sorting, search with nextjs and prisma??

[@alaskandonut]

The prisma documentation is pretty easy to read on search and filter. It’s really not bad at all.

[@darz_k.]

Hey man - as an aside to this video being related to prisma - I'm looking at a new hosting provider, and they are only offering sql databases for the backend - would you recommend using regular sql databases with nextjs and react? Projects would be small to medium in terms of requests and users. If you could give us your advice on that, it would be much appreciated!

[@viundesign]

6:33 Why doesn't it appear to me the autocomplete? I have the Prisma extension already installed

[@mustafamufeed1666]

+1

[@viundesign]

Still wondering

[@viundesign]

@@mustafamufeed1666 Git Hub Copilot

[@viundesign]

@@mustafamufeed1666 Git Hub Copilot

[@suphawatwong9438]

@@viundesign it's co-pilot feature, i guess

[@vipernext2190]

as always greate video ❤❤

[@enn_nj]

The best video from the best teacher 🙏🏻🙏🏻🙏🏻🙏🏻i really like this Chanel.

[@user-vd5kp6jz7d]

Does anyone have a problem with form fields not reset after submission?

[@teetanrobotics5363]

Could you please make a project on credentials and social oauth using Auth.js, Supabase. We can also use resend for sign up confirmation and forgot password.

[@abdelrahmanmostafa9489]

Github link?

[@nasko235679]

When you need to get data from db to a client component would you say the best way is by fetching the data in a parent server component and then passing it down to the client as props?

[@ByteGrad]

That would be pretty typical yes

[@asmitkhanal834]

i m new on nextJs so help me to use delete and update operation in the frontend ui code.How to execute the created function in the UI form?help me plzzz

[@nasko235679]

NICE!

[@eliyir]

🙏

[@krishpatel3632]

What vs code theme do you use? It's great

[@umernasir4217]

Please tell me as well.

[@AvikNayak_]

Maybe Andromeda

[@heismyke]

He doesnt like to tell people what theme he uses. i have been asking him too for a long time

[@ivangeorge4478]

45:52 what was that sound :)

[@blazi_0]

The hardest thing that i dealt with prisma schmea until now was adding multi language support. Tried so many ways and ended up with using json for storing the values Not happy with this solution and looking for better ways, ill be appreciated if someone can help me with this

[@sorenbs1]

I’ve always implemented this by loading the full translation file as json and caching it in memory on the server. That way loading the replacements is super cheap.

[@A28480]

Would be very helpful to understand why the data sometimes disappears when the schema is changed? Anyone know why it happens? Thanks a lot

[@emad_naeim]

if the old data violates the new schema you make then it will be deleted (it will tell you and warn you before that), like if you are going to add new column and that column is required.. and you didn't specify the default value.. then by default old data will be deleted because they don't have value for this new colum. as a hack when you are playing with schema and you want to add new column.. specify a default value.. then it won't delete old data

[@A28480]

@@emad_naeim thank you very much

[@emad_naeim]

@@A28480 😇🤍

[@juliusgrisette]

Thank you

[@imkeyi]

what if a post could have multiple categories and tags

[@irfansaeedkhan7242]

thank you

[@gttrackpro9433]

hey @bytegrad, this workflow & advance tutorial is available on your course?

[@ByteGrad]

We also use Prisma in the course, but not super advanced or something like that

[@gttrackpro9433]

​@@ByteGrad ok got it. going to purchase your course asap 🎉

[@haikelareff]

god bless you...

[@ahmadullahnikzad2850]

revalidatePath does not work

[@richardnorris9256]

This guy must be Dutch to speak English this clearly and quickly while multitasking. He definitely isn't British or American anyway, his English is too good.

[@rvuyyuru]

Switched to drizzle

[@beyourahi]

alright let's start the war 🚀 Prisma VS Drizzle

[@jellyfish1772]

why not drizzle

[@bibblebabl]

If you think you ready to try it - go for it. It’s not exactly the same and it has less abstractions AFAICT. So basically you will need better understanding of SQL because drizzle gives you more control since it’s more a query builder. Now it becomes more popular but I guess not all people understand that it requires some entry level when with prisma you don’t have to care about a lot of things

[@jonbharrell]

@bibblebabl is completely right. Prisma and Drizzle are similar tools at different levels of abstraction. If you prefer the Drizzle way of defining your models and querying, then it is the right tool for you.

[@dukim632]

i find primsa to be pretty horrible tool, the fact that we all opt out writing SQL is just mad. ORM creates stupid developers which cannot write proper SQL which creates TONS of problems later on

[@true227]

i'm totally agree

[@giuseppebosco5813]

Pls drizzle

[@iukeay]

I have a large database relational database with 30+ tables. Does Prisma still have issues doing relationship joins without having to scan the whole table - I have been looking into drizzle Just because we do a lot of relational joins. Just at the very small community and not as much documentation / examples. Love love love all your videos !!!!!! Keep it up king