Prisma - The Easiest Way to Work with a Database in Next.js (UPDATED)

Prisma is an ORM and database toolkit which makes it easy to have type-safe database access in Node. It's also the easiest way to work with databases in a Next.js app. You can learn more at prisma.io/nextjs.
In this video, we look at how to integrate Prisma in a Next.js app. We see how to query for data in the getServerSideProps function and how to save data using an API route.
Demo App Repo: github.com/che...
------------------------
Next:
👉 Check Previous video: How to create a PostgreSQL Database with Prisma's Data Platform - • How to create a Postgr...
👉 Check Next video: Seeding Databases with Prisma - • Seeding Databases with...
------------------------
📚 Resources:
✅ Subscribe to Prisma: / @prismadata
✅ Get help from the Prisma Community: slack.prisma.io/
✅ Learn more about Prisma:
◭ Website: www.prisma.io
◭ Docs: www.prisma.io/...
◭ Quickstart: pris.ly/qstart
------------------------
💬 Connect with Prisma:
Twitter: / prisma
Instagram: / prisma.io
TikTok: / prismadata
Facebook: / prisma.io
LinkedIn: / prisma-io
------------------------
Prisma sponsors human-reviewed, professional closed captions for ANY video valuable to our community (for example, about: Node.js, TypeScript & Type Safety, Prisma, databases, etc). Get your FREE captions here: pris.ly/closed...

[@b1chler]

Would be cool to see whats the best way to use authentication and authorization with next and prisma… :)

[@hamburger-fries]

Yes

[@neoesm]

YES

[@PoipoIgnix]

@@neoesm agree

[@trashAndNoStar]

Yes

[@jmula1963]

Magic Link maybe

[@nicolasguillenc]

Big thumbs up, this guy explains very well and his attitude is great while explaining

[@DeepTitanic]

He sounds like a private detective

[@tonyjaradev]

This guy should do all Prisma tutorials. Awesome.

[@JamesQQuick]

Great overview. Love this!

[@PrismaData]

Thanks James 🙌

[@Blue-bb9ro]

Huge thumbs up for this video, very concise, helped me A LOT with getting started with Prisma.

[@MaksymMinenko]

Thanks! This channel needs more videos like this one.

[@brandonleichty]

Thanks for the video! I'm curious if there is a "Prisma way" to add triggers to Postgres? Or do you just have to do it manually through raw SQL?

[@holodeck_run]

nothing specific that I know of. I was just looking for any docs we have but I can't find much. I believe right now it's just a manual task. Feel free to open an issue about it though, perhaps this is something that can be looked at in the future :)

[@brandonleichty]

Awesome! Thanks for the reply. I couldn’t find anything either. So I’ll open an issue up. 🙏

[@joncrowell9289]

Excellent video, Ryan. Thanks! At the ~7:45 mark, you mention a video that shows how to use a singleton rather than instantiating the Prisma Client in various places in the app. Can you post a link?

[@Gorlik1337]

Also me looking for this link

[@Gorlik1337]

@prisma

[@AnthonySchmittt]

I think this video from prisma can help : kzbin.info/www/bejne/l5rQaYChYqqHgZI

[@marlonfalconhdez]

Thank you for the video, you explains very well

[@PrismaData]

You are welcome! We're glad it was helpful! 💚

[@RamoFX]

Very interesting technology! Thanks!

[@seandurrant2877]

From a very new Nextjs developer, I would love to see a tutorial from the very beginning. This is a great video but there is too much code for me to really understand it. Don't get me wrong, I could copy and paste and get it working but to really learn, a tutorial from the very start would be great.

[@Norfeldt]

Very good and informative tutorial - I'm just sitting back and missing the last step of how to deploy it...

[@dunyan1586]

I need help on that too

[@cervece41]

Hi there Ryan, I have a quick question, I never used SQLite before so I'm not sure whether it's safe to push the dev.db file to a public repo or not, I love the idea of having a ligth db in the file system but I obviously don't want to expose my application's data. Thanks in advance!

[@CurtisUpshall]

The idea behind database migrations is to "rebuild" your database when you run them. So storing any kind of database file in version control is a bad idea, even if the data isn't confidential. Use migrations and seeders to rebuild the data, or opt for a hosted database. Of course, you can still use SQLite if you don't mind mainting the sqlite file locally.

[@BhriguSrivastava]

Great tutorial video. Very concise and to the point.

[@CaseStudyQB]

Whats the best way to learn how to model or design prisma 2 databases? I would like to see examples and / or tutorials on more complex databases. Thanks in advance

[@martiananomaly]

1:00 didn't know that. That's really cool.

[@babyfrank593]

Cuando ejecuto npx prisma studio obtengo este error "Error: spawn undefined\System32\WindowsPowerShell\v1.0\powershell ENOENT" me podría ayudar a solucionarlo gracias

[@myrez_]

6:43 I'm getting an error here when trying to import the { initialContacts }, I get "Binding element 'X' implicitly has an 'any' type." any help?

[@Balance-8]

Where is the link to the video you discussed at @7:45

[@holodeck_run]

Here it is: kzbin.info/www/bejne/qqSyeapoiZZ7rKs

[@TheLexuguin]

I'm following that approach github.com/prisma/prisma/issues/1983#issuecomment-869036852

[@PaulSebastianM]

13:05 that is a DTO for creating the actual model of Contact, to speak in software development parlance. :) But it is a simple generated type that probably looks identical to Contact itself. People might want to create their own DTOs so they can implement business logic like validation and such.

[@maskman4821]

pretty useful and practical tutorial !!!

[@mediacreatif]

react-hook-form updated to 7.0.0 from 6.X.X and has breaking changes

[@magimaartdeveloper7465]

Is this prisma thing an alternative to mongoose? and would it make sense to use mongoose and prisma on a single project using mongodb?

[@rahulbhardwaj4568]

This should be updated react-hook-form v7 has breaking changes!

[@daniellaerachannel]

Awesome!

[@HillelGarciaAustria]

Amazing video, just what I needed. Thanks! You've +1 subscriber

[@jamesnguyen868]

Hi Ryan, is there a support for multi-tenants based app?

[@bryson2662]

forgive my ignorance. If the api routes are run on the server, how are they "serverless functions"?

[@daniel2color]

The term Serverless functions is indeed confusing. In practice, it just means that you don't need a dedicated server. There's always going to be a server that actually runs the functions - they are just invisible to you.

[@buntikashyap7618]

Yes, I use Next js with Prisma and mysql database and it is good combination for full stack developer but I have an issue to deploy on hostinger as it pre installed the phpmyadmin or database but didn't know about how we deploy my next js project on this and how can I create the tables in database dynamicallly. (if you have any reference for me you can send me)

[@asiatip]

Thanks for your video, it helps me a lot. After everything is done, I have a question: can we deploy it to vercel directly with local ./dev.db. It seems not working.

[@dunyan1586]

same, how should we do it lol

[@jaicedecelis9949]

Hey Prisma! Just out of curiosity, what is your revenue generation model / how does prisma make its money? Looking to adopt something like prisma but want to make sure it will be around for a while!

[@PrismaData]

Prisma is open source and using it is free of any charge! In the future, Prisma will offer additional cloud services to facilitate various database- and Prisma-related workflows. Note that these will be optional, Prisma can continue to be used without consuming any commercial services.

[@burakcivan1219]

Thanks, good course for me :)

[@stvlley]

I wish i could like a video multiple time lol

[@ImaginativeWork]

Got anything for SQL Server with Windows Authentication?

[@YourChannelisAss]

is there a difference between prisma migrate dev and prisma generate?

[@elshir]

Hi there, why is this happening? Error: Error serializing .postsreturned fromgetStaticPropsin "/posts". Reason:object ("[object Promise]") cannot be serialized as JSON. Please only return JSON serializable data types.

[@holodeck_run]

looks like you have a page called "posts"? from the error, it looks like it could be that you're not awaiting something. if you're making a call to prisma to get data, be sure to await it so you can get the actual data result and not the pending promise.

[@elshir]

@@holodeck_run I'm pretty sure I am set it to await, but still get this error.

[@holodeck_run]

@@elshir hard to say from just the error message. if your code is in a repo where I can take a look, I might be able to find the issue.

[@elshir]

@@holodeck_run I got it, because of time.

[@mohamedel-moustafa3667]

Prisma best

[@thewetfly9207]

Have you any beautiful .prettierrc file for your style (without semicolon and align your model names) ? 😇

[@C0D3O]

how to configure prettier to format thing like that?? 3:50

[@palkollar7739]

This is amazing!

[@HugensLouis]

What is that icon theme?

[@sharkman8560]

Hi! How can I update database without erase data. For example I want to add new column.

[@leonardosimmons9658]

Just change whichever model(s) within the schema.primsa file and run npx prisma migrate dev. It will auto sync the new updated schema with your database. Don't forget to run prisma generate when you're finished to resync the database with @prisma/client

[@izio4408]

Does prisma support graphql? When will mongodb be ready?

[@PrismaData]

Hello there! To answer your questions: (1) Prisma and GraphQL fit together very well - Prisma is an ORM that is used inside of GraphQL resolvers to query a database. More info here: www.prisma.io/graphql (2) Prisma currently supports MongoDB in Preview and we plan to launch the GA support by the end of the year. More info here: www.prisma.io/blog/prisma-mongodb-preview-release

[@hyggedev2124]

How do I update the Schema so i can add a new model or change model fields?

[@MahmoudAbdelwahab]

Hey Chris! You can make changes to your schema and then use Prisma migrate so that the changes are reflected in your database 😄 Check out the docs here: www.prisma.io/docs/concepts/components/prisma-migrate

[@harryweisner4193]

Why have you styled your hair like a RawR Xd girl from the early 2000s? Great video thanks.

[@rahulsriram6295]

Hey what font is that?!

[@mahbubhasan8661]

I m using mongoose. I never use prisma before. Please upload tutorial how I can use authentication and authorization with next js and prisma in API route

[@PrismaData]

Check out this course which includes authentication and authorization with Next.js and Prisma: www.prisma.io/blog/fullstack-nextjs-graphql-prisma-oklidw1rhw

[@mahbubhasan8661]

@@PrismaData Thank you

[@naveensingh6459]

bro, i thought Sam Altman was going to teach us.

[@tirancm]

If you are going to use shared hostings, cpanel to host the app, do not use prisma. Prisma cannot work on ubuntu 20.04 at all. Its been lot of time. They have not fixed the issue.

[@nonefvnfvnjnjnjevjenjvonej3384]

Something which I hate is that often times there is a ease of use way of doing things which is different from the actual way of doing things like the singleton pattern of the client. I wish the library would just deal with it.

[@OMARKM]

what is Prisma and why should i use it ?!😅

[@City__Walker]

Prisma has a nasty surprise that Prisma developers don't give a damn about, when transferring a project from one development environment to another where there is no Internet, Prisma tries to download a new driver for its work, if you have tight security settings, consider that your project will not work. Because of this, I almost lost my job. Gentlemen, can you create an offline version for complex situations !!??

[@spectator5144]

please JS version

[@taggerung_]

now show us your middleware

[@taggerung_]

downvoted

[@SphinxHill]

一

[@BJ-ic5tj]

If I understand correctly, you have renamed @prisma/cli to just plain prisma. If that is correct, I am wondering why you changed the name. @prisma/cli is much more descriptive of what the package does then just plain prisma (particularly since there is still a @prisma/client package).

[@triTube70]

Hi Ryan, I'm following one of the examples from Prisma Github page and i just wanted to know what is the .author() does in these code, Thanks. author: (parent, _args, ctx) => { return ctx.prisma.post .findUnique({ where: { id: parent.id }, }) .author()