Server Side Pagination in Node.js Angular 10 + MySQL + Sequelize

In the tutorial, I introduce how to build an “Angular 10 Nodejs Pagination RestAPIs Example with MySQL database (Server Side Pagination with filtering and sorting)” project using Express framework and Sequelize crud queries to interact with database’s records.

– Nodejs Express project (server side pagination) produces pagination RestAPIs with MySQL database records using Sequelize CRUD queries.
– Angular 10 project (client side pagination) will consume the Node.js pagination RestAPIs then show up on component’s views.

Architecture Design Angular Node.js Application

In the tutorial “Server Side Pagination in Node.js Angular 10”, We develop 2 projects:

• Backend Project — Nodejs MySQL Pagination Application gets data from MySQL database then provides RestAPIs with pagination, filtering and sorting function for frontend
• Frontend Project — Angular Application use HttpClient to fetch data from Backend Application then shows them in Bootstrap table with pagination, filtering and sorting functions

Goal

– Make a request at API: /api/customers/pagefiltersort with pagination, filtering and sorting params as below:

• page: 0 – first page
• size: 5 – size of a page
• salary: 4000 – filtering by salary field
• agesorting: true – sorting by age
• desc: true – descending or ascending sorting

Sourcecode

loizenai/angular-10-server-side-pagination-in-node-js-angular

loizenai/server-side-pagination-in-node-js-angular-10

Tutorial Link

Server Side Pagination in Node.js Angular 10 + MySQL + Sequelize - loizenai.com