Summary
Keywords
Full Transcript
🔥 Access Source Code, PPT & Notes here for Free : https://www.thapatechnical.com/2025/03/introduction-to-node.html 💸 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 ----------------------------------------------------------------------- In this video, we will integrate user authentication with the short links table using Drizzle ORM. We'll establish a foreign key relationship between users and short links, ensuring that each short link belongs to a specific user. You’ll learn how to: ✅ Connect the users table with the short links table ✅ Use foreign keys in Drizzle ORM ✅ Query only the short links created by the logged-in user ✅ Restrict access to the homepage for unauthenticated users ✅ Generate and apply Drizzle schema migrations ------------------------------------------------------------------------ 🚀 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 – Relating Users to Short Links Table ⏳ 0:40 – Connecting Users with Short Links ⏳ 0:55 – Showing Only User-Created Short Links After Login ⏳ 1:50 – Getting the Source Code ⏳ 2:20 – Connecting Users Table with Short Links Table ⏳ 3:00 – Adding Foreign Key Field in Short Links Table ⏳ 6:00 – Creating Relationship Between Users and Short Links ⏳ 8:30 – Creating Reverse Relationship (Short Links to Users) ⏳ 11:30 – Solving Schema Errors ⏳ 13:38 – Generating Drizzle Schema ⏳ 14:20 – Applying Schema Migrations ⏳ 15:30 – MySQL Query to Fetch Logged-in User’s Short Links ⏳ 18:00 – Query to Add User ID While Storing Short Links ⏳ 19:30 – Running the App for the First User ⏳ 20:50 – Logging in as a Second User & Viewing Their Short Links
