# Prisma ORM with Node JS

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

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1720179362015/ad8c1ed2-1ed5-44b3-8fa5-523b3c664b0e.png)

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/](https://www.prisma.io/)  
Prisma is an [open-source](https://github.com/prisma/prisma) 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](https://www.prisma.io/docs/concepts/overview/prisma-in-your-stack/rest), a [GraphQL API](https://www.prisma.io/docs/concepts/overview/prisma-in-your-stack/graphql), a gRPC API, or anything else that needs a database.

[**Why Prisma? Comparison with SQL query builders & ORMs**  
*On this page, you'll learn about the motivation for Prisma and how it compares to other database tools like ORMs and…*www.prisma.io](https://www.prisma.io/docs/concepts/overview/why-prisma "https://www.prisma.io/docs/concepts/overview/why-prisma")[](https://www.prisma.io/docs/concepts/overview/why-prisma)

**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

<iframe src="https://www.youtube.com/embed/Mzu3u0CsEm4?list=PLIGDNOJWiL1_ygbYCizW9ORMazELD9foK" width="700" height="393" frameborder="0" scrolling="no"></iframe>

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

*   [https://www.prisma.io/docs/concepts/overview/what-is-prisma](https://www.prisma.io/docs/concepts/overview/what-is-prisma)
*   [https://www.prisma.io/docs/concepts](https://www.prisma.io/docs/concepts)
*   [https://www.prisma.io/client](https://www.prisma.io/client)
