Prisma: Next-generation Node.js and TypeScript ORM

A presentation by Marvin Witt

🤔 What is Prisma?

  • Prisma is a database toolkit for Node.js and TypeScript
  • It is a next-generation ORM (Object-Relational Mapper)
  • It simplifies database workflows and allows for easy data management
  • It supports various database systems such as MySQL, PostgreSQL, and MongoDB
  • It features a powerful query engine and flexible data modeling

🤔 Why Prisma instead of raw SQL?

  • Prisma is a modern ORM designed for Node.js and TypeScript
  • Offers powerful query engine and flexible data modeling
  • Integrates seamlessly with GraphQL
  • Strong developer community and ecosystem
  • Popular choice among developers

🧐 Prisma vs. Raw SQL

Feature Prisma Raw SQL
Model definition Yes N/A
Type-safe queries Yes No
Query building Yes No
Relationship mapping Yes No
Database migration Yes No
Transaction support Yes Yes
Connection pooling Yes Yes
Performance High High
Ease of use High Low
Integration with serverless APIs Good Good

🧐 Prisma vs. Query Builders

Feature Prisma Query Builders
Model definition Yes Yes
Type-safe queries Yes No
Query building Yes Yes
Relationship mapping Yes No
Database migration Yes No
Transaction support Yes Yes
Connection pooling Yes Yes
Performance High High
Ease of use High Medium
Integration with serverless APIs Good Good

📝 The Prisma Schema

  • The Prisma schema is the single source of truth for your database schema
  • It is used to generate the Prisma Client API
  • It is written in the Prisma schema language (.prisma)

📝 The Prisma Schema: 💾 Datasource

Datasource

📝 The Prisma Schema: 📦 Generator

Generator

📝 The Prisma Schema: 🧵 Models & Relations

Model & Relations

📦 The Prisma Client API

  • The Prisma Client API is generated from the Prisma schema
  • It is a type-safe database client
  • It is used to perform database operations
  • It is used to perform CRUD operations

📦 The Prisma Client API: 🔍 Find Many

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

const prisma = new PrismaClient();

const allUsers = await prisma.user.findMany();
console.log(allUsers);

📦 The Prisma Client API: 🔍 Find Many

Output:

[
  {
    "id": 1,
    "name": "Alice",
    "email": "alice@prisma.io",
    "posts": [
      {
        "id": 1,
        "title": "Join the Prisma Slack",
        "content": "https://slack.prisma.io",
        "published": true,
        "authorId": 1
      }
    ]
  }
]

📦 The Prisma Client API: 🪡 Find One

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

const prisma = new PrismaClient();

const user = await prisma.user.findUnique({
  where: {
    email: "alice@prisma.io",
  },
});

console.log(user);

📦 The Prisma Client API: 🪡 Find One

Output:

{
  "id": 1,
  "name": "Alice",
  "email": "alice@prisma.io",
  "posts": [
    {
      "id": 1,
      "title": "Join the Prisma Slack",
      "content": "https://slack.prisma.io",
      "published": true,
      "authorId": 1
    }
  ]
}

📦 The Prisma Client API: ➕ Create

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

const prisma = new PrismaClient();

const newUser = await prisma.user.create({
  data: {
    name: "Bob",
    email: "bob@prisma.io",
  },
});

console.log(newUser);

📦 The Prisma Client API: ➕ Create

Output:

{
  "id": 2,
  "name": "Bob",
  "email": "bob@prisma.io"
}

📦 The Prisma Client API: 🔁 Update

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

const prisma = new PrismaClient();

const updatedPost = await prisma.post.update({
  where: {
    id: 1,
  },
  data: {
    published: false,
  },
});

console.log(updatedPost);

📦 The Prisma Client API: 🔁 Update

Output:

{
  "id": 1,
  "title": "Join the Prisma Slack",
  "content": "https://slack.prisma.io",
  "published": false,
  "authorId": 1
}

📦 The Prisma Client API: 🚮 Delete

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

const prisma = new PrismaClient();

const deletedUser = await prisma.user.delete({
  where: {
    id: 1,
  },
});

console.log(deletedUser);

📦 The Prisma Client API: 🚮 Delete

Output:

{
  "id": 1,
  "name": "Alice",
  "email": "alice@prisma.io"
}

📦 The Prisma Client API: 🪹 Nested Writes

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

const prisma = new PrismaClient();

const newUser = await prisma.user.create({
  data: {
    name: "Bob",
    email: "bob@prisma.io",
    posts: {
      create: [
        {
          title: "Follow Prisma on Twitter",
          content: "https://twitter.com/prisma",
          published: true,
        },
        {
          title: "Follow Prisma on GitHub",
          content: "https://github.com/prisma",
          published: true,
        },
      ],
    },
  },
});

console.log(newUser);

📦 The Prisma Client API: 🪹 Nested Writes

Output:

{
  "id": 2,
  "name": "Bob",
  "email": "bob@prisma.io",
  "posts": [
    {
      "id": 2,
      "title": "Follow Prisma on Twitter",
      "content": "https://twitter.com/prisma",
      "published": true,
      "authorId": 2
    },
    {
      "id": 3,
      "title": "Follow Prisma on GitHub",
      "content": "https://github.com/prisma",
      "published": true
    }
  ]
}

📦 The Prisma Client API: 🪹 Nested Writes

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

const prisma = new PrismaClient();

const updatedUser = await prisma.user.update({
  where: {
    id: 2,
  },
  data: {
    posts: {
      update: [
        {
          where: {
            id: 2,
          },
          data: {
            published: false,
          },
        },
      ],
      delete: [
        {
          id: 3,
        },
      ],
    },
  },
});

console.log(updatedUser);

📦 The Prisma Client API: 🪹 Nested Writes

Output:

{
  "id": 2,
  "name": "Bob",
  "email": "bob@prisma.io",
  "posts": [
    {
      "id": 2,
      "title": "Follow Prisma on Twitter",
      "content": "https://twitter.com/prisma",
      "published": false,
      "authorId": 2
    }
  ]
}

Thank you for your attention! 🙏

Got any questions? 🤔 Feel free to ask away! 🙌

You can also find the slides of this presentation at prisma.nurmarv.in!