Prisma

P

Prisma

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

Join

Prisma 6.7.0 can't find tables after splitting schema into multiple files.

I have just upgraded to 6.7.0 and wanted to use the new prismaSchemaFolder feature, but after re-running generate and migrate it can't find the tables or I think they weren't even created because I don't see any in the prisma studio. My setup - Next.js 15 app router - My schema file is in prisma/schema.prisma and the my other .prisma files are in prisma/models/...
No description

Database down, failing with `Startup/auth proxy error`

My database cmcunrbcy000dvp0vb5u6myqx is currently down, all queries return errors, even the dashboard studio does not work. Tried restarting it but it did not help Any way to fix this issue?...

Does Prisma support query cancellation via abort signals?

Hi, I asked AI the same question which they said answered "no" to, but I just want to be extra sure as I've seen "yes" somewhere else. I just want an ORM which has a query builder or query methods that have the option to pass an abort signal to cancel. So far AFAIK, Mongoose doesn't exactly support it, TypeORM doesn't seem to have it and I just want to know if Prisma does before switching....

Method to "compose" queries? (a la GraphQL Fragments)

Hi, Is it possible with Prisma to "compose" queries, like you can in GraphQL queries using fragments, all in a type-safe way? For example, if I want to find a model from my back-end, and then be able to say "I want this model with the data that is required for each of these front-end components to display properly"....

data types errors

Ciao, i have the following query that highlights an error whenever I try to access "user.userCompany". This query was initially inside a dbClient.$transaction and received the same error. I try to keep outside the transaction, and I'm receiving the same error. `const user = await dbClient.user.findUnique( { where: {...

Prisma migrate reset issue

https://streamable.com/b30vo6 After reseting the prisma, migrate i am getting the issue, is this normal?? or why am i getting this, ?? instead of working and should checking the schema changes and creating the empty migration file, i am getting alter enum, and drop table why is that so, or Am i missing something??...

dockerizing my nodejs app giving error, working perfectly on localhost:

{"level":"error","message":"Failed to connect to database: \u001b[1;91merror\u001b[0m: \u001b[1mError validating datasource db: You must provide a nonempty URL\u001b[0m\n \u001b[1;94m-->\u001b[0m \u001b[4mschema.prisma:11\u001b[0m\n\u001b[1;94m | \u001b[0m\n\u001b[1;94m10 | \u001b[0m provider = \"mysql\"\n\u001b[1;94m11 | \u001b[0m url = \u001b[1;91menv(\"DATABASE_URL_WRITE\")\u001b[0m\n\u001b[1;94m | \u001b[0m\n\nValidation Error Count: 1","metadata":{"clientVersion":"6.11.1","errorCode":"P1012","name":"PrismaClientInitializationError","stack":"PrismaClientInitializationError: \u001b[1;91merror\u001b[0m: \u001b[1mError validating datasource db: You must provide a nonempty (/app/node_modules/@prisma/client/runtime/library.js:112:2770)\n at async exports.default (/app/dist/src/api/loaders/mysql.js:32:9)\n at async exports.default (/app/dist/src/api/loaders/index.js:14:41)\n an at async startServer (/app/dist/src/app.js:13:5)"}} dockerfile: `FROM node:24-alpine AS development WORKDIR /app...

Prisma ORM without Rust engine stable enough for production?

I am currently experiencing connection pool timeouts with Prisma in a Next.js app deployed to AWS via SST v3 (OpenNext) in a serverless environment with Lambdas. I have tried optimizing the connection pool by tweaking the relevant settings however am still experiencing some issues. Currently I see two options worth trying, either setting up PgBouncer or trying the Rust free engine with the PostgreSQL adapter. I was just wondering how stable is this feature right now? I know it's still a preview...

Help using pg_dump

Hello, I was wondering how to use pg_dump to download the contents of my database for offline storage so I can have a "secure" way to back up my databases. I am just kind of lost and don't really even know where to start I have pg_dump installed and a user created but how do I connect to my database and so on and so forth. Any help would be greatly appreciated, thank you....

Why dose prisma 3d crash everytime

Like when I was in a middle of working on a modle CRASH and closed progress so fix that when quitting it automatically closes and plus I miss the 2023-2024

Help!!!!!!!!! Database timeout in recently

{ "clientVersion": "6.10.1", "code": "P1001", "meta": { "database_host": "qp-2045-production.c09wkquaajuf.us-east-1.rds.amazonaws.com", "database_port": 5432, "modelName": "PlatformInteractions" }, "name": "PrismaClientKnownRequestError", "stack": "PrismaClientKnownRequestError: \nInvalid prisma.platformInteractions.update() invocation:\n\n\nCan't reach database server at qp-2045-production.c09wkquaajuf.us-east-1.rds.amazonaws.com:5432\n\nPlease...

How to use Prisma ORM in a Turborepo monorepo

I'm trying to setup Prisma ORM in a Turborepo monorepo. What's the best practice to do that?

Cannot access Prisma database

Hello, I'm currently using Prisma Postgres with Accelerate. It was fine accessing the database until yesterday afternoon. It seems to be a Prisma Client error on the build script. The error message is as follows: ``` Message: Error in Prisma Client request: ...
No description

Prisma transaction cannot read its own writes when mixing standard and raw queries.

Hello! I am using Prisma 5.21.0 with Postgres 15.5. I've noticed that when I create a transaction, writes performed with $executeRaw are not seen by queries made using the standard ORM interface and vice-versa. Looking at the logs for my postgres service shows that these queries have a different postgres Process ID, whereas all standard ORM calls within a transaction have the same Process ID. For example:...

prisma.$on not working with nestjs implementation

Hello, I am trying to make a small logger in my nest application for all my prisma queries. But when I try to implement the on event method of logging the queries typescript does not pet me (cf image) What can I do ? Is it a problem on my part ?...
No description

Anyone knows if prisma postgres is down lately ?

Connecting to our database worked for me all through yesterday, but today its been hell. Couldn't connect to the database to save my own life.

Missing configured driver adapter

Hi When using the driver adapters & query compiler, in combination with the readReplicas extension, I get this vague error. Is this a bug, unsupported, or am I overlooking somethiing? ```log...

postgresql or postgres

I am getting an error in my app using prisma datatase, and while investigating the issue I noticed that if you choose to use Any client, and generate a Connection String the protocol is shown as postgres:// - See attachment. However, I think I read from somewhere that the protocol that prisma uses is postgresql. So, which one is it?
No description

"PrismaClient" is not exported by "generated/prisma/index.js", imported by "app/.server/db.ts"

Hey, I've created new fresh project and I want to use PrismaClient from the generated folder, but it throws that it's not found, anyone had that bug before?