Prisma

P

Prisma

The official Discord server of Prisma! Find us online at prisma.io

Join

Websocket error when using Pulse

When I tried pulse it was working for some minutes but then it crashes with this error. I don't have any idea why this keep happening. Even increasing the event Listener, it still crashes Btw, I am using Supabase as my hosting provider. The error:...
No description

Supabase with prisma

Hi everyone, i'm currently trying to push some tables created in my schema.prisma package. I execute the command "npx prisma migrate dev --name commit" in my terminal's project. However i faced an issue : my command still running and nothing is happening -> no errors or success message(s) appear. I checked all the informations in my files and everything is okay (good database_url , settle prisma models and dependencies intallations) so i think the problem is from Supabase. has anyone faced this...
Solution:
I found the solution : you need to declare "DIRECT_URL" in your .env file (like the screenshot). Here's the documentation to succeed it https://supabase.com/partners/integrations/prisma But be carefull it seems to have some issues with port you'll use in both url (it would be 6543 for the database_url but it doesn't work in my case)
No description

Prisma Console API access?

I'm looking to update the database connection string used for Prisma Accelerate automatically. Is there an API available with which I can do this?
No description

default value not changing

I changed the default value of one of my fields on the schema but it doesnt propagate even if i generate the schema again? example showPricingBgImage Boolean @default(true) to...

Type '{ connectOrCreate: { where: { state_name: string; }; create: { state_name: string; }; }; }' is

model Repairs { id Int @id @default(autoincrement()) machine_id Int technician_id Int state_id Int...

Main .prisma file location with new prismaSchemaFolder feature (+ Bazel)

I'm applying some changes by splitting the main file into smaller pieces, thanks to this new cool feature. Anyway, as we are using BAZEL and a custom generator, I need to tell BAZEL build rules file where to locate the file which has all the models, and If I keep It like It was just aiming to the schema.prisma file, It will log several errors not finding the models: (As It is taking the schema.prisma raw directly from the folder). I can't seem to find the location (If that's how It works) where a single schema.prisma file is located having all the .prisma files of /schema folder. For now I managed to make it work concatenating all files through a script but I think there should be another way Sample of error If using the main schema.prisma: ```...
Solution:
Solved - Importing all files on schema folder in BUILD.bazel instead of just the schema.prisma, and then change command to generate --schema schema folder, worked just fine. No need to make bazel create a single file, prisma manages the folder correctly.

Update Prisma CLI

Hey, how do I update the Prisma CLI to get the latest features? Are there any migration files to apply for production?...

Argument is missing

When I try to create a repair it throws me this error Error: 15 const componentsData = components.map((component) => ({ 16 component_name: component,...

optimize dashboard connection timed out

cloudflare ray id, if that helps: 88e920f71b005e7d
No description

db push and migrate dev

i used prisma db push, and now i want to create the migration and push to prod. I used migrate dev on local and it wants me to delete all data. i assume later when i migrate prod i will also lose all data?...

Type-safety for dates when returning DB entries as JSON

I used to use Prisma in server components where I don't need to do serialization. Now I need to return DB entries from an API route handler in JSON form. This means, the Date type of the Prisma model is not correct on the client anymore. JSONification turns the Date into a string....

npx prisma migrate dev --name init (stuck)

Environment variables loaded from .env Prisma schema loaded from prisma/schema.prisma Datasource "db": PostgreSQL database "postgres", schema "public" at "aws-0-us-east-1.pooler.supabase.com:6543"...

Filtering an array

Hi, my question is very simple. For a column, let's call it transportation. { "transportation": { "array_contains": [ "bike"...

Generate prism client

I already have a MySQL database, and with data inside, how can I generate my prism in my app without affecting this data?

Uploading image

Anyone can help me with uploading images to the server? I did this using nulter but keep getting 500 interal server error when trying to make the post reqest on postman by uploading an image ```import express, { Express, Request, Response } from 'express' import { PORT } from './secrets' import rootRouter from './routes' import { PrismaClient } from '@prisma/client' import { errorMiddleware } from './middlewares/errors'...

binaries.prisma.sh Gives Not Found Error

I'm using Prisma on NixOS, configured as per this GitHub issue, and things have worked properly in the past. However, currently when the CLI tries to download the proper files for the prisma engine, it encounteres a "Not Found" error (see below). ``` ❯ prisma --version Warning Precompiled engine files are not available for nixos....
No description

prisma migrate dev wants to drop all tables

Hello! I am using Prisma in a Sveltekit application deployed to Vercel. I also use the Vercel Postgres database. I am trying to add a model to the schema and then update a relation between two models, but when I run prisma migrate dev --create-only the generated migration drops and re-create the whole database structure. I am missing something?

schema env file

Is there a way to dinamically chose the env file that schema.prisma will use? For example: ``` datasource db { provider = "mysql"...

nextjs + prisma + superbase working is developement only

Please i need help, the app is hosted on netlify but can't build after initial build. got the attached error
No description

Dynamic database

is there anyway to change the database in the query? i have tried with new PrismaClient({datasourceUrl: ''}) but seem not working, i am using sqlserver...