React Redux & MySQL: CRUD example with Node.js Express

In this tutorial, I will show you how to build React Redux + MySQL CRUD example with Node.js Express server for REST APIs. Front-end side uses React Router, Axios & Bootstrap.

Full Article: https://bezkoder.com/react-redux-mysql-crud/

React Redux + MySQL CRUD example Overview

We will build a full-stack Tutorial Application in that:

• Tutorial has id, title, description, published status.
• User can create, retrieve, update, delete Tutorials.
• There is a search box for finding Tutorials by title.

Here are screenshots of the example.

• Add a Tutorial:

• Show all tutorials:

– Click on Edit button to view details of an item:

On this Page, you can:

• change status to Published/Pending using Publish/UnPublished button
• remove the object from MySQL Database using Delete button
• update this object's details on Database with Update button

• Search objects by field 'title':

• Check MySQL database:

• Check Redux state with Dev-tool:

React Redux + MySQL CRUD example Architecture

We're gonna build the application with following architecture:

– Node.js Express exports REST APIs & interacts with MySQL Database using Sequelize ORM.
– React Client sends HTTP Requests and retrieves HTTP Responses using Axios, consume data on Redux which provides state to the Components. React Router is used for navigating to pages.

React Redux Front-end

Overview

This is React components that we're gonna implement:

– The App component is a container with React Router. It has navbar that links to routes paths.

– Three components that dispatch actions to Redux Thunk Middleware which uses TutorialDataService to call Rest API.

• TutorialsList component gets and displays Tutorials.
• Tutorial component has form for editing Tutorial's details based on :id.
• AddTutorial component has form for submission new Tutorial.

– TutorialDataService uses axios to make HTTP requests and receive responses.

This diagram shows how Redux elements work in our React Application:

We're gonna create Redux store for storing tutorials data. Other React Components will work with the Store via dispatching an action.

The reducer will take the action and return new state.

Project Structure

• package.json contains main modules: react, react-router-dom, react-redux, redux, redux-thunk, axios & bootstrap.
• App is the container that has Router & navbar.
• There are 3 components: TutorialsList, Tutorial, AddTutorial.
• http-common.js initializes axios with HTTP base Url and headers.
• TutorialDataService has methods for sending HTTP requests to the Apis.
• .env configures port for this React CRUD App.

About Redux elements that we're gonna use:

• actions folder contains the action creator (tutorials.js for CRUD operations and searching).
• reducers folder contains the reducer (tutorials.js) which updates the application state corresponding to dispatched action.

Node.js Express Back-end

Overview

These are APIs that Node.js Express App will export:

Methods	Urls	Actions
GET	api/tutorials	get all Tutorials
GET	api/tutorials/:id	get Tutorial by id
POST	api/tutorials	add new Tutorial
PUT	api/tutorials/:id	update Tutorial by id
DELETE	api/tutorials/:id	remove Tutorial by id
DELETE	api/tutorials	remove all Tutorials
GET	api/tutorials?title=[kw]	find all Tutorials which title contains 'kw'

Project Structure

• db.config.js exports configuring parameters for MySQL connection & Sequelize.
• Express web server in server.js where we configure CORS, initialize & run Express REST APIs.
• Next, we add configuration for MySQL database in models/index.js, create Sequelize data model in models/tutorial.model.js.
• Tutorial controller in controllers.
• Routes for handling all CRUD operations (including custom finder) in tutorial.routes.js.

For step by step and Github, please visit:
https://bezkoder.com/react-redux-mysql-crud/

Further Reading

• React + Node.js Express: User Authentication with JWT example
• React File Upload with Axios and Progress Bar to Rest API
• Front-end without Redux:
  • Using React Components
  • Using React Hooks
  • Using React with Material UI

Run both projects in one place:
How to integrate React with Node.js Express on same Server/Port

Dockerize:

• Docker Compose React + Node.js Express + MongoDB example
• Docker Compose React + Node.js Express + MySQL example