node-js-express-sequelize-mysql-example-feature-image

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)
Node.js: Upload/Import Excel file data into MySQL Database

Fullstack:
Vue.js + Node.js + Express + MySQL example
Vue.js + Node.js + Express + MongoDB example
Angular + Node.js Express + MySQL example
React + Node.js + Express + MySQL example

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

Read More

spring-boot-vue-js-crud-example-feature-image

[Full-stack] Spring Boot + Vue.js: CRUD example

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

Related Posts:
Spring Boot + Vue.js: Authentication with JWT & Spring Security Example
Spring Boot + Vue.js + MongoDB: CRUD example

More Practice: Vue + Spring Boot: File Upload example

Read More

spring-boot-data-jpa-crud-example-feature-image

Spring Boot, Spring Data JPA – Rest CRUD API example

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

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 Pagination & Filter example | Spring JPA, Pageable

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

Handle Exception:
Spring Boot @ControllerAdvice & @ExceptionHandler example

Testing: Spring Boot Unit Test for JPA Repositiory with @DataJpaTest

Deployment: Deploy Spring Boot App on AWS – Elastic Beanstalk

Read More

spring-boot-download-excel-file-mysql-feature-image

Spring Boot: Download Excel file from MySQL database table

The Excel file is a spreadsheet file format created by Microsoft for use with Microsoft Excel. You can use the file to create, view, edit, analyse data, charts, budgets and more. In this tutorial, I will show you how to use Spring Boot to download Excel file from a table in MySQL Database using Apache POI.

Related Posts:
Spring Boot: Upload/Import Excel file data into MySQL Database
Spring Boot Multipart File upload example
How to upload multiple files in Java Spring Boot
Upload/Import CSV file to MySQL Database in Spring Boot

Read More