I'm using Prisma to query a PostgreSQL database and implement pagination. However, I'm running into an issue where the pagination doesn't seem to be working correctly near the end of the results. Here's the query I'm using for reference: get:…
I am looking for a way that is not too hacky to hash all ids before returning to user, is there a way to do so? I've searched all over docs and couldn't find anything that handles all scenarios. I…
I am making a sign up page with 3 providers (Twitter, Facebook and Instagram) using next-auth and prisma with mongoDB. The issue appears when I try to sign up with any of the providers. Here is my nextauth.js file. import…
I am trying the following Postgresql query with Prisma's $executeRaw function. But it is not returning the values inserted. Instead only returning the number of records inserted. await prismaClient.$executeRaw(` INSERT INTO table1 (name, place, animal, thing) SELECT * FROM table2…
I'm developing a quite simple backend application with Express, using Prisma ORM to connect to a MongoDB database. The events collection is filled with documents such as: { "_id": string, "class_code": string "class_type": string, "created_by": string, "end_period": date, "end_time": time,…
I want to delete 2 models from a postgreSQL production database that are no longer used but have data on them. I am a bit afraid of removing them from the schema and running prisma migrate dev and then having…
I have a nextjs project that's using prismaDB for the ORM. I'm able to connect just fine to my local postgres db but I'm getting this error when running npx prisma migrate. Error: P1001: Can't reach database server at db-name.*.us-west-2.rds.amazonaws.com:5432.…
I am trying to update a record in prisma and it will not let me query the record with an update. I use the exact same where condition for both a findMany and the update but the update does not…
I'm using Prisma w/ Postgres and am trying to have a simple 1-to-many relationship with a User which can have zero or more Product(s). I'm able to create 1 product for a particular user but when I try to create…
A Product can have various sizes so I added one to many relation. But Each product can have only 1 unique size, i.e, in many to many the sizes should not repeat. For instance, Product X can have size 1,…