Use Prisma and forget SQL (Beginner Tutorial)

[@SimonHoiberg]

Great tutorial!

[@lucarestagno]

Thanks Simon! 🙌 Is the format good enough? I'm always willing to improve my content.

[@TheCeomaverick]

excellent tutorial. thanks

[@lucarestagno]

I am glad you liked it Avinash! If there's anything you'd like to learn, please let me now 🙌

[@ahmed_5g]

can you add firebase integration it's still the most popular database solution and more stable than supabase and easier to use + you will attract a new market of firebase user's

[@lucarestagno]

Hey there! Prisma can be used with many SQL based databases like Postgres, MySQL, SQL Sever and others, and with MongoDB. Firestore is a different kind of realtime database and there’s a dedicated JavaScript SDK so you’ll not need Prisma at all : ) I use DigitalOcean managed Postgres database, so no need to use Supabase : )

[@ainarsk]

Would you use Prisma for Mongo? I have a project where NoSQL would be better fit.

[@lucarestagno]

hey @ainarsk I've never used Prisma with MongoDB, but I have friends who did that, and it seems to be working well. You can get a bit more control over the data you read and write to MongDB, with types. So yes, I would use it!

[@md.redwanhossain6288]

Use Drizzle and thank me later. Drizzle is almost 4 times faster than prisma.

[@lucarestagno]

Do you watch videos about Prisma just to comment to use Drizzle? 😄 Prisma is very comfortable to use and the performance is absolutely fine.

[@nikolasburk]

Nikolas from Prisma here :) Out of curiosity, where do you get this claim from? If you're referring to the Drizzle benchmarks on their site, please check out the PRs in the benchmark repo. We found that it uses a defective Preview feature of Prisma ORM which causes the huge difference in performance in the results. If you replace this broken Preview feature with a raw query (as we recommend in our docs), you end up with similar performance of Prisma and Drizzle.

[@JohnBuildWebsites]

Wait what? The title of this is a bit jarring, and the total opposite of what I would normally recommend. I can only agree with others that have already commented about Drizzle being a better option in 2024, mainly as it is closer to SQL, which a decent dev really should aim to get comfortable with, while still having a great DX of an ORM like Prisma.

[@lucarestagno]

Thanks for your comment. This video is for people willing to learn Prisma, and maybe not completely comfortable with using SQL. And it is not intended to say that Prisma is better than other solutions.

[@JohnBuildWebsites]

@@lucarestagno It is likely a great video for that purpose, but that is not really what the title says or implies. I understand the need for click-baity titles to get views, but I think this one is misjudged (and I think the comments probably highlight this ). Video looks good otherwise, and I wish you luck going forward!

[@lucarestagno]

@@JohnBuildWebsites thanks! I don’t think the title is misleading, since with Prisma you can basically get rid of using SQL to create tables, and CRUD operations. I updated the title to remove 2024 and include tutorial for beginners. Thanks for the feedback.

[@alvinsmith7892]

prisma is super slow, performance is very bad

[@lucarestagno]

I’ve been using prisma for years and never had performance issues. Especially with the latest versions, the performance have been improved a lot. The problem might be somewhere else.

[@nikolasburk]

Hey there, Nikolas from Prisma here! We've invested a lot in performance recently and would love to learn about any cases where you still find Prisma ORM to be too slow for your application so that we can fix these! Don't hesitate to open an issue :)