I am getting this error message from prisma when I am running the GraphQL query. Environment variable not found: DATABASE_URL.\n --> schema.prisma:6\n | \n 5 | provider = \"postgresql\&quot...

Hi everyone I am getting this error "'prisma' is not recognized as an internal or external command, operable program or batch file." while running prisma login command in cmd I have installed the p...

Whenever I've try to use @supabase/supabase-js to query the db, I get an error. error: { hint: null, details: null, code: '42501', message: 'permission denied for schema public' } I think it h...

This is more a design question than a coding question. Suppose the following schema: // schema.prisma // Solution 1 model Entity { id Int @id @default(autoincrement()) attrs EntityAttr[] } mod...

I have a problem with connectivity in docker. I use an official mysql 5.7 image and Prisma server. When I start it via prisma cli, that uses docker compose underneath (described here) everything wo...

I wanted to make a chat app to practice working with graphql and node, for database I used prisma. I was doing everything like in this tutorial. https://www.howtographql.com/graphql-js/0-introducti...

I'm working on ReactJS project with NextJS Framework and Prisma to manage connection and queries to the DB. On my local project the Support model is found and when I use it in my API and build my p...

I would like to know how can I remove all items in table with Prisma2 and Jest ? I read the CRUD documentation and I try with this : user.test.js .... import { PrismaClient } from "@prisma/c...

I ran into an issue where I need to check if a user exists by his username and email since both are unique fields in the database, but I got an error. Argument where of type UserWhereUniqueInput ne...

I am trying to learn how to use prisma with a psql database. I'm running into an issue using references where the id is a uuid string. I have a user model with: model User { id String @id @default...

I'm using Prisma (https://www.prisma.io) as ORM. I want to check for duplicates when store data and, if not exists, create a new record. I thought I could do that with upsert method provided by P...

I am not able to use multiple database in same application . How can we use multiple data sources. Can we generate multiple "schema.prisma" for different database connections.

I'm trying to set timeout with prisma-labs/graphql-request. I've tried the way described here - https://github.com/prisma-labs/graphql-request/issues/103. const client = new GraphQLClient(config.u...

Does prisma support the ability to fetch data from multiple schemas from within a single database?

I'm trying to create a friendship mechanic for my app using Prisma among other tools. In the docs it shows the following example for how to create a many-to-many self relation: model User { id Int...

In my Prisma schema, I have a many-to-many relationship between posts and categories. I've added @map options to match the Postgres snake_case naming convention: model Post { id Int @id @default(a...

I can't use apollo Studio. After migration for Graphql playground. When I try to run in localhost and redirect me to apollo studio sanbox https://studio.apollographql.com/sandbox?endpoint=http%3A%2...

I know currently Prisma doesn't support ordering by multiple scalars fields, (see this issue: https://github.com/prisma/prisma/issues/62). But, I'm wondering if there is someone who found a solutio...

Prisma generates database tables with uppercase in MySQL. Is there any way to generate tables only in lower case?

I am using Prisma & PostgreSQL. Here I grab some stuff: await prisma.items.findMany({ where: { itemId: itemId }, include: { modules: { include: { lessons: true } } } }); I do not need...

I need save DECIMAL(10,2) in database. In MySQL there is DECIMAL type. MySQL docs: https://dev.mysql.com/doc/refman/8.0/en/fixed-point-types.html Prisma 2.0 docs: https://www.prisma.io/do...

how can i set string(varchar) length for string type be 50 and define a column be TEXT in prisma schema, for user table i want name be varchar(50) and bio be Text column. im creating my tables by p...

I want to implement a simple searching functionality with Prisma I have seen some info about using the where clause but it’s case sensitive so it’s not a good solution. I’ve also seen some tutoria...

I have this not so straightforward model relationship in Prisma. User --< Enrollment >-- Course and I can't figure out how to ensure the Course title field is unique just among that user's cr...

I am using postsConnection query for infinite scroll. It contains variables like after. After doing an upvote mutation, I want to refetchQueries... like this 👇 const upvote = await client.mutate(...