Back-End/Database Development: MySQL2 with TypeScript and Utility Functions | Free Course Preview

COVALENCE COMMUNITY MEMBERSHIP to get access to the course this video is from with all the 🔥 extra goodies in the curated course 🔥:

In this video, we'll be refactoring our previous code into a neat utility function. We will handle the connection handshake 🤝, execute a query 📝, and neatly close the connection, all in a few lines of code. You'll see how much cleaner and more manageable your code becomes. 🌟

We'll also be exploring the concept of 'Connection Pooling'. Wondering what that is? Connection pooling is a method used to manage multiple database connections at once, improving the efficiency of your application. It's a game-changer, and we'll show you exactly how to implement it! 🔥

Another major part of this walkthrough is TypeScript. We'll show you how to use mysql2 types to create your own interfaces representing table data rows. This will give you more control over your code and ensure the return types are correct, enhancing your development experience and the overall quality of your code. 👨‍💻

So if you're ready to add some advanced techniques to your back end development skillset, grab your code editor, a cup of coffee ☕, and let's get started!

Please give this video a thumbs up if you found it helpful, and don't forget to subscribe for more walkthroughs and tutorials. Let us know in the comments what you'd like to learn next!

#NodeJS #MySQL #TypeScript #ConnectionPooling #CodingTutorial #LearnToCode

[dennisjorgenson]

Wow. By far the best 41 minutes and 33 seconds spent - the first ORM-less, framework-less, Typescript/mySQL explanation yet. You rock! I've been working with TS/mySQL for two months now finding that retrofitting TS into my skillset painful at best. Mind blown! Thank you for your work - wish I would have stumbled across these vids 2 months ago!

[RamaGuptaOfficial]

Thank You, You are awesome. Don't stop making awesome videos!

[ThomasPoth]

Top, that was exactly what I was looking for today. Thanks for your great explanation. I left you a subscription and will check out your channel again soon. Do you go in your course even further on good practices, as shown in this approach here only for a professional environment applicable? Among other things, I would be very interested in the correct handling of stored procedures on both sides (TS <=> MySQL). Thank you very much for your work! .💯

[sdawdwadaufyuaiudi]

console.log(results[0].name); at 16:41 not work for me :Element implicitly has an 'any' type because expression of type '0' can't be used to index type 'QueryResult'.
Property '0' does not exist on type 'QueryResult'
may be typescript has update so this not allow

[mahmoudabdelhamed]

Thanks for the video :)
I have a question if you can help me, how I add "roles" to IUserRow where "roles" is a set? How the aggregation will be done to make the result fill in the set of the interface

[HimanshuGunwant-pd]

Can be suggest me how to add a logger in mysql2 so in development every action is logged with sql