Prisma

Join the Prisma server to ask questions!

Prisma

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

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

Chaos1

2/1/2025

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.

censmart

2/1/2025

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

hari_narayan

2/1/2025

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

Parker

2/1/2025

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

FrancyMak

1/31/2025

Prisma Studio Error

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

message3.txt

zaloster

1/31/2025

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

vpjm

1/31/2025

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

Saturn 🪐

1/31/2025

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

begot

1/30/2025

Prisma Pulse not working after a while

i'm using Prisma Postgres and Prisma Pulse in my API. after a few hours, pulse stops functioning, while the normal database connection continues to work without issues. to resolve this, i have to manually visit the Prisma dashboard to disable and re-enable pulse, after which it starts working again. when pulse stops working, i encounter P6101 error codes in the console: ``` [Nest] 45216 - 01/30/2025, 8:05:45 PM ERROR [PulseService] Failed to initialize UserStatus stream:...

Shrinjay

1/30/2025

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.

AndcoolSystems

1/30/2025

Prisma Studio Issues

Hello everyone! With the recent release of new Prisma Studio features (like the sidebar for editing rows) I found a few bugs related to the new features. I already created an issue in the prisma studio repository, but I thought it would be nice to also report it here (because apparently the studio's GitHub doesn't often respond to issues) P.S.: I really love Prisma ORM and everything related to it, but these bugs really hurt the experience of using the studio. But anyway, thank you for a great ORM ❤️!...

vpjm

1/30/2025

Generating a default form from Prisma

Hi, for now, I plan to use Prisma's Zod generator and then convert the Zod schema into a form using react-formgen. I’m not sure if there’s a more canonical and reliable way to do this. If anyone has encountered this issue before, feel free to share your insights!

Naghell

1/30/2025

Existing MySQL to Postgres

Hi everyone! I'm planning to migrate my old MySQL database to PostgreSQL. I used pgloader to transfer all the data—no issues there. I also adjusted my schema to be compatible since there were some differences. However, when I run prisma migrate, I keep getting errors. The only solution I’ve found so far is to reset my migrations, but that would wipe all my data. Is there any way to avoid that? What should I do?...

Teecha

1/29/2025

Prisma Python NO_PROXY not being honored?

I am facing issues with squid proxy blocking internal requests to the query engine with Prisma python client. I set NO_PROXY="localhost", however, it still sends it to the proxy. Only way to stop it from doing so is turn trust_env to false. Any help would be great.

Enze

1/29/2025

Prisma with Turbo and Docker

Hey there, I'm currently "learning" Turbo and I came across the prisma guide. I wanted to ask if there is some best practice for Prisma and Docker within Turbo? Should I dockerize the package itself or is that bad? Technically I'm stuck at 1. Migrate your prisma.schema and generate types as I don't want to run PosgtreSQL locally, but on Docker. ...

Uncle

1/29/2025

Help with related filtering with some

With the following schema how do I search for all leases based on the size of a unit? ```ts model Unit { num String @id @unique building String...

Ethan

1/29/2025

TSOA generating from @prisma/client

This is my current workflow, i run tsoa spec-and-routes with OpenAPI to generate a swagger.json of my controllers. In my controllers, i use models from @prisma/client generated from schema.prisma. I fairly sure this is how it works. The issue is when i go into, for example, import {User} from @prisma/client, this is the definition... and i think TSOA does not understand this type ```/**...

ReDev1L

1/29/2025

Property '[PrivateResultType]' is missing in type 'TypedSql<Parameters, Result>'

Error:

Argument of type 'TypedSql<Parameters, Result>' is not assignable to parameter of type 'TypedSql<unknown[], Result>'.
  Property '[PrivateResultType]' is missing in type 'TypedSql<Parameters, Result>' but required in type 'TypedSql<unknown[], Result>'.ts(2345)

Argument of type 'TypedSql<Parameters, Result>' is not assignable to parameter of type 'TypedSql<unknown[], Result>'.
  Property '[PrivateResultType]' is missing in type 'TypedSql<Parameters, Result>' but required in type 'TypedSql<unknown[], Result>'.ts(2345)

...

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.