Nurul
PPrisma
•Created by Moncef Moussaoui on 9/5/2024 in #help-and-questions
Get my data from render to local Postgres DB
Are you running into any specific issue? Or do you just want a general guide on how to transfer data from render to local db?
3 replies
PPrisma
•Created by lucasp on 9/4/2024 in #help-and-questions
where inside include
Hey @lucasp
You need to move
role
to the main where
clause
Something like this:
2 replies
PPrisma
•Created by Narukami on 9/4/2024 in #help-and-questions
npx Prisma init and Prisma init not working
Can you try changing your network and check?
2 replies
PPrisma
•Created by Vinayak Vispute on 9/5/2024 in #help-and-questions
Cant Connect into Prisma Pulse
I responded to your email. Can you try removing sslmode from the connection string and check?
4 replies
PPrisma
•Created by joyce on 9/4/2024 in #help-and-questions
createManyAndReturn order preservation?
No worries! 😄
4 replies
PPrisma
•Created by dc3 on 9/4/2024 in #help-and-questions
New Prisma 5.19 TypeSQL: other statements beyond select
Yes it should work with any SQL, not specific to just SELECT statements
3 replies
PPrisma
•Created by joyce on 9/4/2024 in #help-and-questions
createManyAndReturn order preservation?
Hey @joyce
No, the order of returned list isn't guaranteed to be the same as input list. This is because database too doesn't guarantee the same order.
4 replies
PPrisma
•Created by Keith#1141 on 9/3/2024 in #help-and-questions
Clarification on Prisma and DB Congruence
Hello 👋
I had been told that the Prisma models and the database should not be similar and that Prisma should retrieve the records from the db and reconstruct them again to match their own models.Prisma models should match the structure of your database tables. I think it's incorrect to say that Prisma models and database should not be similar. Prisma schema can serve as the single source of truth for your application's data model. There are two ways through which you can ensure that your Prisma models (schema.prisma file) and your database are in sync. 1. Migration: You manually define your data model in the Prisma schema and then use Prisma Migrate to map this schema to your database
npx prisma migrate dev
command
https://www.prisma.io/docs/orm/prisma-migrate/getting-started
2. Introspection: You can use introspection to generate the Prisma schema from the current database schema.
npx prisma db pull
command
https://www.prisma.io/docs/orm/prisma-schema/introspection7 replies
PPrisma
•Created by zerokelvin on 9/2/2024 in #help-and-questions
cacheStrategy in local dev
Hey 👋
If I understand correctly, you are using two PrismaClient instances, one with Accelerate extension and one without the extension?
3 replies
PPrisma
•Created by daniel on 9/2/2024 in #help-and-questions
Connection Pool Timeout Issue Despite Custom Limit
Can you please enable metrics and check the number of active/busy/idle database connections?
https://www.prisma.io/docs/orm/prisma-client/observability-and-logging/metrics
This should help in debugging.
Also if you are using postgres, try running this SQL to check the number of database connections and the service name which occupies these connections.
SELECT * FROM pg_stat_activity;
6 replies
PPrisma
•Created by sukeshpabolu on 8/29/2024 in #help-and-questions
Is something happened with PrismaClient and adapters?
None that I am aware of, do you get the error after upgrading your prisma version?
2 replies
PPrisma
•Created by AndersR on 8/28/2024 in #help-and-questions
How can one test out the Pulse service in light of the superuser limitation?
Hey @AndersR
Superuser access is needed for creating a publication slot. If your database provider doesn't allow superuser access, then you can create a publication slot and provide it manually while configuring Pulse. This should allow you to try out Pulse without needing superuser access.
https://www.prisma.io/docs/pulse/database-setup/general-database-instructions#manage-your-own-publication-slot
3 replies
PPrisma
•Created by Ronoroa Zoro on 8/29/2024 in #help-and-questions
Cant connect to supabase using accelerate
Prisma Accelerate and Pgbouncer both are connection poolers. You don't need to use pgbouncer if you are using Prisma Accelerate. Can you try using the direct database connection string and check if that works?
3 replies
PPrisma
•Created by josh.anyan on 8/29/2024 in #help-and-questions
TypedSQL type safety over time
Can you please elaborate your query?
3 replies
PPrisma
•Created by 🌠kkMihai ⚡ on 8/30/2024 in #help-and-questions
Prisma and CUIDv2
We have a feature request for it here:
https://github.com/prisma/prisma/issues/17102
Please add a 👍 so that we can prioritise it.
3 replies
PPrisma
•Created by Max on 7/12/2024 in #help-and-questions
error with simple request
I am glad to hear that! 🎉
Thank you all for your patience and help while we worked on fixing this 🙏
19 replies
PPrisma
•Created by Max on 7/12/2024 in #help-and-questions
error with simple request
@Max @Skyy @xhulz The bug fix is out. You can upgrade to prisma version 5.19.0 to try it out. Can you please upgrade and try out the bug fix. It should fix the timeout issue 🙏
19 replies