Prisma

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

Prisma

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

11/25/2024

creation of new user failed and exited an error in vercel logs for my project

In the creation of new users I made use of better auth for authentication and the creation of a new user in my nextjs project which I integrated with prisma as my ORM with supabase as my database............. this arrangement however performs the creation of the new user in development however after deploying to vercel and performing the same authentication of new users it throws this error which indicates that the new user cannot be created and i don't seem to know why it doesn't work in deployment where i have added the environemt variables required by prisma like the DATABASE_URL and the DIRECT_URL needed by prisma to connect to my supabase database and this connnection worked fine The error from vercel logs upon creation of new users: [Better Auth] ERROR ...

monkeysjump

11/25/2024

Using OR in connectOrCreate

I want to connect to an image if imageId is defined. If not, I want to connect to an image with a matching fileStorageObjectId. If it is not found I want to create a new image. ```js featuredImage: { delete: true,...

ProEvilz

11/24/2024

Failed requests

After enabling detailed logging on the Prisma Client instance, I've noticed quite a few failed query attemps. ``` prisma:warn Attempt 1/3 failed for querying: This request must be retried prisma:warn Retrying after 26ms...

Kuuzoo

11/24/2024

Nuxt 3 with prisma

Hi there! I've been using prisma in all of my past projects and I'm looking forward to be using it in my future nuxt projects too. I've seen that there is the official @prisma/nuxt-prisma module but it somehow feels a bit dead. - The installation doesn't seem to stable work at all....

Moray

11/23/2024

Amazon Linux 2023 support

I'm trying (and failing) to run Prisma on Node 16 on AL2023 (x86_64. Am I right in thinking that it's not compatible as it's not downstream of Alpine, Debian or RHEL?

Yozamu

11/23/2024

Neon adapter (driverAdapters) gives error on PrismaClient init

Hey there. I've wanted to run inngest events that trigger some prisma stuff, but I'm getting the error

PrismaClient failed to initialize because it wasn't configured to run in this environment

PrismaClient failed to initialize because it wasn't configured to run in this environment

So I've decided to take a look at the driver adapters. After following the setup page to update my existing code, I have the following prisma client file : ...

Anas Badran

11/23/2024

Fix schema error

I have this schema: ```prisma // This is your Prisma schema file, // learn more about it in the docs: https://pris.ly/d/prisma-schema ...

Rarity

11/22/2024

prisma decimal and react router 7

yow guys, since React Router v 7 is released today, is there any plans that Prisma.Decimal is configurable due turbostream? The only problem i got left in my application is prisma.Decimal not being perfectly transfered to the client as an instance i guess or any workarounds for this`?

Mohammad Orabi 🇱🇧

11/22/2024

TypedSql generating wrong types from the query

* DESCRIPTION My query returns the chests from the chest table and add to it the numOfKeys the user has for those chests by joining the chestKeys table, while returning the chests , if the user does not have a chestKey record I am explicitly falling back to 0 instead of null * ISSUE TypedSql is returning numOfKeys as number | null ...

Mohammad Orabi 🇱🇧

11/22/2024

Bug in TypedSQL in version 5.22

Here is my schema postgres latest ```ts generator client { provider = "prisma-client-js"...

Aleksandar Dimitrijevic

11/21/2024

Postgis verstion update

Hello, How can I update from version 3.2.4 postgis to 3.2.6. 3.2.4 is currently in my database and that version is not existing anywhere now. So if I want to deploy my migrations on staging environment i have a problem ```...

Anas Badran

11/21/2024

Building the schema

I want to archive the content for a scholar who writes a series of posts related to a single subject, this series will have different shape for it's posts than other serieses. for example a series of posts have a verseId, chapterId, point_1, point_2, point_3. another series posts may look like this: characterName, content. And there will be a serieses created in the future I need some help and ideas on how to achieve that....

Luke

11/21/2024

ORM for Expo, Android Build. Error: Unable to resolve module .prisma/client/react-native

Hey everyone. I'm trying to run an Android expo build on a project with the react-native-prisma. Here is my branch for reference: https://github.com/luketurnbull/todo-native-app/tree/lukes-local-first-todo I'm getting the following error in the Run gradlew step....

mansour_tech

11/20/2024

Delay when navigating between pages

Delay when navigating between pages using next/link despite utilizing loading.js, caching for fetch, or even static pages.

SoxZz5

11/20/2024

Problem with Stream on Pulse

GM, It was working in the past then we got some problem with NeonDB that have been fixed by Neon themselve Currently I'm unable to use stream() and it look like we don't have any event stored, we have activated event persistance like in the past ...

PlanetTeamSpeak

11/20/2024

rawQuery compilation

After switching from mssql to Prisma ORM, I noticed that the rawQuery calls are much slower than they were on mssql. Do they get precompiled and cached and if not, is there any way to? I have a pretty big query that takes about 520ms to complete while it used to be about 20ms. I also cannot use TypedSQL as I'm using SQL Server as database....

Solution:

Hey @PlanetTeamSpeak 👋 There is some overhead involved even while using Raw Queries with Prisma as raw queries still need to be processed via the query engines, so at the moment it won't be as fast as a native mssql driver. We are working on a new prototype which should make queries alot faster. I don't have a timeline yet which I can share with you....

яσчαℓтℓя

11/20/2024

TypeError: The "payload" argument must be of type object. Received null

There's an ongoing issue in our codebase where Prisma queries that fail give the error in the title, which isn't the typical error we see in other projects. Our project is using NextJS 15.0.2 and Prisma (with neon serverless adapter) 5.22.0. Here is the client: `import { Pool } from "@neondatabase/serverless";...

ProEvilz

11/19/2024

Migrations hang on Prisma Postgres

Hi, out of seemingly no where, I can no longer migrate the DB. When I run the command I get this ```bash $ bunx prisma migrate dev --name updateembeds Environment variables loaded from .env Prisma schema loaded from prisma\schema.prisma...

Hornster

11/19/2024

nextjs + prisma: rawQuery breaking if using globalThis

Hi! I'm currently working on a nextjs (14.x) project, where I also want to use prisma (5.22). I have encountered an issue with nextjs always generating new clients in dev mode, so I followed the documentation and only generate the client, if it does not yet exist on globalThis. This seems to work when I use the client directly, but rawQueries only work on the first rendered route. As soon as a route has to be re-rendered (which happens very often in dev mode), the parameters no longer get properly resolved. Here is a simple example, queried with a freshly created client:...

Solution:

its a bit different, as I need multiple client instances due to a multi tenant setup. ```js import { PrismaClient as PrismaClientTenant } from './client' ...

Jvwooo-er 👻

11/19/2024

FindUnique/Update using unique index on sub field

Hi, I need some help with generating a schema where I can query indexed sub fields. I've looked for solutions but I couldn't really find a thread matching my problem. Let me sketch an example. (I'm working with Prisma ORM with MongoDB)...

Solution:

Hi Raphael, Thanks for your fast reply. I've tinkered with this some more and found out it actually can be done. However the subfield should have a name that is not inside the model. ...

Previous Next

Gaming

Programming

Prisma

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

Prisma

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