Next-generation ORM
for Node.js and TypeScript
- Quickstart - https://www.prisma.io/docs/getting-started/quickstart-node
- Sequelize와 비교 - https://www.prisma.io/docs/concepts/more/comparisons/prisma-and-sequelize
- Prisma Client API reference
- Client - https://www.prisma.io/client
- Migrate - https://www.prisma.io/migrate
- Studio - https://www.prisma.io/studio
1. Command
npm install prisma --save-dev
prisma init
prisma db pull
prisma generate2. Raw Query
await prisma.$executeRaw`SELECT 1`;
3. Mono-repo
모노리포 + 워크스페이스별 Database를 구성할 경우 project의 @prisma/client를 참조하면 문제가 생기기에 workspace별로 client를 따로 생성해 주어야한다. 그리고 생성된 파일은 ignore.
schema.prismagenerator client { provider = "prisma-client-js" output = "../gen/client" }- code
const { PrismaClient } = require('../gen/client');
