Prisma

P

Prisma

The official Discord server of Prisma! Find us online at prisma.io

Join

[TypeError: The "payload" argument must be of type object. Received null]

I upgraded to next 15, now literally EVERY query throws this error. Heres my schema if it helps:...

Prisma initialization failing in prod Prisma Postgres

``⨯ Error [PrismaClientInitializationError]: Invalid prisma.user.findUnique() invocation: error: Error validating datasource db: the URL must start with the protocol postgresql:// or postgres://`....

Many to two relation

Hey, I have these model ``` model a { id String @id @default(cuid())...

postgress migration error

I'm following your instructions for migration (https://www.prisma.io/docs/getting-started/prisma-postgres/upgrade-from-early-access) for Windows. I set the env variable DATABASE_URL (with SET, export shows an error - set DATABASE_URL="prisma+postgres://accelerate.prisma-data.net/?api_key=ey..."). Once i set the variable i launch npx @prisma/ppg-tunnel --host 127.0.0.1 --port 5432 i receive the following error `PS C:\Users\MyPC> npx @prisma/ppg-tunnel --host 127.0.0.1 --port 5432 file:///C:/Users/MyPC/AppData/Local/npm-cache/_npx/cdc1c80c7d03f8e1/node_modules/@prisma/ppg-tunnel/dist/index.js:117...

Removed accelerate but keeps asking for database url that start swith prisma://

After I removed accelerate from my project, my live database keeps asking me for the prisma url string(related to accelerate). Nothing I am doing will overcome this. Has anyone else had this issue?

creating a BM25 index

I have created a BM25 index by creating a migration file to create it and also added the schema to ignore the index. ``` model Post { id Int @id @default(autoincrement())...

Is there a recommended way to create an aws lambda layer?

I'm bumping up to size limits on the layer. I have only 3 prisma packages in the layer and it already exceeds the limit. I've tried a few solutions before, but none have worked and basically just ended splitting each package into it's own layer, which is cumbersome to say the least side note: do we have a way to create one package for multiple databases? i assume that would reduce the size but i really have no idea...

Upgrade from Early Access

Hello, according to this article https://www.prisma.io/docs/getting-started/prisma-postgres/upgrade-from-early-access I have tried backup my data but on step: 1.3. Creating the Backup with pg_dump PGSSLMODE=disable ...
No description

why am I getting this error when trying to update 1 user and using null in where

```ts await db.user.update({ where: { id: user.id, username: null,...
No description

Prisma connect to Azure SQL database?

Does Prisma currently support connections to Azure SQL DB? We are planning of a NextJS project wherein data source which will be stored in Azure SQL. We are planning to sync the Azure SQL with an on-prem SQL Server.

env variable not found

I tried to setup prisma accelerate and here it cant get the Database_url from .env file. Is there any solution you know?😢 here is my code, the .env file, and console error...
No description

Two table fields are the same

When two table fields are the same, the type typescript generated after relation is lost

Issue with Prisma Pooling Timeout

Hello everyone, new poster here. I am pretty new to Prisma and have had no issues in recent months with it. Today my production server just started stating: ``` Rate limit check failed: Error [PrismaClientInitializationError]: 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: 3) at async n.checkRateLimit (.next/server/app/api/agents/create/route.js:1:4293) at async Object.authorize (.next/server/app/api/agents/create/route.js:1:5366)...

Can get prisma dev to align with production

- The migration 0_init was modified after it was applied. - Drift detected: Your database schema is not in sync with your migration history. The following is a summary of the differences between the expected database schema given your migrations files, and the actual schema of the database. ...

Prisma extented Request type

8 try { → 19 const newTour = await db.tour.create({ data: { name: "the new forest hikers", price: 299,...

PG extensions and database credentials

Hello team, I have 2 questions: 1) I added `generator client { provider = "prisma-client-js" previewFeatures = ["postgresqlExtensions"]...

prisma pulse + supabase?

Hi folks, I am experiencing an issue when trying to enable Pulse with my supabase-hosted postgresql db. I have configured the DB using the Prisma instructions from Supabase to create a bespoke Prisma user (see here - https://supabase.com/docs/guides/database/prisma) , and am using the direct connection string postgresql://prisma:<password>@<supabase-url>:5432/postgres - however I continue to run into an error when trying to enable Pulse. I have enabled accelerate without issue, so I know that th...

How can I get all fields from query that have been somehow accessed?

I need to know if they have been accessed read or write. It's not always so easy because there could be connect, composite keys in the query and so on. It's not always only the fields in data or where that have been accessed.

Prisma generate

I upgraded to prisma v6.3.0 and ran my prisma generate, then my vscode stopped picking the auto completion, what could i do

Prisma+nestjs

Respected sir, I have issues in supabase free tier as my db...added globle prisma module added every thing onModuleleInit and onModuleDestroy and disconnect.... But still facing idleconnction error.. prisma not killing idle connection.....i need to go to db and kill idle onne tions how to make prisma safe and scalable... Thanks 🥺 ,🥺🥺...
Next