[off topic] is there an “official” Prisma prisma Slack theme, especially for dark mode? 👀

Hey! Checkout how to dockerize a NestJS app with Prisma and PostgreSQL https://notiz.dev/blog/dockerizing-nestjs-with-prisma-and-postgresql

Hey everyone, I have a question I keep asking to my self. What's the best way to implement category and sub-category? Before I was using 2 type (2 table) one for Category and another one called SubCategory and I link the SubCategory with the id of the Category with the field parentId in SubCategory.

model Cateogory {
  id String @id @default(cuid())
  name String @unique
}

model SubCategory {
  id String @id @default(cuid())
  name
  parentId Category @relation(fields: [categoryId], references: [id])
  categoryId String
}

But I don't know if it's the best approach. The second solution is to get all the category and subCategory in the same type (table) and link the subCategory with the parentId field and if the parentId is null it means it's a top-level category (not a subCategory).

model Category {
  id String @id @default(cuid())
  name String
  parentId String
}

In terms of performance, when I'm on the frontend I need to query all top-level category, select one then show only the children (subCategory) and select another one. Which on is the recommended way to do it? Thanks everyone!

For any front-end developers excited about Prisma, you might enjoy this post. I wanted to write a very high-level overview of your options for choosing a backend. Spoiler alert: Prisma on Postgres is a great choice if you have a bit of experience and want to build your own API 😄 Let me know if you see anything you’d change! Open to any feedback. https://leerob.io/blog/backend

😍😍

I guess this is a super beginner question, but unsure about the downsides of instantiating a new

PrismaClient()

in every file (e.g. in my controllers). Did not find any hints in the documentation… Or does it not matter as long as I call

.finally(async () => {
    await prisma.$disconnect()
  })

in all my

controller

/

route

/ whatever functions? Ty

How do you guys deal with Errors in Graphql? for example a failed attempt to authenticate because of the wrong password. Do you throw an exception of return a payload with a custom Error type?

ccccccickcjbckijcgrfdfcbgteuerultjnjbkiedjgd

Uh, that is interesting ...

hi all! i'm looking to hire javascript developers for some fun UI work. Fully remote. Contract to start, option to come full time. Preferred PST timezone, but open to flexible times. Figured this would be a good community to try to find someone. DM me if any interest!

Hey everyone 👋 there's currently an interesting thread on Reddit about the choice of a good TypeScript ORM: https://www.reddit.com/r/typescript/comments/icbey2/which_orm_should_i_use/ If you like Prisma, it would be awesome if you could share your honest experiences with it there 🙂

Thank you Prisma team for your gift! This made our team's day. We've also post this in twitter https://twitter.com/dooboolab/status/1299324615232090116. Thank you again for your kindness 🙏

I think I'm gonna make a video series about prisma on youtube

sort of a teach while learning thing

I'll try to do the topic justice. The docs are great so I should be fine.

Yo 👋 I wrote about making fungarzione.com/sizzy with Blitz + Prisma 2 in only a few days. It's seriously insane how fast you can ship with this stack 😄 https://kitze.io/posts/launching-fungarzione-with-blitz

I'll post the videos I publish on Prisma, I am planning on making many videos (5 videos in the last two days, goal of one per day moving forward) so tell me if I'm spamming and I will stop posting.

when you are writing a multi-tenant app, how do you name the

id

that you gonna attach everywhere,

companyId

or

tenantId

? 😄

Also did a reddit post of first impressions. https://www.reddit.com/r/typescript/comments/imapom/first_impressions_of_prisma/

The randomly selected thumbnail is funny, but I am going to pay someone on fiver to make a good thumbnail for the series.

I hadn't ever used sorting in prisma, and in the middle of the tutorial I just guessed how to sort on a relations field thanks to typescript autocomplete and a consistent syntax. Also, I have never pressed ctrl+space this many times in my life. Enjoying the development experience.

wait but oh my god I just published 4 videos without sound because I forgot to set up OBS

back to work

Ok videos are back up and are better in terms of introducing the right concepts at the right time now.

Tested out typegraphql-prisma and think it is very nice. I don't even really know graphql that well, but the syntax is just prisma so I could do what I wanted generally. It seems there is a bug with implicit many-to-many relations though. I will probably end up moving to a database workflow where I imagine the join table gets modeled explicitly with one-many relations, and I found that one-many relations worked.

probably should just learn more TypeORM though. It looks like I can just use that without the integration. The integration is just giving a bunch of code for free.

My video about Prisma 2 with @nikolasburk has moved to another channel 😅