Prisma

Join the Prisma server to ask questions!

Prisma

Join the community to ask questions about Prisma and get answers from other members.

2/6/2025

Latency to/from US-east <-> US-east and Denmark <-> Paris

Really struggling with long latency for my queries - are these numbers what I can expect from your hosted Postgres solution ? (Thx. for the ORM btw - really awesome). I am currently assessing your hosted solution and on paper it looks great, but I am really struggling with large latencies. I am situated in Denmark and am doing tests against a database in Paris, but experiencing same long latency when using a database in US east with a Vercel hosted solution in US east as well....

cvs0

2/5/2025

Any better way for data refreshing here?

https://github.com/LockScript/lockscript-vault/blob/main/src/app/(main)/page.tsx https://github.com/LockScript/lockscript-vault/blob/main/src/components/vault/vault-page.tsx#L67...

Arima

2/5/2025

<fields> is missing.

Created a simple post request that should create a user with a specific name, but I get an error ```prisma generator client { provider = "prisma-client-js" }...

tyler

2/5/2025

PgBouncer and Prisma

hi! if my db has a 500 connection limit and i'm using pgbouncer in between, with prisma, what should the connection_limit be set to in my db string? i see these strange spikes where queries suddenly start taking much, much, longer and the database is not struggling nor is the application code. my hunch is that prisma connections are somehow backing up / not being freed up correctly and it's leading to a backed up queue. ...

Mas0n

2/4/2025

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://`....

C0casio45

2/4/2025

Many to two relation

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

Markigno

2/4/2025

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...

gnarley_farley.

2/4/2025

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?

ididit

2/4/2025

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())...

thejacer87

2/4/2025

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...

Kasmadan (UA)

2/3/2025

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 ...

saulgoodman

2/3/2025

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,...

jm22

2/3/2025

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.

Mike Oxmall

2/3/2025

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...

kangkang

2/3/2025

Two table fields are the same

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

Infamy

2/3/2025

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)...

gnarley_farley.

2/3/2025

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. ...

censmart

2/2/2025

Prisma extented Request type

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

nks1302-jack

2/2/2025

PG extensions and database credentials

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

pixellord

2/1/2025

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...

Previous Next

Gaming

Programming

Prisma

Join the Prisma server to ask questions!

Prisma

Join the community to ask questions about Prisma and get answers from other members.