https://hasura.io/docs/latest/graphql/core/event-triggers/index.html How would you solve such a use case with prisma?

The use case is if the user updates his reminder settings, all the reminders must be updated.

Hey my company moved from TypeORM to prisma

using the same env variables and server, we have this issue:

does someone why It can happen? error p1002

What's the best way to fetch a tree?

include

only populates immediate children. Is there a recursive include or do I have to build the tree myself? What if I want to order/filter/limit the roots? I want to avoid having to do multiple queries.

Hi. What is the advice or consensus regarding source code management of the Prisma Migration files? Should I include them or exclude them in my Git configuration?

Are there any workarounds for the lack of unions? I want to show a feed of several models ordered by time. Currently I query each one and merge sort them on the client which seems like a terrible hack. See https://github.com/prisma/prisma/issues/2505

Hey! Are there any plans on saving seeds that are already in the database? Eg people update the seeds with studio and I want to update my older local seed data?!?

How can I change mysql column name using migration without data loss ?  The above case is possible when the default is null and when there is no data https://www.prisma.io/docs/concepts/components/prisma-migrate/prisma-migrate-flows The below DDL can be changed without any data loss and that’s what I want. “alter table user change name name2 varchar(191)” The attempts I have tested are as follows. But it failed. 1. Directly modify DB with DDL 2. Modify schema.prisma 3. prisma migrate dev --preview-feature Is it possible to change the column name without default null without losing data by migration?

Hey friends 👋 We just wanted to give you a heads up that the MySQL content we've been working on for Prisma's Data Guide has been published. Please let us know if you have any feedback! https://www.prisma.io/dataguide/#mysql

Hello everyone 👋 I published an article on how to deploy Prisma in an AWS Lambda, with Lambda layers using Serverless. There’s also a repo with working CI/CD for your convenience 😉 https://dev.to/eddeee888/how-to-deploy-prisma-in-aws-lambda-with-serverless-1m76

Hi Everyone I have a question about schema.prisma file that been generated. I do not want to store env("DATABASE_URL") connection user name and password in repository for safety but instead I bring them from AWS System store parameter. more safe. is there a way I can transform the schema.prisma into a function so I can make a call to grab all of these secret values to make a connection ?

You shouldn't have to do anything special, you can pass in the params as an environment variable and prisma should pick it up

when you do this

datasource db {
  url      = env("DATABASE_URL")
  provider = "postgresql"
}

this means at runtime tell prisma to look for a DATABASE_URL environment variable

you can also override it in your code like this

export const prisma = new PrismaClient({
  datasources: {
    db: {
      url: get_url()
    },
  },
})

@thdxr is something like this would be valid

const prisma = new PrismaClient({
  datasources: {
    db: {
      url: await get_url(),
    },
  },
})

hi there! I am newbie in prisma. should I memoize client object in controllers or I can build new client object in each controller?

Hello ! I'm a user of Prisma 2 for almost 1 year and I'm here to give some feedback and get some help 😄

👋

Are there any plans to introduce an option to get the count of all items for a query in addition to a slice of those items for pagination? Right now you have to use .count() separately.

Hi everyone - can I have multiple data sources in the same time with diffrent urls? like communicating to db of type mysql and another url with nosql db?

Hey guys, working on some seeding scripts, wondering if theres anyway to return a query in seeding scripts: example:

being able to return the id of the user with the email

Hey, everyone! 👋 Fortunate to be present here in this awesome community. I want to introduce you all to the 3rd edition of* UtkalHacks,* a 15 days long hackathon where teams gather together to build & launch their side projects. Applications are open to designers, developers, students, and professionals alike! UtkalHacks truly promotes open innovation and teams are free to work on whatever they want. However, we also actively help everyone to discover useful problems to work on. And we also want to expose everyone to some emerging domains through our awesome talk sessions at UtkalHacks Summit. While we believe true hackers build out of passion but we anyway got some perks that might help you push your limits and get that side project built! 🙂 • Winners: Prizes worth ₹30,000 + Special Prizes • Runners up: Prizes worth ₹20,000 + Special Prizes • Prizes for Best Girls Team,* *Best Design Team, and Best Beginners Team We are also focusing on long-term & useful prizes that will help passionate hackers continue building even after the hackathon! 🎉 • Lifetime* *Subscriptions of Threejs Journey • 1 year Subscriptions of Egghead • Access to FigmaAcademy • Access to Smashing Magazine Ebooks and Membership • Pro account of Spline • More to be announced soon... Applications are closing soon! The last day for the registration is 3rd March. Let's not linger and submit your applications at 👉 https://utkalhacks.tech/ P.S. Join in on the conversation on our Discord and tune in to all the announcements on our Twitter.

Hello Team, I am unable to access v2 at https://prisma.io/docs Is the website down?

hi all, I’m have a question does not related direct with Prisma, but related to my system. Anybody please advise me. I want to build a webpage using nextjs, and api using node + prisma. My estimate system will have capacity to serve for 10k concurrent user (CCU). How to determine how many resource to use? for example. I’m using Google cloud, how many CPU, RAM necessary. Many thanks.

hey, trying to run prisma in a docker container on an m1 and getting “Error: Unknown binaryTarget linux-arm-openssl-undefined and no custom binaries were provided” — I feel like I don’t understand the open issue, because it seems like there’s probably a way to get this working somehow, just with custom binaries… does anyone have any recommended reading that’ll point me in the right direction for this?