Prisma Crash Course

Let's look at Prisma, which is a Node.js & TypeScript ORM & toolkit to interact with your database.
Written Version:
www.traversymedia.com/blog/pr...
Check Out My Courses:
traversymedia.com
Timestamps:
0:00 - Intro & What Is Prisma?
5:30 - What Is Data Modeling?
6:28 - Getting Started
9:38 - The Schema File
10:36 - User Model
12:29 - Article Model
14:13 - Running Migrations
15:45 - Using The Prisma Client
16:18 - main() Function
18:00 - Create a User
19:40 - Get Users
20:44 - Create Article & Relate User
23:16 - Create User & Article With One Query
27:59 - Loop Through Users & Articles
31:30 - Update Data
32:37 - Remove Data
34:23 - Prisma Studio GUI

[@PrismaData]

Thank you for creating this! Prisma is committed to enhancing the developer experience in data-related work. Courses like this one contribute to expanding our community, which, in turn, empowers us to craft even more effective tools for all of you. Your efforts are truly outstanding! ❤

[@arogueotaku]

Hey @PrismaDev. I have heard a lot of buzz around a certain article pointing out flaws with the current Prisma ORM architecture and how it does its interactions with the DB starting with shipping multiple heavy engines to not supporting native foreign key relations and rather using some kind of emulated ones and a few more performance affecting issues which ultimately made my shy away from it. Are there any truth to those claims and are those being looked into actively?

[@akhil_sarikonda]

@@arogueotaku the article you are talking about is written by codedamn team members, and they know their stuff well. Most of the major performance issues were tackled in the Prisma v5.x.x releases and there is no real reason to not use Prisma in Sep 2023.

[@nikolasburk]

@@arogueotaku Hey there 👋 I'm Nikolas from the Prisma team!
Prisma ORM indeed is based on engine files that are written in Rust, we have an entire page about this in our docs that explains the architecture. The query engine runs as a side-car process on the server where you deploy your application with Prisma ORM. While I can see how this is a different approach compared to other ORMs, I wouldn't consider it a "flaw" in the architecture. As a developer you won't even notice that the engine files exist, the only situation to be aware of them is sometimes during deployment (e.g. when you deploy to Serverless or Edge, in these cases you can check the deployment guides in our docs).
I can't follow the claim about "emulating foreign key relations", sorry! Prisma ORM definitely supports foreign keys and uses them by default for any relations in your Prisma schema. When you define a relation in the schema, Prisma Migrate generates a SQL migration file for you (which you can also customize) that defines a FK between the two tables that have the relation in your Prisma schema. Does this help or otherwise can you maybe elaborate on what exactly you heard? Can you maybe also share where you have heard that so that we can correct the record there as well?
Finally, I would definitely always recommend to try out tools yourself instead of "shying away" from them just because of some claims you have heard on the internet 🙂 Prisma ORM is being used very successfully by a plethora of companies (you can check them out on our /showcase page), it's the default ORM for upcoming web frameworks and dev tools like RedwoodJS (founded by GitHub's co-founder), Amplication (recently raised a $6.6M seed round), Wasp Lang (YC W21), KeystoneJS, create-t3-app, Blitz as well as most the official Remix stacks.
Hope this helps! If you ever have any questions, don't hesitate to reach out! You can find us on Twitter, GitHub and Discord and we're always happy to help 😄

[@ubitubee]

@@arogueotakuradio silence… 😢

[@nikolasburk]

Hey there @@ubitubee 👋I had responded to the comment already but it needed to get approved. It now seems to be visible so you can read my reaction to the claims of @arogueotaku now 🙏

[@ead5590]

This is amazing! I'd learnedPrisma through their docs about a year ago, which is really easy to follow and I had it hooked to the Planet Scale DB. It worked effortlessly! This tutorial just adds to all of the awesomeness. 😆 Thanks to Brad and Prisma! ✌🏻

[@cloudagnostic]

There’s a reason you have 2 million subs! Very informative and top tier tutorial. Thanks Brad!

[@gyongxichen]

you damn right!

[@MarkusEicher70]

Thank you, Brad. Short, concise and informative. The usual high standard we all are enjoying from you. 🤛

[@ricardocnn]

Wow man, I'm studying PostgreSQL, it was exactly what I was going to start studying to implement in my apps. Thanks!

[@mehrdara6545]

Thank you Brad every time I want to learn something new you are my first goto youtube channel

[@shlomominkowicz65]

Hey Brad, Excellent video as always!! Clear, strait to the point. It's like breath of fresh air. On the other note, you mentioned re-doing your Next.js course. When could we expect that :)

[@johndanieldecastro7024]

Thank you Brad! You're carrying my dev journey

[@ricardocnn]

it's so much simple and more straightforward than firebase functions. It's Amazing!

[@kajalmishra6895]

Wow❕ Brad you read my mind. This is exactly what I need for my project.

[@binayakgshankar9188]

Thanks a ton for this. following your videos since 2016, learned a lot from you.

[@talleyrand9530]

Good job Brad. You add accessibility to new tech and that’s awesome.

[@matthewclarke1926]

ORM was a wishful dream of mine once. Ultimately, it is my opinion that you just need to get good at SQL. The time you spend trying to learn the ORM interface and hacking it to get it to do what you want is better spent learning SQL. 10 years from now your knowledge of a particular ORM interface will be worthless and your SQL knowledge will be valuable. Regardless, thanks for posting. I love your videos.

[@iancarr3923]

Have you tried Blazor? The sql can be generated code first (from the models). .Net 8 sounds good.

[@claudespeed13579]

This 100% market-dependant. You could have said the same about React ten years ago: “knowing pure JavaScript is more valuable!” But in truth you can’t really know how ubiquitous ORMs will or will not be in the long run.

[@matthewclarke1926]

@@claudespeed13579 React will fall to Vanilla JS.

[@LaminarRainbow]

Yes! Traversy Media did a Prisma video!
Thank you!!

[@ramioooz]

Thank you very much for sharing such high-quality educational material. Your lessons are always very clear and straightforward. Thank you 🌻

[@ramonmaximiliano3557]

as usual, you are the best!

[@theophilus494]

see boss! you are a blessing.. thanks so much!!!

[@GilAguilar]

Sweet thanks for sharing Brad 🤟💙☕️

[@rodrigojulianmartin7092]

Thanks, this video was great and straight to the point! Super effective. I will subscribe and check other videos from you!

[@r-i-ch]

Thanks Brad! I'd love to see this with Drizzle.

[@genovo]

Very clear. One observation: at 24:35 we added "articles" to the user Sara, but made it an object, not an array like in the User model? It worked with SQLite. It's possible to add multiple articles with a user.

[@aliissa1058]

You are the best! Thank you

[@mahmudbakale8190]

Thank you, so much Brad, you've always been my go to whenever am trying to checkout new stuff in my development journey, but i dont know if can help with a video on Sequilize ORM, thank you once again

[@SandeepSingh-ye5fh]

Thanks for sharing valuable videos ❤

[@irfansaeedkhan7242]

thank you its great for getting started

[@changNoi1337]

Thanks from Germany!

[@Odidi_Bee6ix]

Spot on.
Thanks buddy

[@RABWA333]

Great effort, thanks alot

[@alikisang827]

You're a hero, I have developed my own company as your own student, much love Brother 🙏. Come to Kenya vacation I will host you ❤❤

[@collinskiprono2450]

Can you employ me in your company 😁, I'm also Kenyan

[@MelodyBeats.]

Hindi sayo hindi akin KENYA

[@fidelotieno2409]

Thanks for your time sir💯💪

[@Salah-YT]

thank u so much 😍👍

[@gyongxichen]

thank you it really helps❤

[@aburaihan-py4vi]

Excellent!

[@ar-swe]

really awesome love you

[@ronydas5474]

Interesting ❤

[@Omar-Tood]

Thanks brad❤

[@philippearras8154]

Thanks a lot !
I have a question about your courses : are the vidéos downloadable if I want for exemple to watch them offline ?
Thank you in avance for your answer.

[@mahmodsamir5110]

thank you so much

[@feelchi1star]

This is really educative.
Can the models in schema.prisma be split into separate files to enhance code readability? Just mongoose ORM.

[@umitcelik5508]

Prisma will save us from sequelize. Finally!

[@rollinsshadrack8768]

This is amaizing. Can you make one on how to use prisma with Knexjs?

[@guyrandalf711]

You're so great Brad.❤
I have an issue when I want to update my tables. The whole database just clears off and resets.
I am using Supabase, but I use prisma to push migrations. Now I want to update an enum(even though I do this in the database table directly, it doesn't affect the project). So I edited the prisma models.
How do I add to the enum without actually deleting the database information?

[@Grishopping]

Thanks for the video, you have gained a new subscriber.... What is the possibility of releasing a video with more advanced queries, transactions, etc...
Greetings Jose Grillo from Venezuela

[@Blacken997]

How do you choose between using Prisma and Knex?

[@frankylopez4477]

Thanks

[@j_s_bxpert6160]

Thanks sir

[@amn3siacx]

What VScode Theme is that, I really like it, share your setup pls, thanks!

[@marktaylor865]

I may have missed it but this didn't show how you might use it in a project. Do I just need the includes at the top of any file I'm doing database actions in? Do I need to make a function call for each query as I need it of should I be dragging in all the data I need at the top of the file? I mean prisma looks great but I still can't use it..

[@arunsuthar4783]

We want full next js course with typescript

[@olaleyeoyewunmi6978]

Yes please with mongodb

[@shlomominkowicz65]

Yes please!! with postgres

[@caseyspaulding]

Hell yes

[@Lavinvlog]

Please make a tutorial on remix

[@esdegan7176]

G R A P H C O O L
V 3

[@jeanssmith5864]

❤❤

[@DontFollowZim]

Have you been using it for a while? Have you felt noticeable perf gains after the big update? Have you tried it in an edge runtime environment?

[@kitebeachinnbeachinn2888]

Theres a competitor called: DrizzleORM please take a look as well.

[@nisargjaiswal4264]

Awesome, now its time for Drizzle 🙃

[@mistart1633]

Prisma !== Production is true

[@parkerrex]

[@_itsmeKHawaR]

Make a course on iOS development.. 23:38

[@shayantriedcoding]

If possible, develop a crash course on Laravel Blade and some useful UI libraries (not Breeze), sir please 🥺🙏.

[@shayantriedcoding]

@@memberwhen22 Thanks sir 🙏👍

[@melanatedthought7014]

I swear to the lord christ, I was looking for a crash course on Prisma...can you do one for dribble

[@olatuborafelix7875]

Most you swear 😅😅😅

[@starlord7526]

Jesus be like: wtf, when did this happen

[@PavanKatepalli-fb4ly]

active record is still so much better

[@MrLuckfinder]

Hello my friend!
Why do you forbid access to your site for users from Russia?
Does any russian offend you?

[@Franck_Polla]

thank you very much