Tag: crud

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

bezkoder 137 Comments

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:
– Typescript: Node.js Typescript REST API with MySQL example
– Build Node.js Rest APIs with Express & MySQL (without Sequelize)
– Node.js: Upload/Import Excel file data into MySQL Database
– Node.js: Upload CSV file data into MySQL Database

Fullstack:
– Vue.js + Node.js + Express + MySQL example
– Vue.js + Node.js + Express + MongoDB example
– Angular 8 + Node.js Express + MySQL example
– Angular 10 + Node.js Express + MySQL example
– Angular 11 + Node.js Express + MySQL example
– Angular 12 + Node.js Express + MySQL example
– Angular 13 + Node.js Express + MySQL example
– Angular 14 + Node.js Express + MySQL example
– Angular 15 + Node.js Express + MySQL example
– Angular 16 + Node.js Express + MySQL example
– React + Node.js + Express + MySQL example
– React Redux + Node.js Express + MySQL example

Security: Node.js – JWT Authentication & Authorization example
Deployment:
– Deploying/Hosting Node.js app on Heroku with MySQL database
– Dockerize Node.js Express and MySQL example – Docker Compose

Read More

Angular 10 + Node.js Express + MySQL example: CRUD Application

bezkoder 3 Comments

In this tutorial, I will show you how to build a full-stack (Angular 10 + 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.

Other versions:
– Angular 8 + Node.js Express + MySQL example
– Angular 11 + Node.js Express + MySQL example
– Angular 12 + Node.js Express + MySQL example
– Angular 13 + Node.js Express + MySQL example
– Angular 14 + Node.js Express + MySQL example
– Angular 15 + Node.js Express + MySQL example
– Angular 16 + Node.js Express + MySQL example

Related Posts:
– Server side Pagination with Node.js and Angular
– Angular 10 + Node.js Express: JWT Authentication & Authorization example
– Angular 10 + Node.js Express: File Upload example

Run both projects in one place:
How to Integrate Angular 10 with Node.js Restful Services

Serverless with Firebase:
– Angular 10 Firebase CRUD Realtime Database
– Angular 10 Firestore CRUD with AngularFireStore

Read More

React Hooks Firestore example: Build a CRUD app

bezkoder

In this tutorial, I will show you step by step to build a React Hooks Firestore CRUD App example.

Related Posts:
– React Hooks CRUD with Firebase Realtime Database
– React Hooks CRUD example with Axios and Web API
– React Hooks: JWT Authentication (without Redux) example
– React Redux Login, Logout, Registration example with Hooks
– React Form Validation with Hooks example
– React Custom Hook tutorial with example

Read More

Spring Boot, Spring Data JPA – Rest CRUD API example

bezkoder 26 Comments

In this tutorial, we’re gonna build a Spring Boot Rest CRUD API example with Maven 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
  • How to check CRUD operations with Postman

More Practice:
– Validate Request Body in Spring Boot
– Spring Boot WebFlux Rest API example
– Spring Boot Thymeleaf CRUD example
– 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 Pagination and Sorting example
– Documentation: Spring Boot + Swagger 3 example (with OpenAPI 3)
– Caching: Spring Boot Redis Cache example

Associations:
– Spring Boot One To One example with JPA, Hibernate
– Spring Boot One To Many example with JPA, Hibernate
– Spring Boot Many to Many example with JPA, Hibernate

Fullstack:
– Vue + Spring Boot example
– Angular 8 + Spring Boot example
– Angular 10 + Spring Boot example
– Angular 11 + Spring Boot example
– Angular 12 + Spring Boot example
– Angular 13 + Spring Boot example
– Angular 14 + Spring Boot example
– Angular 15 + Spring Boot example
– React + Spring Boot example

Exception Handling:
– Spring Boot @ControllerAdvice & @ExceptionHandler example
– @RestControllerAdvice example in Spring Boot

Testing:
– Spring Boot Unit Test for JPA Repository
– Spring Boot Unit Test for Rest Controller

Deployment:
– Deploy Spring Boot App on AWS – Elastic Beanstalk
– Docker Compose: Spring Boot and MySQL example
– Docker Compose: Spring Boot and Postgres example

Read More

Angular 11 + Node.js Express + MySQL example: CRUD Application

bezkoder 2 Comments

In this tutorial, I will show you how to build a full-stack (Angular 11 + 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.

Other versions:
– Angular 8 + Node.js Express + MySQL example
– Angular 10 + Node.js Express + MySQL example
– Angular 12 + Node.js Express + MySQL example
– Angular 13 + Node.js Express + MySQL example
– Angular 14 + Node.js Express + MySQL example
– Angular 15 + Node.js Express + MySQL example
– Angular 16 + Node.js Express + MySQL example

Related Posts:
– Server side Pagination with Node.js and Angular
– File Upload using Angular 11 and Node.js
– Angular + Node.js Express: JWT Authentication & Authorization example

Run both projects in one place:
How to Integrate Angular with Node.js Restful Services

Serverless with Firebase:
– Angular 11 Firebase CRUD Realtime DB | AngularFireDatabase
– Angular 11 Firestore CRUD example | AngularFireStore

Read More