Build MySQL Node.js CRUD App #1: Setting Up

Hello and welcome to the first article of Let’s Build a MySQL Node.js CRUD App series. In this series, we shall build a beginner-friendly simple CRUD (Create, Read, Update, Delete) app with MySQL and Node.js. If you are a beginner in MySQL and Node.js, I encourage you to follow along and build the app with me!

Before we start, here’s a brief overview of what to expect from this series.

The Project

We will be building a simple book reviewer app. You can add, view, edit and delete reviews in this app.

Technologies we’ll use

• React for front-end
• Node and express for back-end
• MySQL for database
• POSTman to test our routes

Recommended Prerequisites

• Basic understanding of React and JavaScript
• Basic understanding of what back-end programming is
• Basic understanding of SQL (Structured Query Language) and relational databases
• Visual Studio Code or any code editor installed on machine

Step 1: Install Node.js