I'm trying to filter vacations by date range, but I don't know how to do it. Please help. Database: postgresql Backend: nestjs + prisma orm (4.0.0) Frontend: React The data about vacations is stored in the database in this form:…
Ok, so i got in to this problem running query in my app based on: Remix app framework Postgres as a db Prisma as ORM I have simple loader function, which basically loads post types from my db. So, after…
I'm being told I have an invalid connection string for my MongoDB data provider. Specifically, I'm getting this: The provided database string is invalid. MongoDB connection string error: Missing delimiting slash between hosts and options in database URL. My problem,…
I have a docker container that contains 2 images. My app and my database (postgres) They are both running, the app on :3000 and postgres on :5432 . When i run npx prisma migrate dev --name init I get the…
I am trying to dockerize an express app using prisma and supabase, but am unable to get prisma to set the supabase url at build time with docker. Prisma is expecting the url to be in an environment variable named…
using next.js +next-auth + Prisma + PostgreSQL I added a custom login page and added the providers as well. my userId in the database is Int so when I log in with credentials I have no issue but when logging…
I started learning about prisma and supabase and would like to implement both technologies in my Next.js app. After running npx prisma migrate dev --name init I was faced with the following error: Environment variables loaded from .env Prisma schema…
I have a project that is using postgreSQL and Prisma. I was console.logging something in getServerSideProps(), but I noticed that is prisma is automatically console.logging huge amounts of strings like prisma:query SELECT "public"."TaskChart"."id", "public"."TaskChart"."name", "public"."TaskChart"."dateCreated", "public"."TaskChart"."default", "public"."TaskChart"."owner" FROM "public"."TaskChart" WHERE…
Error Invalid "prisma.user.create()". Prisma needs to perform transactions, which requires your MongoDB server to be run as a replica set. I used Nx (nx.dev) with MongoDB/Express with Prisma.
I'm having a problem with the prisma, at the moment where I use the findUnique() function to select the registered user based on his email. The error describes that it expects a string and not a JSON , but I…