Prisma

P

Prisma

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

Join

Prisma 7 on AWS Lambda

Has anyone deployed prisma 7 to aws lambda? i followed the upgrade document and switched to prisma-client from prisma-client-js and removed the target binaries etc, but when deployed i just kept getting timeouts and it would exceed the 128mb limit on the lambda? has anyone successfully deployed v7 to lambda and offer any advice?...

P1001: Can't reach database server

I need help integrating Prisma v7 ORM + Supabase to my Nextjs, I always got P1001 error everytime I push my prisma to my supabase. I follow the steps in new version but still can't figured out. For Practice only This is my database url (EMPTY NO TABLES YET) ...
No description

Module not found: Can't resolve './enums.js'

Hello ! I migrate to v7 and i have problems. errors: ```...
No description

Security Vulnerability

After upgrading to v7, we started getting these Dependabot alerts for security vulnerabilities in the hono package. Is there a plan to address these vulnerabilities?
No description

Best method to fix my dev postgres database after a botched restore cleared numerous constraints

I only got involved in a project a little while ago, and while our prod dB is fine, at some stage a full restore to the dev db turned off constraints, didn't fully work and didn't turn them back on, and then was reapplied, which duped a lot of data, and then tried to turn the constraints back on, and failed, but things just continued. Now we've multiple tables which lost their primary keys and foreign keys, and a few other things, and prisma tells us we've drifted and should reset. The only issue is, we've loads of other data in the dB that we can't lose. Ideally, and this may not even be a prisma question necessarily, what I'd like to do is do a backup, do the dB reset, then do a "ignore insert errors" restore on it....

Prisma Singleton issue

I have a type issue I cant figure out why is happening .. im using the latest prisma v7.. Path: prisma/schema.prisma schema.prisma: generator client {...

Prisma Studio v7 + mysql/mariadb - "introspect" operation failed

Hey, I just migrate my project to Prisma 7, its work, but studio does not work. When i try open, it says: "introspect" operation failed - No Tables Found ...
No description

Nestjs Prisma Client Extension for Soft Delete in v7 with type-safety

How can I setup properly the soft delete extension after migrating to v7 with type-safety? I am using this ext. https://github.com/olivierwilkinson/prisma-extension-soft-delete It has type-safety before, but right now it gives me an 'any' type when using it on my services. ``` import { Injectable, OnModuleDestroy, OnModuleInit } from '@nestjs/common';...
No description

v7 Upgrade issues

I have followed everything in the docs for Nextjs, Planetscale + Prisma 7 and im getting this when I run prisma studio
VT13001: [BUG] pushed wrong predicate to the join: c.TABLE_SCHEMA = t.TABLE_SCHEMA
VT13001: [BUG] pushed wrong predicate to the join: c.TABLE_SCHEMA = t.TABLE_SCHEMA
...

Issue using Prisma with Supabase Postgres

I am not able to query supabase database using prisma in v7. Error validating datasource db: the URL must contain a valid API key at on.handleRequestError. This is the error I got everytime i hit my db...

Can't compile with nextjs

Build error occurred
Error: Turbopack build failed with 1 errors: ./lib/generated/prisma/client.ts Code generation for chunk item errored An error occurred while generating the chunk item [project]/lib/generated/prisma/client.ts [app-client] (ecmascript) <locals>...

Prisma Studio v7 polish

Hey Prisma team, very excited to see the rewrite of Prisma Studio! The embeddable version is super cool. There are a handful of things that seem to need addressing/don't seem to be present in the new version: 1. Reverse relations aren't shown (e.g. User.posts)...

v7 - Unsupported ID type

Unsupported ID type: PermissionsOnRoles on model Role in relation permissions
I have a many-to-many table called PermissionsOnRoles to join Role and Permission. prisma generate says like above. I don't get the details about what's going on. Is it because of the composite ID or? Before v7 is fine every time I generate Prisma client. Today I tried to update to newer version and this popping out. I still able to get the Prisma client successfully, but I'm afraid this will break the Docker build....
No description

Prisma v7 โ€“ migrate deploy fails in Docker: โ€œThe datasource property is required in your Prisma

Hey everyone ๐Ÿ‘‹ Iโ€™ve recently upgraded from Prisma v6 โ†’ v7, and my Docker deployment started failing with this error: Error: The datasource property is required in your Prisma config file when using prisma migrate deploy. Prisma schema loaded from prisma/schema.prisma Iโ€™m using the new prisma.config.ts, i usually run my docker using npx prisma migrate deploy && node dist/main.js, but migrate deploy requires datasource url, but v7 doesn't allow datasource url.. Any help would be appreciated ๐Ÿ™...

disable object mapping for queryRaw

Is it possible to disable object mapping for returns of queryRaw? I just need the SQL result string for a fringe use case. I can't use JSON.stringify(), because the result can contain types that can't be serialized with it.

Prisma #7 Seed issue

after upgrading to prisma version 7, i can no longer run the seed file Package.json
"prisma:seed": "bun run prisma/seed.ts"
"prisma:seed": "bun run prisma/seed.ts"
...

7.0 the column `(not available)` does not exist in the current database.

I'm getting an error trying to load a user since upgrading to 7.0. I've changed my imports and my client and generator. The important parts of my schema.prisma: ``` generator client { provider = "prisma-client"...

Prisma photo app

What happened to the slider to adjust the strength of the filter? There used to be one but I no longer see it
No description

Difficulties migrating PostgreSQL to v7.0.0

Hello, PS: Im using PostgreSQL v17.5 I am trying to upgrade from PrismaORM v6.5 to v7 and im finding the following error:...
No description

How to use LibSql with Prisma 7.0.0?

this is how I used to do it but now that adapter and studio configs are deprecated and datasource doesn't allow me to set DATABASE_TOKEN, how should i do it? ``` export default defineConfig({ experimental: {...