Node.js Rest APIs example with Express, Sequelize & MySQL

Express is one of the most popular web frameworks for Node.js that supports routing, middleware, view system… Sequelize is a promise-based Node.js ORM that supports the dialects for Postgres, MySQL, SQL Server… In this tutorial, I will show you step by step to build Node.js Restful CRUD API using Express, Sequelize with MySQL database.

You should install MySQL in your machine first. The installation instructions can be found at Official MySQL installation manual.

Related Posts:
Build Node.js Rest APIs with Express & MySQL (without Sequelize)
Deploying/Hosting Node.js app on Heroku with MySQL database

Vue.js + Node.js + Express + MySQL example
Vue.js + Node.js + Express + MongoDB example
Angular 8 + Node.js Express + MySQL example
React + Node.js + Express + MySQL example

Security: Node.js – JWT Authentication & Authorization example

Read More


Spring Boot, Spring Data JPA – Building Rest CRUD API example

In this tutorial, we’re gonna build a Spring Boot Rest CRUD API example that use Spring Data JPA to interact with MySQL/PostgreSQL database. You’ll know:

  • How to configure Spring Data, JPA, Hibernate to work with Database
  • How to define Data Models and Repository interfaces
  • Way to create Spring Rest Controller to process HTTP requests
  • Way to use Spring Data JPA to interact with PostgreSQL/MySQL Database

More Practice:
Secure Spring Boot App with Spring Security & JWT Authentication
Spring Boot Rest XML example – Web service with XML Response
Spring Boot + GraphQL + MySQL example
Spring Boot Multipart File upload example

Spring Boot + Vue.js example: Build a CRUD App
Angular 8 + Spring Boot example: Build a CRUD App
React + Spring Boot: CRUD example

Read More


Spring Boot + GraphQL + MySQL example with Spring JPA & graphql-spring-boot-starter

GraphQL is a query language that offers an alternative model to developing APIs (REST, SOAP or gRPC) with detailed description.

In this tutorial, we’re gonna build a Spring Boot GraphQL example that will expose CRUD Rest APIs to create, read, update and delete objects in MySQL database with the help of graphql-spring-boot-starter and Spring Data JPA.

Related Post: Spring Boot, Spring Data JPA – Building Rest CRUD API example

Read More


Node.js & JWT – Token Based Authentication & Authorization example

In this tutorial, we’re gonna build a Node.js Express Rest API example that supports Token Based Authentication with JSONWebToken (JWT). You’ll know:

  • Appropriate Flow for User Signup & User Login with JWT Authentication
  • Node.js Express Architecture with CORS, Authenticaton & Authorization middlewares & Sequelize
  • How to configure Express routes to work with JWT
  • How to define Data Models and association for Authentication and Authorization
  • Way to use Sequelize to interact with MySQL Database

Read More


Spring Boot + React + MySQL: CRUD example with REST APIs

In this tutorial, we will learn how to build a full stack Spring Boot + React.js + MySQL example with a CRUD App. The back-end server uses Spring Boot with Spring Web MVC for REST APIs and Spring Data JPA for interacting with MySQL/PostgreSQL database. Front-end side is made with React, React Router, Axios & Bootstrap.

Related Posts:
Spring Boot, React & MongoDB example: Build a CRUD Application
Spring Boot + React: Login example with JWT Authentication & Spring Security

Read More