Overview of ORM Database Tools

Object Relational Mapping (ORM)

Summary

1. Concepts of ORM
2. Prisma ORM
3. Type ORM
4. Sequelize ORM
5. Micro ORM

References

1. Concepts of ORM

Object-Relational Mapping (ORM) is a technique that lets you query and manipulates data from a database using an object-oriented paradigm. When talking about ORM, most people are referring to a library that implements the Object-Relational Mapping technique, hence the phrase “an ORM”.

An ORM library is a completely ordinary library written in your language of choice that encapsulates the code needed to manipulate the data, so you don’t use SQL anymore; you interact directly with an object in the same language you’re using.

2. Prisma ORM

• https://www.prisma.io/

Postgres Installation with Docker

docker run --name postgresql -e POSTGRES_PASSWORD=admin -p 5432:5432 -d postgres

Prisma Migrate

yarn prisma migrate dev
create product
create category
create product_category

Prisma Studio

yarn prisma studio

Prisma Relations

HTTP/1.1 200 OK
X-Powered-By: Express
Content-Type: application/json; charset=utf-8
Content-Length: 150
ETag: W/"96-UrprlteTTnqfmSPc6+2Svgk22kw"
Date: Thu, 20 Jan 2022 17:45:34 GMT
Connection: close
{
"id": "70df8552-3b15-4532-ba10-084018283e17",
"id_product": "1d8da63e-c4dc-43e5-87b1-ddf1699dd7f1",
"id_category": "130b29d6-563b-4a73-8c2e-fe1c737ef99c"
}

Create a Product with Category

import { Request, Response } from "express";
import { prismaClient } from "../database/prismaClient";
export class CreateProductWithExistCategory {
async handle(request: Request, response: Response) {
const { name, price, bar_code, id_category } = request.body;
const product = await prismaClient.productCategory.create({
data: {
product: {
create: {
bar_code,
name,
price,
},
},
category: {
connect: {
id: id_category,
},
},
},
});
return response.json(product);
}
}

Demo Prisma Studio

prisma_decode/Prisma-demo.gif at master · Data-Database/prisma_decode

Demo Prisma Studio

Demo Prisma API

3. Type ORM

• https://typeorm.io/#/

4. Sequelize ORM

• https://sequelize.org/

5. Micro ORM

MikroORM: TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns…

References

• https://sequelize.org/
• https://mikro-orm.io/
• https://www.prisma.io/
• https://typeorm.io/