Nurul Comments - Answer Overflow

Nurul

•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:

 const user = await prisma.user.findUnique({
    where: { id: id , role : { Your_condition } },
    include: {
      role: true 
    },

 const user = await prisma.user.findUnique({
    where: { id: id , role : { Your_condition } },
    include: {
      role: true 
    },

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/introspection

7 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

Gaming

Programming