Want to be a part of great coding community where you learn and connect with people and also participate in various giveaway of courses ? Then do join here https://discord.gg/SXYE4Z6REg

This message was deleted.

Hey, I was wondering if there was any way to have a field called profile in the review model that can be either a Teacher or a Student so I don’t need different review models for each of them. Let’s assume that student and teacher are so different to each other that integrate both together it would be a bit confusing, but I know it’s an option

model Student {
    id           Int          @id @default(autoincrement()
    createdAt    DateTime     @default(now())
    updatedAt    DateTime     @updatedAt
    reviews      Review[]
}

model Teacher {
    id           Int          @id @default(autoincrement()
    createdAt    DateTime     @default(now())
    updatedAt    DateTime     @updatedAt
    reviews      Review[]
}

model Review {
    id           Int          @id @default(autoincrement()
    createdAt    DateTime     @default(now())
    updatedAt    DateTime     @updatedAt
    text         String
    profile      Student or Teacher?  @relation(fields: [profileId], references: [id])
    profileId    Int
}

Hey wonderful people, I have a quick question regarding Prisma.io nodejs client, I noticed that there is a “Pricing” section in the site and I’m wondering if it includes some cloud solution or its just for the usage of the ORM and if so, can you elaborate a bit on how you measure our usage? Thanks!

Hello, I was wondering if there was any way to store enum with the caractère “-” like in locale codes :

enum LocaleCode {

es

en-GB

}

Hello everyone, can you explain me about this channel?

Does prisma support composite indices for postgres?

I'm currently interviewing DevOps engineers for a new Youtube channel about DevOps. I'm focussing on your personal story into DevOps and the ups and downs working in the field. If you are have a good 'most annoying question devs ask' or a funny on-call story to tell, drop me a pm 🙂

Looking for a backend/prisma orm/node express consultant to plug into what we're building ahead of a Q4 sprint (would be happy for longer-term too!) still stealthy but our page: https://hearth.ai Email me if you or someone you know might be a fit! ashe@hearth.ai 🙏

Having some real issues getting this working as a stored procedure

"CronEvent" refers to the table. I think in the WHERE clause you need one to refer to the table and one to refer to the parameter. I would try replacing

WHERE "CronEvent"."id" = "CronEvent"."id"

with:

WHERE "CronEvent"."id" = "id"

how to multiple fields from same model refer to another one model model . for ex: model tbl_delegate_map { id Int @id @default(autoincrement()) self_user_id Int? self_user tbl_user? @relation(fields: [self_user_id], references: [id]) delegate_user_id Int? delegate_user tbl_user? @relation(fields: [delegate_user_id], references: [id]) } model tbl_user { id Int @id @default(autoincrement()) self_users tbl_delegate_map[] delegate_users tbl_delegate_map[] }

Can Prisma maintainers give directions on how to implement this: https://github.com/prisma/prisma/issues/10425? I’m happy to contribute

I started a new podcast! solutionsfromthemultiverse.com New unheard of solutions to the world’s biggest (and smallest) problems—with jokes.

okay so i have this serverless lambda application where im including prisma dependencies as a layer My question is, if i run a migration on the db, thus need to create a new client in the layer, do i need to redeploy the layer to run that script?

I see that the official prisma documentation website uses PrismJS for syntax highlighting, any ideas on how to get it supported? Looking at

<https://prismjs.com/download.html#themes=prism&languages=markup+css+clike+javascript>

prisma is not among the available languages, and if it's not possible, any ideas on what's the next best thing to use?

Hi! Is prisma planning to add official rust support anytime soon? :)

Isn’t the “new fetch pattern” turning things into the same as they were before graphql? When using graphql, the idea is to ask what you need and only what you need, for a whole page, using a single request. Preventing request “race conditions”(lack of a better term), separate requests asking for the same data like user name. With things like Layout RFC and React Server Components, and even hooks, theoretically each component now should be responsible for fetching its own data. Don’t get me wrong, DX wise I prefer this way more over than the prop drilling pattern of having a query run in a

/page

, then passing

data

or

data.whatever

down to each component But if each component is now doing its own request, we’re coming back to the REST pattern anyway. Each component does its own request, and separate requests asking for the same data like user name. It’s just being done in a different way... But it’s the same thing. The only big difference I see is the apollo cache if using apollo

Hello

I come as a sequelize refugee

If you’re using prisma in a pnpm workspace inside a

packages/db

package, consider adding a

prisma

script to the workspace root, so that you can run all prisma CLI commands from the root naturally:

# from your workspace-root:
pnpm prisma generate
pnpm prisma migrate dev
pnpm prisma db push

looks like this:

{
  scripts: {
    "prisma": "pnpm --filter db exec prisma"
  }
}

Wrote it about it here.

Hi all, I need some help in DB design I am not sure which is the right channel for that

Hello world!

Hello, please is anyone working on graphql for microservice using prisma for the database?

is there a way to streamline picking up prisma client model updates in vscode? I Find myself having to reload windows just to get intellisense to pick up changes

I appreciate this isn't really a prisma question though but thought someone here might've gotten too annoyed with it too

Hello everybody, my friends have built this website for walking routes around the world and they’re currently running their first competition 🎉 The prize is £100 Amazon voucher 💰 Check it out here: https://walkly.com/blog/competition-october-2022

Does anybody have any recommendations on npm libraries that help with parsnig a query string to prisma filter? Like https://github.com/fox1t/qs-to-mongo but understands Prisma syntax

hi there. Has anyone ever managed to make fulltextsearch preview feature working with pg? No matter how I create the index, the client seemingly sends in the request with

WHERE to_tsvector(concat_ws(' ', "test"."Test"."barcode")) @@ to_tsquery($1)

instead of the index created for this pupose. is this intentional and the pg should solve the query planning? or i am missing something in the docs?

Hey everyone, not sure if this is okay to put here, feel free to remove if not. I’ve gotten a lot from this community, so I’d really value any feedback anyone has. I’ve been working on a project in my spare time (with Prisma 😉 ), it’s a dead simple API that lets you shoot out email, slack, and text message alerts to your team when important things happen in your software. Would really, really appreciate any feedback on why you think this would or wouldn’t be useful, before I invest any more time into it than I already have 😅 https://devalerts.io