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
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.
[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")
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
