Prisma ORM with Node JS

@tkssharma
@tkssharma
Published in
2 min readMar 16, 2022

Guys we will take a look at different ORM and ODM in the node js world to support database integration

What is Prisma ORM

Next-generation Node.js and TypeScript ORM

Prisma helps app developers build faster and make fewer errors with an open-source database toolkit for PostgreSQL, MySQL, SQL Server, SQLite, and MongoDB (Preview). from https://www.prisma.io/
Prisma is an open-source next-generation ORM. It consists of the following parts:

  • Prisma Client: Auto-generated and type-safe query builder for Node.js & TypeScript
  • Prisma Migrate: Migration system
  • Prisma Studio: GUI to view and edit data in your database

Prisma Client can be used in any Node.js (supported versions) or TypeScript backend application (including serverless applications and microservices). This can be a REST API, a GraphQL API, a gRPC API, or anything else that needs a database.

My honest opinion after using Prisma is Yes it is better and solving lot of issues which we face with other ORM like database migration managements, Prisma CLI, Prisma studio and Prisma client are powerful tools.

When it come to API development, There are many possible combinations to write APIs and to support the integration use ORM libraries like TypeORM, Sequelize, Prisma, Mongoose, etc

  • postgres- RDBMS
  • mongodb- NO SQL
  • mysql- RDBMS
  • neo4j — graph DB

In this playlist i have covered prism Integration with Node JS and different SQL and NoSQL databases like

  • express + prisma + postgres
  • express + prisma + mongodb
  • nestjs + prisma + postgres
  • nestjs + prisma + mongoose

We are starting with basics to advance application managing all different relationships in the RDBMS database

We have covered

  • managing migrations
  • setting up Prisma with node js apps express or nestjs
  • nestjs with Prisma Module and postgres database
  • Prisma client for managing integration apis

Reference

--

--

@tkssharma
@tkssharma

I’m Tarun.😎I help people to make a better world by good apps I am Publisher,Trainer Developer, working on Enterprise and open source Technologies tkssharma.com