Hey all, we are starting our Prisma Meetup: CockroachDB edition in half an hour! Come, hang out in the chat and win a copy of the “*CockroachDB: The* The Definitive Guide” book in the raffle. 🎁

The meetup is running! Come join to enter the raffle and win the “*CockroachDB: The* The Definitive Guide” book ☝️

That was a fun meetup. Looking forward to continue using both of them in my applications 😄

I’m not seeing any information in the docs regarding maximum query sizes, etc. for various providers. As an example, I’m querying 20k records from a PGSQL table with sizeable JSON fields. As it stands, I can request about 12k records in a single query before it crashes with:

Failed to convert rust `String` into napi `string`

I realize this has to do with “underlying technologies”, (and yes, I should certainly be batching my queries ) but besides a couple of vaguely-related GH issues dealing with the

Node

version, I’m not really seeing anything on it. Any guidance/best practices on this besides “don’t run big queries”? 😆

I always batch these queries regardless. 1000 or 10k depending on the data

Anyone here using Prisma for MongoDB in production? I noticed a sharp drop in performance since we switched to Prisma. After logging the queries, they seem to be pretty complex for simple use-cases. Also, tons of

WriteConflict

issues.

Hi, i get this warning on a regular base:

▲ [WARNING] Comparison with -0 using the "===" operator will also match 0 [equals-negative-zero]
 
     prisma/dist/runtime/index.js:17308:29:
       17308 │             } else if (x === -0) {
             ╵                              ~~
 
   Floating-point equality is defined such that 0 and -0 are equal, so "x === -0" returns true for both 0 and -0. You need to use "<http://Object.is|Object.is>(x, -0)" instead to test for -0.

I dont know how to get rid of it,any suggestions? Thank you

👉 Let’s build a REST API with NestJS and Prisma - Tasin Ishmam I Prisma Day 2022 -- -- NestJS is one of the hottest Node.js frameworks around. In this workshop, you will learn how to build a backend REST API with NestJS, Prisma, PostgreSQL and Swagger. By the end you will have learned how to: ✅ Build a REST API in NestJS ✅ Integrate Prisma into a NestJS project ✅ Document your REST API with Swagger ✅ Validate incoming data to your API ✅ Implement error handling 000000 Welcome and Introduction 000551 NestJS Recap 000750 Lesson 1: Set up Prisma, PostgreSQL and NestJS 003328 Lesson 2: REST API - Create, Read, Update, Delete Operations 005508 Lesson 3: Input Validation 010158 Lesson 4: Error Handling 010922 Lesson 5: End-to-end Testing 012442 Conclusion and Additional Resources Resources: 📓 Find all instructions in this Notion document: https://pris.ly/day-22-nestjs 🐈‍⬛ The code for each lesson is available on GitHub: https://github.com/TasinIshmam/nestjs-workshop-prisma-day-22 🐦 Connect with Tasin: https://twitter.com/tasinishmam

Hello! Thanks for you hard work, all the contributors! I'm new to Prisma and got into an existing project for devops task. What I'm looking for is a way to migrate from prisma 1 cloud, which will be deprecated very soon, to self-hosted prisma v3 infrastructure. Code base has been already migrated to use Prisma v3 APIs, so this is specifically for hosting the prisma infrastructure. Assuming that we've already hosted our new MySQL database on the AWS RDS, what steps should I follow? And, Is this docker image legit for production deployment?

prismagraphql/prisma

Hi! I am struggling with integrating prisma in a monorepo

apps/server

should get the client from

packages/db

where prisma and the db runs. Any tutorials or hint's? Ideally with nexus and prisma-nexus. thanks! 🙂

Does anyone know how to do a mongodb unordered insert using the prisma client. ( i want to insertMany and skip/ignore any duplicate errors )

Good Morning. How would I get help with a Supabase integration issue I am having?

I have a project I'm working on and Supabase is the DB and I'm using Prisma Client with it. Everything in dev is functioning as it should. I'm getting my data back from my supabase DB. Now, when trying to deploy it on both Vercel and Netlify, everything is building fine with no errors but I am getting a 500-Failed to load data error when loading the pages consuming the data. I read the supabase docs on adding a shadow DB connection, so I did this and my migration and build was successful and still everything is functioning properly. I updated my ENV vars with the shadow DB and deployed. All deployed without errors except I'm still getting the 500-Failed to load data error. Any insight would be appreciated! Currently I have figured out that it works fine on the first migration, then it seems to change something in supabase because after further migrations, the data becomes unavailable. I saw a couple posts that talk about this. So everything works as expected in development, connected to Supabase...once I deploy it to lets say Vercel or Netlify, Data becomes unavailable. I've even added a shadow DB that Supabase and Vercel recommend. Has anyone had this issue before? Would appreciate any help I could get. Thanks!!!

For a production project of ours I want to run Prisma 1 and Prisma 4 side by side which should be possible according to https://www.prisma.io/docs/guides/upgrade-guides/upgrade-from-prisma-1/how-to-upgrade#upgrade-strategies. However, when I try to run any prisma 4 command like

init

I get an error saying a Prisma 1 project was detected and the command is aborted 😕 Does anyone know how to work around this?

Hi, I'm getting this Bad Gateway error for couple of days while accessing my Prisma Portal, Can anyone please help what could be the reason for this?

does anyone know if there is a equivalent prisma feature to this sql query? I tried to use ''aggregate'' but didn't suceeed, here it shows aggregations but without calculations https://www.prisma.io/docs/concepts/components/prisma-client/aggregation-grouping-summarizing

SELECT SUM(p.amount * p.value) FROM products p WHERE p.id_tenant = 1;

Hey I got a question that I hope to get some help with

I got this error

I didn’t quite find any useful stuff by googling.

Any clue?

Hi, I just asked a question about “Get Permissions when User is queried” on GitHub Discussion (https://github.com/prisma/prisma/discussions/14205). Could somebody help with me? Thank you very much

👉 Update while you wait: Optimistic UI with Remix and Prisma I Prisma Day 2022 -- -- Learn to build state-of-the-art, highly responsive user interfaces with Remix and Prisma. This workshop focuses on the pattern of optimistic updates, teaching you how to use the best of both tools to build interactions that feel instantaneous to users. At the end of this workshop, you’ll know how to: • Reduce latency and remove loading spinners for a snappier user experience • Use more advanced Remix tools like useFetcher • Gracefully handle errors • Optimize requests with Prisma’s functional API and Remix’s loaders and actions 000000 Welcome and introduction 000635 What is Remix? 004308 Data Loading 005954 Mutations 013844 Optimistic UI 🐦 Connect with Chance: https://twitter.com/chancethedev 🧪 Learn more about Remix: https://remix.run/

Hi, can we create postgres access policies with prisma? It would be awesome if possible within the .prisma schema.

I am trying to migrate to Prisma 4.0.0, but BigInt json serialization is not supporting, so everything is failing, is 4.0.0 not a stable release?

somehow this is casted to bigint, any way i can hint this?

This message was deleted.

Hi friends 👋

is it possible to add a new record and connect it to more than one data belonging to a table where there is an implicit relationship between them? the data from the other table is passed in an array.

Hi folks! We're big fans of Prisma! Such big fans that we've generated 80 migrations over a few months of using Prisma 😄 Each migration makes

npx prisma migrate dev

a little slower, so development is getting more painful over time. Is there a way to archive or combine old migrations, so that

migrate

remains fast? Thank you!