Prisma

Join the Prisma server to ask questions!

Prisma

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

4/19/2025

Connecting from something like dbeaver

Hi there, I would like to connect to my Prisma postrgres db via dbeaver. How/ where can I get a connection string that has the normal postrgres structure like postgresql://postgres:[email protected]:5432 Thanks...

grace charles

4/18/2025

Anyone have Prisma ORM working with React Router 7? I get Internal server error

Following the documentation here https://www.prisma.io/docs/guides/react-router-7 except using my own postgres instance rather than hosted cloud version. But as soon as I use import prisma from "~/lib/prisma" in a route I get [vite] Internal server error: exports is not defined on ...app/generated/prisma/index-browser.js:4:23). RR 7.5.0. Prisma 6.6.0.

Jacob | idohtml

4/17/2025

output in schema

the output = "app/generated/prisma/client" seems to be very wrongly placed in the project structure whenever I simply run the following command of pnpm dlx prisma generate and I have actually no clue to why it's doing this. Seems to me like this is a bit of an issue. Could someone please help me out here a little bit to furthermore understand exactly what's going on? I was used to just simply have this structure prior to v7 ```ts generator client {...

Mas0n

4/17/2025

Running into a strange issue

```→ λ api ── aws:apigateway:v2:post:/createWorkflow ─ Error creating workflow: PrismaClientInitializationError: Prisma Client could not locate the Query Engine for runtime "darwin-arm64". This is likely caused by a bundler that has not copied "libquery_engine-darwin-arm64.dylib.node" next to the resulting bundle. Ensure that "libquery_engine-darwin-arm64.dylib.node" has been copied next to the bundle or in "node_modules/.prisma/client"....

message.txt

4/17/2025

Extremely strange behavior

I'm not sure what to call this. All addresses are stored in the address table. To distinguish mailing or physical addresses, their IDs are placed into the respective tables which are then reference by student. When a student has equivalent mailing and physical addresses, the function above in my NestJS application returns undefined for the address_physical within the Student object and I have no idea why. I suspect that because there are name similarities or the IDs to the mailing and physical addresses are the same causes Prisma to go haywire. The even weirder thing is that when I console.log the address_physical.address, it is very clearly defined (although the same as mailing_address, which is intended). I have checked my NestJS entity models and there are no issues there either....

ImEgg

4/17/2025

Prisma Data Platform visualize data

anyone know how to use prisma studio on the Prisma data platform, it's just kinda blank for me. tables exist in the db and so does data tried to use an external dbms but the prisma accelerate connection string kinda blocks me from using anything else and I have no way of getting the direct connection string? any solutions for this?...

max

4/17/2025

Is there a way to differently parse DateTime and db.Date when reading from Postgres

Both DateTime and db.Date are being parsed into a full Date in js. This causes unwanted behavior since the Day will shift for negative Timezones and hand-picking the affected fields for differenting handling is not a viable solution for me. I'd like a generic way to apply a different parsing strategy for different Database types...

Jude Bellingham

4/17/2025

Prisma & Store Procedures

Hello everyone, Does Prisma support calls to stored procedures? If so, could someone explain how to do it or share a relevant link, article, or repository with guidance?. PD: I use Postgres...

Mas0n

4/16/2025

Having trouble connecting Prisma to Aurora AWS

running into error

``✖ Introspecting based on datasource defined in prisma/schema.prisma

Error: P1001

Can't reach database server at

postgres:5432`...

valeeeee

4/16/2025

Prisma playground release date

Hi everyone, we are eagerly awaiting the release of the upgraded Prisma playground. When will it be available?

Markigno

4/16/2025

Eslint errors

After adding the generator client { provider = "prisma-client-js" output = "./prismaGenerated/client" }...

Flinty

4/16/2025

Relationship issue

Hey, I'm probably being super duper stupid here, but I am new to Prisma and I'm missing something. I have the schema: ```js model Ticket { id BigInt @id...

lforst

4/16/2025

Opened PR to add ESM support to `@prisma/instrumentation`

Hi, I am back with another PR to the @prisma/instrumentation package: https://github.com/prisma/prisma/pull/26918 The package currently not shipping in ESM is currently blocking us from auto-instrumenting prisma in the Sentry SDK. It fixes a long-standing issue. Lemme know what you think....

Ben

4/16/2025

'Too many clients' error when using NestJS and Jest even with a singleton Service

Is there a canonical example of how to create a PrismaService that can be used with Jest to do integration testing? I'm getting 'too many client' errors even with a PrismaService that uses a global client and using --runInBand. Does anybody have a exmaple of how to configure a PrismaService to use with NestJS and Jest?...

Darkstar

4/16/2025

Could not locate Query Engine

Repo: https://github.com/DarkstarXDD/interactive-card-details-form Live site: https://interactive-card-details-form-darkstarxdd.vercel.app/ Prisma Client could not locate the Query Engine for runtime "rhel-openssl-3.0.x". ...

jose

4/15/2025

has no exported member error after updating to 6.6.0

I updated to version 6.6.0 and now I'm getting this error

Tom

4/15/2025

Hello I keep getting an error that I'm stuck on

```/home/thomas/Dev-Academy-Backup/plover-brief-voting/node_modules/.prisma/client/default.js:43 throw new Error('@prisma/client did not initialize yet. Please run "prisma generate" and try to import it again.'); ^ Error: @prisma/client did not initialize yet. Please run "prisma generate" and try to ...

max

4/15/2025

Handling @db.Date fields client side from different Timezones (Postgres)

We have a database where some tables have date only fields (DateTime @db.Date) while others are regular DateTime fields. When the server sends this data then javscript will create a new Date() for both since we don't have a date only primitive there. This causes the @db.Date field which is stored as 2025-04-20 to be understood as a UTC 00:00 date. Therefore if I'm in New York which is -4h the date will result in 2020-04-19T20.00.000Z and the data will shift by one day in something like a calendar. We COULD simply say that all dates that we receive client side we add the current timezones offset so that it will then be correctly parsed as 2020-04-20T00.00.000Z. Then we woulc correctly have the beginning of the DB's date in the local timezone to correctly sort in the entry, BUT then we would mess up regular DateTime dates. A "createdAT" timestamp from 14:00 local NY time will come back to the same client with a 18:00 time which is WRONG....

dilomere

4/15/2025

Schema Troubleshooting

Hi everyone, i have a pretty simple Schema with three models. However, whenever i try to push the schema to my MYSQL DB, i keep running into foriegn key restraints. I don't see anything wrong with my relations thats causing this to occur. One thing to note is that i did accidentally migrate the schema to my db, but i went and dropped the table and the migration folder. Did I make a silly syntax mistake that i'm missing, or will i need to baseline my db due to migrations being out of sync?

Sa3eeD

4/14/2025

full Text Search not working with Postgres and Nextjs

Hello, I have a problem with trying to use Full Text Search with Prisma ORM. I have followed the guide in Prisma docs, but I still get this error. I posted a snapshot of prima file and the code we have in the docs.
...

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.