Prisma

Join the Prisma server to ask questions!

Prisma

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

3/5/2025

How do you manage the Prisma Client in Express and NestJS, GraphQL (Not Next.js) ??

We are using GraphQL with Apollo Server and injecting the Prisma Client into the resolver’s context. However, this approach requires passing the Prisma Client to service classes within the resolver. As the depth increases, the need to pass Prisma throughout the application becomes more frequent. It seems better to use a singleton and import the Prisma Client directly in the service class, as described in the article below....

joseph013318

3/4/2025

Auto no cache when using prisma postgres with better-auth

using prisma postgres with better-auth for user session and user management but getting this whenever refreshing! How to implement the caching?

│ POST https://accelerate.prisma-data.net/6.4.1/sdfsdfsdfdsf4s64df35s4d1f5s4df5346sf6ds4f4/graphql 200 in 506ms (cache skip)
 │ │ Cache skipped reason: (auto no cache)

...

Supernova

3/4/2025

help contructing a filter query

I'm receiving filter query params as a prop to my server action, every filter param can either be an array of values or just a single value. I can't figure out how to go on creating this filter query

Josef Henryson

3/4/2025

How to define types in Pothos that work with Prisma?

Hi. I am trying to migrate from nexus to Pothos. But I run in to some trouble when trying to define my input types. See image for example of my code. The Prisma delete function does not agree on my defined type. Can you see what I am missing? TS error below: ```...

DaYroXy™

3/4/2025

Connect to multiple db?

Hey guys is there a way to connect to different db on user selection? for example i have 3 databases 1 for each project and i want to select which app to use and then connect to this db to fetch data is it possible?...

xeno

3/4/2025

Prisma Pulse discontinued - alternatives?

With prisma pulse being discontinued, does anyone have any recommended alternatives that provide similar functionality?

Smadger

3/3/2025

Best way to use typedSQL when deploying to multiple places

I have a project which has just enabled typed SQL. However when I deploy my project multiple containers, multiple databases and multiple sites are deployed/updated. Currently I build everything before running my database migrations to reduce downtime....

Abdullah Zeeshan

3/3/2025

Usage of `@map` and `@@map` as a best practice to name tables and columns in a database

Say we have a legacy database somewhere that has its table names and column names. One way to use @map and @@map is to ensure that the names of our models and fields map to the names of the tables and columns, respectively in that database. Apart from this use case, can I use these as a best practice whenever I am creating my Models where essentially a legacy database does not exist but I am building from scratch. ...

Quan

3/3/2025

Running prisma migrate deploy in a production server

Hi all, I was wondering if I should be running prisma generate before prisma migrate deploy in a production server, I feel like I haven't seen this in any of the docs I've seen. I'm currently executing this: ``` python3 -m prisma generate python3 -m prisma migrate deploy python3 seed_db.py...

256-8

3/3/2025

Accidental deletion of a migration file

I have two problems: 1. Due to poor attention to detail, an applied migration file from 6 months ago was deleted (both folder and migration.sql) in a branch that was merged into main 2. In the same branch new enums were added to schema.prisma BUT prisma migrate dev was NOT run After this in the heat of the moment, I added the deleted branch back into main (no prisma commands were ran, simply added the file back to production)....

skidy

3/3/2025

Case insensitive for unique constraint

how do i make the name case insensitive

@@unique([userId, name])

@@unique([userId, name])

...

Wojak

3/3/2025

Question about storing/reading dates from database

Hi, does anyone got some links or know how should I deal with dates in JavaScript/Prisma when it comes to storing it to the db and reading a date DateTime db value? My colleague from another timezone gets -1 day when displaying it from the client while mine shows the correct value. I store it using new Date(value.someDatefield) upon form submission and read it using date.getFullYear/getDate/getMonth.

Sommer

3/2/2025

P1001: Can't reach database server

Whenever I run this command: npx prisma migrate dev --name init, I end up getting this error: ``` Environment variables loaded from .env Prisma schema loaded from prisma\schema.prisma Datasource "db": PostgreSQL database "postgres", schema "public" at "db.nbcsqgnnbagzijwbrfsb.supabase.co:5432"...

Lateralus

3/2/2025

Prisma Nuxt Turborepo: Cannot find module

I'm attempting to use Prisma client in a monorepo based off Prisma's official guide: https://www.prisma.io/docs/guides/turborepo. I'm running into issues trying to use the generated client in a Nuxt application located in the monorepo. When I import the client into one of my API routes I get a module not found error: cannot find module 'C:\packages\database\generated\client' When I examine the .nuxt/dev/index.mjs file in dev, it appears that the Prisma client is using a relative path instead of an absolute path...

LucasB25

3/1/2025

Prisma migrate

Hello, I have modified my Prisma schema and would like to apply the changes on my file . db without losing data, but it does not work, I lose them

Reis

3/1/2025

PrismaPulseServerError: P6100 Prisma Pulse encountered an unexpected error

I'm finding that Prisma Pulse is flaky. If I let it run on a long-running process, it will eventually start failing. How can I get support here?

Charran

2/28/2025

Seeding Prisma db with Excel File

Need some guidance on how to seed a prisma db using an excel file

Joho

2/28/2025

Prisma studio not great for business people. Any alternatives?

Is there a better prisma database GUI? Prisma studio is very hard to use and not really end-user friendly.

cwh

2/27/2025

VSCode Intellisense completely breaks when adding a relation

Hi all. I've just started using Prisma with Supabase for the first time on a new Next.js project. All was going swimmingly until I added a basic relation to one of my two extremely simple models. Since adding that relation and running npx prisma generate VSCode Intellisense has completely broken, and hovering over anything that used to give me instant Intellisense just pops up "Loading…" that never seems to resolve. This includes non-Prisma related code like basic React components. Removing the relation and re-generating fixes it. Is there something obvious that I'm missing? ```...

Mike

2/27/2025

mongodb compressors

How to add compressors to mongodb connection string?

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.