Prisma Client does not yet support batch inserts at a database level. Follow issue #332 on GitHub for updates.

createMany

PRISMA_SKIP_POSTINSTALL_GENERATE=1

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

const countTags = await ctx.prisma.tag.findMany({
    select: {
      name: true,
      _count: {
        select: {
          questions: true,
        },
      },
    },
  });

model Question {
  id        Int      @id @default(autoincrement())
  title     String
  content   String
  tags      Tag[]
}

model Tag {
  id   Int    @id @default(autoincrement())
  name String @unique
  questions Question[]
}

collectionLogBank          Json     @default("{}") @db.Json

@@index([collectionLogBank], map: "cl_jsonb")

orderBy = [
 {
   timestamp: 'desc',
 },
 {
   score: {value: 'desc'},
 },
]

npm install -g npm@8.1.4

docker-compose

model Comment {
  id        Int       @id @default(autoincrement())
  createdAt DateTime  @default(now()) @map("created_at")
  updatedAt DateTime  @updatedAt @map("updated_at")
  content   String
  author    User      @relation(fields: [authorId], references: [id])
  authorId  Int       @map("author_id")
  post      Post      @relation(fields: [postId], references: [id])
  postId    Int       @map("post_id")
  parent    Comment?  @relation("CommentToComment", fields: [parentId], references: [id])
  parentId  Int?      @map("parent_id")
  replies   Comment[] @relation("CommentToComment")

  @@map("comments")
}

type Comment {
  id: Int!
  createdAt: DateTime!
  updatedAt: DateTime!
  content: String!
  author: User!
  post: Post!
  parent: Comment
  replies: [Comment!]
}

npx prisma db pull

model User {
    id          String @id
    ownership   Ownership[]
}

model Ownership {
     id    String @id @default(cuid())
     user        User? @relation(fields: [userId], references: [id])
     userId      String
     createdAt   DateTime @default(now())
}

prisma.user.findUnique({
      where: {
        id: userId,
      },
      include: {
      ownership: {
      take: 1,
      orderBy: {
        createdAt: 'desc',
      },
    },
  },
})

user.ownership

ownership

result.ownership = result.ownership[0];

Module not found: Can't resolve '_http_common' in '/opt/build/repo/node_modules/@prisma/client/runtime'

import prismaClientPkg from '@prisma/client';
const PrismaClient = prismaClientPkg.PrismaClient;

ERROR  ServerMiddleware Error: Cannot read property 'PrismaClient' of undefined