PostgreSQLIntermediate

Prisma — schema-driven ORM

Postgres ORM — schema file → type-safe client।

5টি অংশবাংলা ভাষায়

terminalbash

bash

npm install prisma @prisma/client
npx prisma init

prisma/schema.prismaprisma

prisma

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

model Product {
  id    Int     @id @default(autoincrement())
  name  String  @unique
  price Decimal
  qty   Int     @default(0)
  items OrderItem[]
}

usagets

import { PrismaClient } from "@prisma/client";

const prisma = new PrismaClient();

const products = await prisma.product.findMany({
  where: { qty: { gt: 0 } },
  orderBy: { price: "desc" },
  take: 10,
});

schema.prisma-ই single source of truth
npx prisma generate → type-safe client
Prisma query → SQL (raw-lite via $queryRaw)

Prisma learn-generation

Prisma-র query API-র transaction, include, relation loading সুবিধা — তবে raw SQL-এর power বোঝা থাকলে Prisma মনে আরো সহজ।

শেষ প্যারায় নিজে practice করুন — কোড কপি করে নিজের এডিটরে চালিয়ে দেখুন।