Typescript ORM with MySQL example

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

Angular 16 + Spring Boot + MongoDB example: CRUD App

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

More Practice:
– Angular + Spring Boot: Pagination example
– Angular 16 + Spring Boot: JWT Authentication example
– Angular 16 + Spring Boot: File upload example

Read More

MEAN Stack example with Angular 16

In this tutorial, I will show you how to make Angular 16 connect to MongoDB with Node.js Express. We’re gonna build a MEAN stack CRUD example with Angular 16 + Node.js Express + MongoDB example in which, the back-end server uses Node.js + Express for REST APIs, front-end side is an Angular 16 App with HttpClient, Router and Bootstrap.

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

Security: Angular 16 + MongoDB: Auth with Node.js Express
Serverless with Firebase:
– Angular 16 Firebase CRUD example with Realtime DB
– Angular 16 Firestore CRUD example
Newer version: Angular 17 + MongoDB: Auth with Node.js Express

Read More