Usage of `@map` and `@@map` as a best practice to name tables and columns in a database
Say we have a legacy database somewhere that has its table names and column names.
One way to use
@map and @@map is to ensure that the names of our models and fields map to the names of the tables and columns, respectively in that database.
Apart from this use case, can I use these as a best practice whenever I am creating my Models where essentially a legacy database does not exist but I am building from scratch.
...Running prisma migrate deploy in a production server
Hi all, I was wondering if I should be running prisma generate before prisma migrate deploy in a production server, I feel like I haven't seen this in any of the docs I've seen. I'm currently executing this:
```
python3 -m prisma generate
python3 -m prisma migrate deploy
python3 seed_db.py...
Accidental deletion of a migration file
I have two problems:
1. Due to poor attention to detail, an applied migration file from 6 months ago was deleted (both folder and migration.sql) in a branch that was merged into main
2. In the same branch new enums were added to schema.prisma BUT prisma migrate dev was NOT run
After this in the heat of the moment, I added the deleted branch back into main (no prisma commands were ran, simply added the file back to production)....
Case insensitive for unique constraint
how do i make the name case insensitive
...
@@unique([userId, name])
@@unique([userId, name])
Question about storing/reading dates from database
Hi, does anyone got some links or know how should I deal with dates in JavaScript/Prisma when it comes to storing it to the db and reading a date
DateTime db value? My colleague from another timezone gets -1 day when displaying it from the client while mine shows the correct value. I store it using new Date(value.someDatefield) upon form submission and read it using date.getFullYear/getDate/getMonth.P1001: Can't reach database server
Whenever I run this command:
npx prisma migrate dev --name init, I end up getting this error:
```
Environment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma
Datasource "db": PostgreSQL database "postgres", schema "public" at "db.nbcsqgnnbagzijwbrfsb.supabase.co:5432"...Prisma Nuxt Turborepo: Cannot find module
I'm attempting to use Prisma client in a monorepo based off Prisma's official guide: https://www.prisma.io/docs/guides/turborepo. I'm running into issues trying to use the generated client in a Nuxt application located in the monorepo. When I import the client into one of my API routes I get a module not found error:
cannot find module 'C:\packages\database\generated\client'
When I examine the .nuxt/dev/index.mjs file in dev, it appears that the Prisma client is using a relative path instead of an absolute path...
Prisma migrate
Hello, I have modified my Prisma schema and would like to apply the changes on my file . db without losing data, but it does not work, I lose them
PrismaPulseServerError: P6100 Prisma Pulse encountered an unexpected error
I'm finding that Prisma Pulse is flaky. If I let it run on a long-running process, it will eventually start failing. How can I get support here?
Prisma studio not great for business people. Any alternatives?
Is there a better prisma database GUI? Prisma studio is very hard to use and not really end-user friendly.
VSCode Intellisense completely breaks when adding a relation
Hi all. I've just started using Prisma with Supabase for the first time on a new Next.js project. All was going swimmingly until I added a basic relation to one of my two extremely simple models. Since adding that relation and running
npx prisma generate VSCode Intellisense has completely broken, and hovering over anything that used to give me instant Intellisense just pops up "Loading…" that never seems to resolve. This includes non-Prisma related code like basic React components. Removing the relation and re-generating fixes it.
Is there something obvious that I'm missing?
```...strictUndefinedChecks undesired behavior
hey,
I am really happy to see the new preview feature
strictUndefinedChecks . However, I did run into some confusion testing.
When using it I notice that errors are thrown during create and update operations, specifically when an undefined value is used in the data object of the query. ...Queries hanging indefinitely
I am experiencing a weird issue. If I enable PrismaInstrumentation a small subset of queries in a large application begin to hang. The promises remain permanently unsettled.
Enabling debug logging does not reveal much about what’s happening, just that the query never runs. It shows that the last query is DEALLOCATE, which usually runs right before a query does. I have confirmed that no query is ever sent to the database despite a connection being established when this happens.
Disabling PrismaInstrumentation by commenting out “new PrismaInstrumentation()” fixes the issue. Disabling any other code does not fix the issue....
Initializing a specific connection string for Prisma Pulse
I'm currently using Prisma + Neon w/ tRPC hosted on Vercel. My Prisma is initialized using the DATABASE_URL connection string, which is a pooled connection.
Pulse requires a direct connection. Do I need to initialize a separate prisma instance for it to work, or will it work if I add a DIRECT_URL env variable to my deployment that contains the direct connection string (unpooled)?...
Migration from 5 to 6 for serverless project
Hello, I'm currently migrating from Prisma 5 to Prisma 6, and I have a serverless Lambda project that uses layers. My binaries were previously in the layer for Prisma 5, but now I'm wondering if I need to do any updates to that; does Prisma 6 still use binaries?
Specifically this libquery_engine-rhel-openssl-1.0.x.so.node...
Prisma extension stopped working in Cursor
hey, recently noticed the syntax highlighting broke for the Prisma extension on vscode/cursor - i've tried uninstalling and reinstalling. not sure what could be causing this.
happens with
schema.prisma file, as well as in the schema folder...
Billing support? Billing error
Hi, we were pro users until a couple hours ago. We downgraded and got charged 90USD for a monthly usage. However we downgraded before our billing cycle ended and a few weeks ago we paid the pro monthly suscription. To the best of my knowledge our usage was "covered" with the payment we made a few weeks ago. We want a refund and to close the account but our billing support cases get closed automatically since we are no longer pro users.
What can we do?...
Optimize not showing any queries
For some reason when I click on record it won't show any queries done but the accelerate works. (pnpm dev)
```ts
import { PrismaClient } from '@prisma/client/edge'
import { withOptimize } from '@prisma/extension-optimize'...