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

In this tutorial, I will show you how to build a full-stack (Angular 8 + Node.js + Express + PostgreSQL) 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 + PostgreSQL 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-postgresql-crud-architecture

– Node.js Express exports REST APIs & interacts with PostgreSQL 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.

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-postgresql-server-project-structure

db.config.js exports configuring parameters for PostgreSQL connection & Sequelize.
Express web server in server.js where we configure CORS, initialize & run Express REST APIs.
– Next, we add configuration for PostgreSQL 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 Express & PostgreSQL: CRUD Rest APIs example with Sequelize

Angular 8 Front-end

Overview

angular-node-express-postgresql-crud-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-postgresql-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 + PostgreSQL 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!

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

  1. Hi, Im newbie in Angular and in this kinds of stuff. Just wondering what would be the final folder structure of the project? I mean how to I connect the front-end to the back-end.

    1. Hi, you only need to run both with instruction in the tutorials. 🙂
      – Backend: port 8080
      – Frontend: port 8081

      Then open browser with url: http://localhost:8081/

  2. I think you have a typo in your server.js file (in both gitHub and the tutorial)…

    This: require(“./app/routes/turorial.routes”)(app);
    Should be this: require(“./app/routes/tutorial.routes”)(app);

    It’s a small thing, but got a few errors that I had to muddle through..

    Great tutorial though… Still working through it all

  3. Thank you so much. I test every bit of the project . It worked very well for me. I appreciate your Tutorial class. Hoping you could recommend an advanced one for me to lay my hands on.

Leave a Reply

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