Hi, why is prisma when i run "prisma migrate dev" wanting to do a migration even though i did not change the prisma.schema file since last migration (when it was in sync) ? I get this in the migration file it generates:

-- RenameIndex
ALTER INDEX "Arbitrated_matchId_unique" RENAME TO "Arbitrated_matchId_key";

Using this model:

model Arbitrated {
    id         Int      @id @default(autoincrement())
    createdAt  DateTime @default(now())
    match      Match    @relation(fields: [matchId], references: [id])
    matchId    Int      @unique
    session_id String   @unique
    stats      Stat[]
}

The field

matchId

is clearly a @unique and not a @id?

Hi, I'm just switching to prisma after many years of SqlAlchemy. Things seem so easy in comparison. Why does SqlAlchemy need all the session handling stuff an prisma does not?

I'm a bit worried that I'm missing something. Murphey's Law of Databases: "all database problems only appear in production"

Hello! Quick question about database design. Im working on an app which has notes and those notes can have multiple tags. Additionally, every note belongs to a user. So for example a user can create a note called Hello World with tags foo and bar. For this design, should I create a

tags

table which holds a user id and label, and then a

NotesTagsJoinTable

which takes a note id and a tag id? Or should I go simpler and just have a

tags

table which holds the label, user id and note id?

I have several lists that share the same posts through a relation, so

posts.findMany

gets them all, but I also need to show them by list,

lists.findUnique({where: listId, include: posts})

This all works fine. I'm trying to implement a custom ordering of posts within each list, however. So

listId: 1

returns

postId: 1, postId: 2

and

listId: 2

returns

postId: 2, postId: 1

- this is over-simplified, but shows the behavior I'm after. I can't really store it on the

post

itself, as it's shared, so I think I may need to store it on the

list

but I'm not sure how it can be stored in a way that it can be sorted by. Any ideas how I can achieve this custom ordering of the same related data?

How can I use fragments in prisma 3 ? fragments were a part of prisma-bindings for v1, but I am unable to get docs for fragments for prisma v3

Hi Everyone, very new to Prisma. Just want to pick someones brain. I am using mongodb and trying to run a query that returns information from a relation:

const packages = await prisma.services.groupBy({
    by: ["product"],
    where: {
      Status: true,
    },
    _count: {
      product: true,
    },
  });

console.log("Packages", packages);

Results:

Packages [
  { _count: { product: 153 }, product: '5f147ee6770c7325aab150ce' },
  { _count: { product: 42 }, product: '5f147edd770c7325aab150cd' },
  { _count: { product: 80 }, product: '5f147f00770c7325aab150d0' },
  { _count: { product: 4 }, product: '5f147ecb770c7325aab150cc' },
  { _count: { product: 5 }, product: '5f147f0d770c7325aab150d1' },
  { _count: { product: 157 }, product: '5f147ef3770c7325aab150cf' }
]

The product value returns the

id

instead of the actual record from related document / table. Is there a way to return the documents for

products

in the same prisma query?

set the channel topic: General Discussions about Prisma [Looking for Prisma 1? Join the #prisma1 channel!] ✅ = Answered 👀 = Investigating / waiting for info 👋 = Welcome!

Hello, I am trying to delete like thousands of records/data/rows using deleteMany , but it turns out that causing some kind of error or problem (I guess because of deleting too many data at once). Is there any recommendation on how to delete thousands of data without causing application performance?

Thank you

I'm having two projects that share the same schema file and only differ in the generator used. Is there a way to decouple the generator from the schema file?

Is it impossible to do upsert on one-to-many relation ships when when i have a unique constraint? Schema:

model UserHash {
    user     User     @relation(fields: [userId], references: [id])
    userId   Int
    platform Platform @default(PC)
    hash     String

    @@id(fields: [userId, platform])
    @@unique(fields: [platform, hash])
}

Error:

Invalid `prisma.userHash.upsert()` invocation:


  An operation failed because it depends on one or more records that were required but not found. No 'User' record(s) (needed to inline the relation on 'UserHash' record(s)) was found for a nested connect on one-to-many relation 'UserToUserHash'.

Please how do I set

bio

to

not null

model Profile {
  id      Int   @id @default(autoincrement())
  bio     String   @db.Text
  city    String   @db.VarChar(255)
}

Where can I get examples of graphql inputs for prisma generated inputs and dto????

hi is it possible to introspect a psql

COMMENT

as a comment in the prisma schema?

Hey, We are performing load test before going live and observed one thing that after one iteration it takes around

18 minutes

to release active connection. • can someone guide or explain this behavior? • According to me once query is executed, it should release connection Note: Using 3.14.0 version

Hi! Is there any indication of when the postgresql fulltextsearch will move out of Preview mode?

Hello! @Nurul I am storing number value as string inside the DB '123' Now I want to apply filtering on this column

Hello guys, is there way to say prisma throw error when try to update unique row, but row not exist? Like when try to find unique row with rejectOnNotFound flag

Hello, it takes a lot of time to do RDS (AWS) INSERT on prisma2. It is a situation in which data is put into other tables using include inside prisma2. Once you do INSERT, you get a long request time of 7 to 14 seconds. In order to solve this problem, would it be better to refrain from using prisma include and INSERT one by one with different logic? 🙏(The database load is quite low)

Does Prisma support ULID? https://github.com/ulid

👉 What's new in Prisma (v3.15.0) -- -- Tasin and Alex from the Prisma team discuss the latest 3.15.0 release of Prisma and other news from the Prisma ecosystem.

has anyone implemented polymorphic relations in prisma?

hey all — using prisma+seed and having trouble including the

schema.prisma

in the .zip package generated we’re using

packages.individually=true

,

packages.pattern=./schema.prisma

. Using those, the output is like:

lambda.zip

expanded: • schema.prisma • subfolder/ ◦ sub subfolder/ ▪︎ index.js ▪︎ index.js.map and I get an error that

schema.prisma

isn’t found in

sub subfolder

. any way to include that

schema.prisma

file down there/does anyone know what the best way to include

.prisma

files is here? we’re using

serverless-esbuild

+ seed

is there a specific way to get the ping of the DB using prisma? or the only way is just getting a document

is it possible for me to specify a custom location and file name for

.env

file instead of what is mentioned here. some way to provide the updated dotenv config path to the prisma client. something like this:

dotenv.config({
  path: path.resolve('./my/custom/env/config/path'),
});

what is the difference of

{some-property: {equals: some-data}} to {some-property: some-data}

which is better?

👋 Hello, I am new to Prisma. Looking forward to integrate it into our backend. I have a technical question about using Prisma in a Kubernetes-based setup, where should I ask that? 😃

hellot, i'm new to prisma and i have question it is possible to nested relation query with upsert ? somehting like this :

const updateUser = await prisma.cibest_user.upsert({
          where: {
            email: props.email,
          },
          update:{
            tokens:{
                //date_updated: new Date()
                type_token: props.type_token
                
            }
          },
          create:{
            tokens : {
                type_token : props.type_token,
                refresh_token: accessToken.refreshToken,
                valid: true,
                expiration: expiration,
            }
          }
        });