Angular 8 + Node.js Express + MySQL example: Build CRUD Application

In this tutorial, I will show you how to build a full-stack (Angular 8 + Node.js + Express + MySQL) example with a CRUD Application. The back-end server uses Node.js + Express for REST APIs, front-end side is an Angular App with HTTPClient.

More Practice: Node.js Express + Angular 8: JWT Authentication & Authorization example


Angular + Node.js + Express + MySQL example

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 an object:

angular-crud-app-create

– Retrieve all Tutorials:

angular-crud-app-retrieve-all

– Click on Edit button to update a Tutorial:

angular-crud-app-update

On this Page, you can:

  • change status to Published using Publish button
  • delete the Tutorial using Delete button
  • update the Tutorial details with Update button

– Search Tutorials by title:

angular-crud-app-search

Full-stack CRUD App Architecture

We’re gonna build the application with following architecture:

angular-node-express-mysql-crud-example-architecture

– Node.js Express exports REST APIs & interacts with MySQL Database using Sequelize ORM.
– Angular Client sends HTTP Requests and retrieves HTTP Responses using HTTPClient, consume data on the components. Angular Router is used for navigating to pages.

Video

This is our Angular 8 Node.js Express Sequelize application demo and brief instruction, running with MySQL database:

Node.js Express Back-end

Overview

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

MethodsUrlsActions
GETapi/tutorialsget all Tutorials
GETapi/tutorials/:idget Tutorial by id
POSTapi/tutorialsadd new Tutorial
PUTapi/tutorials/:idupdate Tutorial by id
DELETEapi/tutorials/:idremove Tutorial by id
DELETEapi/tutorialsremove all Tutorials
GETapi/tutorials?title=[kw]find all Tutorials which title contains 'kw'

Project Structure

angular-node-js-express-sequelize-mysql-example-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.

Implementation

You can find step by step to implement this Node.js Express App in the post:
Node.js Rest APIs example with Express, Sequelize & MySQL

Angular 8 Front-end

Overview

angular-node-express-mysql-crud-example-front-end-overview

– The App component is a container with router-outlet. It has navbar that links to routes paths via routerLink.

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.

– These Components call TutorialService methods which use Angular HTTPClient to make HTTP requests and receive responses.

Project Structure

angular-node-js-express-sequelize-mysql-example-angular-project-structure

– There are 3 components: tutorials-list, tutorial-details, add-tutorial.
tutorial.service has methods for sending HTTP requests to the Apis.
app-routing.module.ts defines routes for each component.
app component contains router view and navigation bar.
app.module.ts declares Angular components and import necessary modules.

Implementation

You can find step by step to implement this Angular App in the post:
Angular 8 CRUD Application example with Web API

Newer version: Angular 10 CRUD Application example with Web API

Conclusion

Now we have an overview of Angular 8 + Node.js Express + MySQL example when building a full-stack CRUD App.

We also take a look at client-server architecture for REST API using Express & Sequelize ORM, as well as Angular 8 project structure for building a front-end app to make HTTP requests and consume responses.

Next tutorials show you more details about how to implement the system:
Back-end
– Front-end:

Happy learning, see you again!

7 thoughts to “Angular 8 + Node.js Express + MySQL example: Build CRUD Application”

  1. I loved this crud application.
    It will be great if you provide the source code on git.
    Please its a request.

    Thanks a lot in advance 🙂

      1. Where in conclusion, sorry but coudnt find, can anybody please post a link of git source code.
        It will be very helpful

Leave a Reply

Your email address will not be published. Required fields are marked *