MySQL is undoubtedly one of the top picks for a relational database in every Node developer’s technology stack. Node’s ease of creating backend APIs paired with MySQL’s ability to support complex query operations provides a simple way for developers to build advanced web backends.
With the initial introduction out of the way, let’s get started now.
Before we begin the tutorial, make sure you have all the tools we need set up. Assuming you already have Node.js installed, install MySQL on your device before continuing.
As I mentioned before, we are creating an API for a simple online store that stores a list of products and registered customers in its database. When customers place product orders, their details are also stored in this database.
In total, our database schema has 3 tables: Product, Customer, and ProductOrder.
In this post your guide to building a NodeJS, TypeScript Rest API with MySQL. MySQL is undoubtedly one of the top picks for a relational database in every Node developer’s technology stack.