Summary
Keywords
Full Transcript
In this video, we dive deep into Drizzle ORM and MySQL to build a fully dynamic project from scratch! ๐ก Whether you're a beginner or an experienced developer, this tutorial will simplify database interactions using Drizzle ORMโa lightweight and type-safe alternative to Prisma. ๐ป What you'll learn? โ How to set up Drizzle ORM with MySQL โ Creating tables and managing database operations โ Writing controllers for database interactions โ Implementing short link management with Drizzle โ Displaying data dynamically in the UI โ Debugging and fixing errors ๐ธ Get All My YouTube Videos' Source Code for just โน249! Grab Now - https://thapatechnical.shop/source-code ๐ฅ Access Source Code, PPT & Notes here for Free : https://github.com/thapatechnical/urlshortener ๐บ Watch the complete Node.JS Playlist here :https://youtube.com/playlist?list=PLwGdqUZWnOp3KELplHtc-RnJ5xTUPqdgH&si=_ob8F88HYxCdspup ------------------------------------------------------------------------ ๐ 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 - Dynamic project with Drizzle ORM ๐ 0:40 - Free source code link ๐ ๏ธ 0:55 - What is Drizzle Studio? ๐ 2:10 - Cloning our project code ๐ 3:50 - Installing Drizzle and MySQL2 ๐ 5:00 - Connecting to MySQL database ๐ 8:50 - Creating tables using Drizzle ORM โ๏ธ 11:10 - Drizzle config file creation ๐ 12:30 - Scripts in package.json file ๐ 15:10 - Overview of the controller file ๐ 16:55 - getAllShortLinks function to fetch data ๐ 21:30 - Checking if the shortcode exists in the DB ๐ 24:50 - Inserting data into the database ๐ 27:00 - Redirect logic and verification ๐ ๏ธ 28:10 - Running the code & debugging errors ๐ฅ๏ธ 31:00 - Displaying data dynamically in UI ๐ฌ 33:00 - Outro
