Prisma

P

Prisma

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

Join

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 πŸ₯Ί ,πŸ₯ΊπŸ₯Ί...

Billed for Prisma

Hi team, I was under the impression that during this early access phase Prisma Postgres was free on all plans, per this dialog on the pricing page. I just got billed $129 ($51 after some discount) - for the business plan....
No description

Prisma Studio Error

Hello guys, asking here because it's a bit urgent. I'm trying to connect ```ts...

read replicas extension

Hi, I would like to know if the read replicas extension is being supported and if so, if it's going to get an update to support prisma 6.2 Thanks...

Enum with custom value

Hi, does anyone know if it's possible to do this in Prisma :
CREATE TYPE "FileType" AS ENUM ('image/jpeg', 'image/png');
CREATE TYPE "FileType" AS ENUM ('image/jpeg', 'image/png');
Because I can't find a way to specify the enum values like this: ```typescript enum FileType { IMAGE_JPEG = "image/jpeg",...

getting data from prismaClient says field might be null when it literally isn't in the schema

i have this in my schema ```ts model products { id Int @id @default(autoincrement()) //some fields...
No description

Prisma Accelerate using >100 connections when configured to use 10

I have an application configured to use separate prisma accelerate and PostgreSQL clients. The PostgreSQL client connects to a Supavisor connection pooler. This is resulting in me running out of connections. Using select * from pg_stat_activity I see that there are >100 connections from Prisma Accelerate in state "idle" with wait_event "ClientRead". I have the connection limit set to 10 yet it is using 100 - not quite sure how that happens.