Tag: mysql

Angular 17 + Node.js Express + MySQL example: CRUD App

bezkoder

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

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

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

Serverless with Firebase:
– Angular 17 Firebase Database CRUD example
– Angular 17 Firestore CRUD example

Read More

Angular 17 + Spring Boot + MySQL: CRUD example

bezkoder

In this tutorial, we will learn how to build a full stack Angular 17 + Spring Boot + MySQL 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 database. Front-end side is made with Angular 17, HTTPClient, Router and Bootstrap 4.

Security: Angular 17+ Spring Boot: JWT Authentication example

Upload: Angular 17 + Spring Boot: File upload example

Pagination: Angular + Spring Boot: Pagination example

Read More

JPA @ManyToOne example | Spring Boot

bezkoder

In this tutorial, I will show you how to implement Spring Data JPA Many-to-One example in Spring Boot for One-To-Many mapping using @ManyToOne annotation. You’ll know:

  • How to configure Spring Data, JPA, Hibernate to work with Database
  • How to define Data Models and Repository interfaces for JPA One-To-Many relationship using @ManyToOne
  • Way to use Spring JPA to interact with Database for Many-to-One association
  • Way to create Spring Rest Controller to process HTTP requests

Related Posts:
– Spring Boot + GraphQL example
– JPA One To One example with Hibernate in Spring Boot
– JPA Many to Many example with Hibernate in Spring Boot
– Validate Request Body in Spring Boot
– Spring Boot Token based Authentication with Spring Security & JWT
– Spring JPA + H2 example
– Spring JPA + MySQL example
– Spring JPA + PostgreSQL example
– Spring JPA + Oracle example
– Spring JPA + SQL Server example
– Documentation: Spring Boot Swagger 3 example
– Caching: Spring Boot Redis Cache example

Read More

Node.js Typescript with MySQL example

bezkoder

In this tutorial, I will show you step by step to implement CRUD operations in Node.js Typescript with MySQL example using mysql2.

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

Working with following front-end:
– Angular 8 / Angular 10 / Angular 11 / Angular 12 / Angular 13 / Angular 14 / Angular 15 / Angular 16
– Vue 2 Typescript / Vue 3 Typescript
– React Typescript Component / React Typescript Hooks

Related Posts:
– Express Typescript example
– Typescript ORM with MySQL example
– Node.js: Upload/Import Excel file data into MySQL Database
– Node.js: Upload CSV file data into MySQL Database
– 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

Read More

Typescript ORM with MySQL example

bezkoder

Sequelize is a promise-based Node.js ORM that supports the dialects for Postgres, MySQL, SQL Server… Using an ORM can simplify database interactions, improve code maintainability, and speed up development by providing an object-oriented approach to working with relational databases. In this tutorial, I will show you step by step to implement CRUD operations using Typescript ORM with MySQL example.

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

Working with following front-end:
– Angular 8 / Angular 10 / Angular 11 / Angular 12 / Angular 13 / Angular 14 / Angular 15 / Angular 16
– Vue 2 Typescript / Vue 3 Typescript
– React Typescript Component / React Typescript Hooks

Related Posts:
– Express Typescript example
– Without Sequelize: Node.js Typescript Rest APIs with Express & MySQL
– Node.js: Upload/Import Excel file data into MySQL Database
– Node.js: Upload CSV file data into MySQL Database
– 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