Build a Dynamic Project with Prisma, MySQL & Express

Build a Dynamic Project with Prisma, MySQL & Express

T
Thapa Technical
Feb 8, 2025

Learn how to build a URL Shortener using Prisma ORM, MySQL, and Express.js! 🔥 In this hands-on tutorial, we’ll cover everything from setting up Prisma, connecting it to MySQL, creating tables, and performing database operations to handling errors and debugging with Prisma Studio. By the end, you’ll have a fully functional URL shortener project ready to deploy!

💸 Get All My YouTube Videos' Source Code for just ₹249! Grab Now - https://thapatechnical.shop/source-code

📺 Watch the complete Node.JS Playlist here :https://youtube.com/playlist?list=PLwGdqUZWnOp3KELplHtc-RnJ5xTUPqdgH&si=_ob8F88HYxCdspup

🔥 Access Source Code, PPT & Notes here for Free : https://www.thapatechnical.com/2024/11/introduction-to-nodejs.html
------------------------------------------------------------------------
🚀 Boost Your Skills with these Pre-Requisite Videos:

🔗 Best HTML Course - https://youtu.be/5ccq_nLHneE
🔗 Best CSS Course - https://youtu.be/MSICFljRcb4
🔗 JavaScript Basics Course Part 1 - https://youtu.be/13gLB6hDHR8
🔗 JavaScript Advanced Course Part 2 - https://youtu.be/YwsOCN8woA8

------------------------------------------------------------------------
💸 Build Your Own E-commerce Website for Free! - https://www.thapatechnical.com/2024/03/build-complete-ecommerce-website-using.html

------------------------------------------------------------------------
✌️ Join Us!

🚀 Become a Member: Unlock perks, free source code, and more Join Now : https://www.youtube.com/channel/UCwfaAHy4zQUb2APNOGXUCCA/join
📷 Connect on Instagram: https://www.instagram.com/thapatechnical
🗨️ Join Our Discord Server: Hang out with fellow programmers Discord Link: https://discord.gg/MdScmCsua6

------------------------------------------------------------------------

⌛TIMELINE⏳
0:00 – Intro to Prisma Project
1:02 – Installing Prisma in Our Express App
2:05 – Initializing Prisma
3:05 – Connecting Prisma to MySQL Database
4:30 – Creating a Table in Prisma
6:05 – Generating Prisma Schema & Files
8:20 – Implementing Prisma in Our URL Shortener Project
10:50 – Using Prisma Client to Query Database
11:40 – Fetching All URLs from Database
12:40 – Checking If Shortcode Exists Using Prisma
15:30 – Inserting User URL Data with Prisma
18:00 – Handling Errors & Debugging
20:20 – Using Prisma Studio to Check Database Entries