Luca Del Puppo - Senior Software Engineer

Prisma the ORM that node was waiting for

Luca Del Puppo

Senior Software Engineer
Javascript enthusiast
Typescript lover
“Youtuber”
“Writer”

Love sport: running, hiking

Love animals

What is it?

Prisma is an open source next-generation ORM. (Node eco-system)

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

Control

Productivity

Orm

Plain SQL

SQL Builder

Prisma

Healty Constraint

Providers

PostgreSQL
MySQL
SQLite

Microsoft SQL Server
MongoDB
CockroachDB

Hey Bro!

Could you talk about interesting stuff?

Image by catalyststuff on Freepik

CLI

$ npm install prisma

Install CLI

npx prisma init --datasource-provider PostgreSQL

Create Project

Prisma File

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

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

CLI commands

init
generate
migrate

Data Modelling

Schema

One file (schema.prisma)
- Data sources
- Generators
- Data model definition
Syntax - PSL (Prisma Schema Language)

N.B. Multiple Files is not supported yet

Generator & DataSource

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

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

Models

model Ingredient {
  id Int @id @default(autoincrement())
  name String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  pizzaIngredients PizzaIngredient[]

  @@map("INGREDIENTS")
}

Relations

model PizzaIngredient {
  ingredientId Int
  pizzaId Int
  ingredient Ingredient @relation(fields: [ingredientId], references: [id])
  pizza Pizza @relation(fields: [pizzaId], references: [id])

  @@id([pizzaId, ingredientId])

  @@map("PIZZA_INGREDIENTS")
}

Generation

$ npx prisma generate

Generation

What does it generate?

Models
- Convert Models to Typescript Types
Client
Query Models (type safe)
- Constraint to build where clause
- Constraint to build select
- Constraint to build insert/update/delete with relation

Generated Type

export type Ingredient = {
  id: number
  name: string
  createdAt: Date
  updatedAt: Date
}

Client

$ npm install @prisma/client

Installation

What does it generate?

const prisma = new PrismaClient();
await prisma.$connect();

const pizza = await prisma.pizza.findUnique({
 where: {
   id: id,
 },
 include: {
      pizzaIngredients: {
      include: {
        ingredient: true,
      },
    },
  },
});