Killer combo for building APIs, NodeJS, TypeScript and MySQL.

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.

In this tutorial, we are going to develop a simple REST API for an online store with Express framework. MySQL is our choice of database. Instead of using simple Javascript for the implementation, we decided to build this API using Typescript.

Typescript type support leaves little room for developers to misuse types. It helps us write cleaner, reusable code. If you are a beginner to Typescript or want to brush up your memory of the language, read our guide to  Typescript for Javascript developers before going to the next step.

With the initial introduction out of the way, let’s get started now.

---

Before we begin…

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.

Set up the database

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.

Data Model

#node #typescript