Turborepo with Prisma throwing Error
We are encountering an issue with our Next.js application using a Turborepo setup, integrated with Prisma ORM and Neon Postgres as the database. Upon invoking prisma.job.findFirst(), the following error is thrown:
⨯ PrismaClientKnownRequestError:
Invalid
prisma.job.findFirst() invocation:
...`prefer_socket` doesn't work when connect OceanBase with prisma
The same issue is posted on https://github.com/prisma/prisma/issues/24010 and I supply two solutions.
However, it's like a stone dropped into the sea and no response at all. So I post it on Discord to look forward to receiving official support.
Thanks for any help!...
Cant Connect into Prisma Pulse
Hello Support Team,
This is my connection Link :
postgres://<user>:<password>@vinayakvispute-100xdevs-vinayakvispute4-1688.g.aivencloud.com:12527/multi-resolution-transcoder-pipeline-mux?sslmode=require
...
Get my data from render to local Postgres DB
I don't know if I should ask my question here but I have my database hosted on render and now I want to download my data and have a local database , I have a docker container with my backend and postgres with pgAdmin
I tried downloading the backup database from render but restoring the db to local isn't straightforward, if anyone has experienced that before I would like to know the strategy 🫡...
Passing an array into TypedSQL query
Hi, thank you for the TypedSQL feature I am trying to use now, but getting an error when passing and array of integers. Can I ask for pointing out what am I doing wrong?
This is my query in .sql file:
```...
Repo pattern
Hello, guys! I want toa ask about repo pattern with prisma. What to do if I have select: author, comments, tags, replys and etc into a single query. This will mean that my function name should be something like this getPostWithAuthorCommentsTagsReplys is there some best practice when dealing with such a case
npx Prisma init and Prisma init not working
Good day. Please advise. Today Prisma init stopped working, how can I solve this problem? Same with old projects. Prisma version 5.19.1.
0% cache hits
I just setup accelerate and have verified it's working, but I keep getting 0% cache hit rate. How do I debug this? I think I am making the exact same query repeatedly
data optimization
Hello everyone, I'm really stuck and need help. I have a PostgreSQL database running with Docker on my VPS server. I was given a CSV file with over 60,000 rows, and my Next.js application is hosted on the same VPS. On my local machine, it works fine with no delay or timeout. However, after deploying, I noticed it was extremely slow. Most times, the requests time out because I'm trying to fetch all the data to create a dashboard. I think the problem might be related to how I'm making the database calls. I would be really grateful if someone could hop on a call or review my code to see what I can change to improve performance.
here is the github link
https://github.com/alidauda/Analysis-...
createManyAndReturn order preservation?
do we know if the order of the created entities in the returned list is the same as the input list?
couldn't find anything in the docs!...
New Prisma 5.19 TypeSQL: other statements beyond select
Greetings
The TypeSQL support an insert statement like this? (Assuming PostGIS was installed).
INSERT INTO locations (name, geom)...
Prisma Types
Pls somebody help with these types
```js
type PostFindUniqueResult = Prisma.Result<
typeof db.post,...
As a fullStack developer, I am looking for new project
I am a fullStack developer and 9 years of experience about web/mobile development.
main skills are React, Next, Angular, Vue, Sveltekit, Django, PHP, Laravel.
Currently I am focusing miniApp and Web3 projects.
If you need my help, call me anytime...
Unknown authentication plugin
Hello Team,
Do i need to switch ORM or is there a plugin for this issue?
Error: "Unknown authentication plugin"
Instead of clear password I provide AWS token to the connection URL....
Deploying to Vercel
From what I can see by searching, it seems I'm not the first one.... But I've now been stuck for days trying to deploy to Vercel, a NextJS app using Prisma.
✅ All works fine locally
✅ I've added a postinstall script to generate the client, I see no build errors, prisma client is generated fine in the build logs
✅ prisma.myModel.findMany(....) returns data...
Clarification on Prisma and DB Congruence
Dear Prisma Support Staff,
I hope this message finds you well!
I am a Software Engineering student currently using Prisma and have some clarifications to make. I have read in the documentation that the Prisma Schema is the single source of truth and it can either be pushed or migrated to the backend to construct the backend, or if the backend has already constructed Prisma may introspect the backend to construct the schema. Thus, it is my understanding that the Prisma schema follows a similar configuration to the database records. ...
Prisma Pulse with nextjs
Did anyone ever try this? i did try but im not sure where should i run the prisma pulse in my apps. API? Direct in page.tsx?
Validator questions
I'm trying to operate partial type of my User model as I omit the passwordHash field at instantiation. When I follow the docs I end up with the
select included in the type, this is from my sveltekit app:
```
import { Prisma, type User } from 'prisma/prisma-client'
const partialUser = Prisma.validator<Prisma.UserDefaultArgs>()({
select:{ email: true, givenName: true }...Solution:
Can you try this code?
```js
import { Prisma } from '@prisma/client'
const partialUser = Prisma.validator<Prisma.UserDefaultArgs>()({...
cacheStrategy in local dev
https://www.prisma.io/docs/accelerate/local-development#using-prisma-accelerate-client-extension-in-development-and-production specifies how to use prisma accelerate client extension in local development, but it's incomplete. Most of my prisma queries have the cacheStrategy property specified. This works fine in production with the accelerate client, but fails with the non-accelerate client.
Is the best practice here to just go through and comment out 50+ instances of cacheStrategy before developing your app locally and then uncomment it later when pushing?...
Connection Pool Timeout Issue Despite Custom Limit
I'm intermittently encountering a "Timed out fetching a new connection from the connection pool" error, even though I’ve set a custom connection limit of 70:
Invalid
prisma.entity.findFirstOrThrow() invocation:
Timed out fetching a new connection from the connection pool. More info: http://pris.ly/d/connection-pool (Current connection pool timeout: 10, connection limit: 70)
...