👉 What's new in Prisma (v3.14.0) -- -- Niko and Sabin from the Prisma team discuss the latest 3.14.0 release of Prisma and other news from the Prisma ecosystem.

GraphQLError: Timed out fetching a new connection from the connection pool. More info: http://pris.ly/d/connection-pool (Current connection pool timeout: 10, connection limit: 30)

Has anyone seen this error before? We’re currently being haunted by it, and have tried tweaking connection limits/timeouts/adding pgbouncer/throttling concurrent DB access/nearly everything we can think of and no success 🥲

Any way yet to store

decimal

in the database without using floats or returning a Decimal.js instance? I just want to store pricing information, but floats can be unprecise and Decimal.js objects are a hassle to work with

Hi guys! Prisma doesn't pick up when I make changes like so:

model Author {
...
post Post?
}

// to

model Author {
...
post Post[]
}

I know I should also pluralise the relation field to

posts

but is this normal behaviour?

I’m seeing a common @prisma/client install error:

Error: Cannot find module '@prisma/client'

I’m using the commands:

npx prisma migrate reset --preview-feature

npx prisma migrate dev --name init --preview-feature

npx prisma generate

wow excited about the postgres improvements! thanks yall!

Is anyone else having an issue with

COUNT

in the improved raw queries? It seems to be throwing with this message:

Int cannot represent non-integer value: 0

(Note that the 0 in this case is the count, but I get the same error with other values)

Ah, it’s coming back as a

bidint

. This is an Apollo issue.

How can I create a GIN index for a sub-property of a JSON column?

CREATE INDEX ON table_name((column_name->>'json_prop')) USING GIN (column_name);
--                                      ^ looking for this behavior

How can I order by a variable in a raw query?

const order = 'last_name ASC, first_name ASC';

await prisma.$queryRaw`SELECT *
                       FROM users
                       ORDER BY ${order}`;

I'm getting this error `Raw query failed. Code:

1008

. Message: `The SELECT item identified by the ORDER BY number 1 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.`` Using SQL Server

Hello ! How to create relation if not exist ? My code :

await this.client.modlogsService.createModlogs({
            user: {
                connect: {
                    userId: user.id
                }
            },
            type: "WARN",
            date: new Date(),
            moderator: interaction.user.tag,
            reason: reason
        });

I want to create the user (

user

) if not exist

I'm trying to model a referral table for my Postgres database. Not sure if the db schema is correct, but I have a table with a

referId

, `userId`: 1 to 1, and `referredUserId`: 1 to many. model Referral { id Int @id @default(autoincrement()) createdAt DateTime @default(now()) updatedAt DateTime @default(now()) referId String // Auto Generate Random String userId Int @unique user User @relation(fields: [userId], references: [id]) referredUsersId Int[] referredUsers User[] @relation(fields: [referredUsersId], references: [id]) } I'm not sure exactly how to reference these in the User model. I tried Referral Referral? UsersReferred Referral[] But I get an error

Error validating model "User": Ambiguous relation detected

What's the correct way to model a referral table and how can I do it in prisma?

Hi, I have a schema akin to this. I have a need where I need to fetch all posts by

id

of the user as well as the

uuid

.

model User {
  id    Int    @id @default(autoincrement())
  uuid  String @default(cuid())
  posts Post[]
}

model Post {
  id       Int  @id @default(autoincrement())
  author   User @relation(fields: [authorId], references: [id])
  authorId Int
}

I get all the posts by authorId by this. How can I do something similar also with UUID?

const event = await prisma.posts.findMany({
    where: {
      authorId: 1
    }
  });

👋 Hello, team!, nice to be here

I have however come with an inquiry

error - Error: @prisma/client did not initialize yet. Please run "prisma generate" and try to import it again.
In case this error is unexpected for you, please report it in <https://github.com/prisma/prisma/issues>

is an error am getting in a nextjs app, but i dont know it

Hey guys! Is there any update/ETA on the BigInt issues in Prisma Studio? Our team has been storing BigInts as strings because of the

queryRaw

issues and the Prisma Studio bugs - now that

queryRaw

is fixed, we're just waiting on these 😅 https://github.com/prisma/studio/issues/816

Hey! 👋 How do you normally store analytics data that is not consistent in a database? I'm using postgres and have a model that is also not consistent (it has a

config

json for the frontend). I want to track analytics (button clicks, hovers, views) of the elements. Would I store it as simple JSON in the model field called

analytics

for example? Can updates collide when incrementing a count for example? I would love to hear your feedback on this because I want to have it in the same database (no separate service beside the postgres database). 🙂

Hi all, I am just trying Prisma but coming from Laravel I am having a bit of difficulty with the seeder. My database is sqlite.

I have this error for title, description, and price: (property) title: string Type 'string' is not assignable to type 'never'

const customerData: Prisma.CustomerCreateInput[] = [
    {
        name: 'Alice',
        surname: 'Kaperi',
        email: '<mailto:alice@prisma.io|alice@prisma.io>',
        products: {
            create: [
                {
                    title: 'Apples',
                    description: 'These are juicy apples',
                    price: 12.5,
                },
            ],
        },
    },
]

my schema has the following:

model Customer {
  id    Int     @id @default(autoincrement())
  email String  @unique
  name  String?
  surname  String?
  phone  String?
  code String  @unique
  total_sale Float
  total_quantity Int
  points Int
  address  String

  products Product[]  

  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model Product {
  id            Int      @id @default(autoincrement())
  title         String
  description   String?
  size          String?
  qty           Int?  @default(0)
  cost          Float
  price         Float
  upc           Int
  reorder_point Int
  manufactuerer String
  last_received DateTime @default(now())
  picture       String
  customer    Customer?    @relation(fields: [customerId], references: [id])
  customerId  Int?
  department    Department?    @relation(fields: [departmentId], references: [id])
  departmentId  Int?
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

Announcing Prisma Day 2022! Our First Hybrid Prisma Day. Join us June 15th and 16th as we showcase the amazing work that’s happening throughout the data and application development space. Our first hybrid Prisma Day will take place in Berlin and online!

Is it possible to distinguish in the

rejectOnNotFound

to which of the provided where conditions makes the query return

null

? (see screenshot with code)

Hi there, I was wondering if someone could clarify what the correct ENV is to specify the download mirror for the Prisma Engines: https://www.prisma.io/docs/reference/api-reference/environment-variables-reference#prisma_engines_mirror

I keep getting db error could not determine data type of parameter $1 when i use the same SQL code (without the javascript injection) using my DATAGRIP program, it works. im not sure why im getting this error with prisma

await prisma.$queryRawUnsafe`UPDATE table SET template_json_data = jsonb_set(template_json_data, '{namingConvention}', '"${String(req.body.projectName)}"', false) WHERE save_id = ${Number(req.body.saveId)}`;

hello. I have a question. Why use transaction to one insert or update?? For example,

await this.prismaService.customer.create({
            data: {
                name: 'hello',
                email: '<mailto:ltnscp9028@gmail.com|ltnscp9028@gmail.com>',
                password: 'password',
            },
        });

Code create this query.

How can I turn off these messages?

Hello @Nurul I implemented the prisma orm with nexus and paljs But we have too many prisma models and due to that nexus take 5 minutes to compile So it is a global issue so I did something wrong on my end

Hi I'm trying

improvedQueryRaw

and it works localy, but on Vercel it shows

ERROR	Error: error: The preview feature "improvedQueryRaw" is not known

. Is there any case possible for 3.14 cannot recognize this flag?

Regarding prisma 3.14 and MongoDB: I'm trying to get embedded documents working with mongodb, using prisma 3.14 and the structure according to the schema provided in the release notes of prisma 3.10 ( https://github.com/prisma/prisma/releases/tag/3.10.0 ). Running a query against the db I get an error telling me

type EmailMessage { .... error: Model declarations have to be indicated with the `model` keyword`

same error also for EmailSubject my schema:

model Email {
  id            String @id @map("_id") @db.ObjectId
  name          String @unique
  emailMessage  EmailMessage
  emailSubject  EmailSubject
  receiverGroup Receiver[]
  isActivated   Boolean @default(value: true)
  role          String
  btnName       String
}

type EmailMessage {
  id        String
  messageDe String
  messageEn String
}

type EmailSubject {
  id        String
  subjectDe String
  subjectEn String
}

type Receiver {
  id        String
  email     String
  firstName String
  lastName  String
}

What am I doing wrong regarding these embedded documents ? Is there support for embedded document lists but not for embedded documents ?

Hello all, we use a nodejs prisma backend hosted on Heroku. When we perform certain queries, that involve nested queries on child tables, we lose connection to the database ("Can't reach database server"):

"Can't reach database server at `<http://ec2-3-68-54-65.eu-central-1.compute.amazonaws.com|ec2-3-68-54-65.eu-central-1.compute.amazonaws.com>`:`5432`
Please make sure your database server is running at `<http://ec2-3-68-54-65.eu-central-1.compute.amazonaws.com|ec2-3-68-54-65.eu-central-1.compute.amazonaws.com>`:`5432`.
\",\"stack\":\"Error: Can't reach database server at `<http://ec2-3-68-54-65.eu-central-1.compute.amazonaws.com|ec2-3-68-54-65.eu-central-1.compute.amazonaws.com>`:`5432`
Please make sure your database server is running at `<http://ec2-3-68-54-65.eu-central-1.compute.amazonaws.com|ec2-3-68-54-65.eu-central-1.compute.amazonaws.com>`:`5432`.
at Object.request (/app/node_modules/@prisma/client/runtime/index.js:45629:15)
at async PrismaClient._request (/app/node_modules/@prisma/client/runtime/index.js:46456:18)
at async getDataFromNestedQuery (/app/src/api/v3/nestedqueryendpoint/controller.js:228:24)\"}}"

1. When checking the backend-logs we noticed that Prisma runs a nested query instead of a JOIN query (a similar issue is mentioned in https://github.com/seromenho/prisma-join-performance). Can we change the generated queries to a JOIN query? Anybody faced a similar issue? 2. Does setting the

connection_limit=1

help? Unfortunately in heroku we are unable to append it to the DATABASE_URL variable. Does anybody have experience with this?