Where is the best place to get help / advice for developing with Prisma? I have a question regarding how to set up my model in my schema.

Hey Douglas! 👋🏼 You can ask here! I’d love to help 😄

Cool, thanks! I was wondering how I would create a model to solve a problem where a User can save a list of other Users in addition to a related number to them. The problem is basically a following / followers structure, with an abstract number of "how many times have I clicked on this person". I think I have managed to solve it using this structure, in this GitHub issue: https://github.com/prisma/prisma/issues/2217

model Follows {
  follower    User @relation("follower", fields: [followerId], references: [id])
  followerId  Int
  following   User @relation("following", fields: [followingId], references: [id])
  followingId Int

  @@id([followerId, followingId])
}

model User {
  id        Int       @default(autoincrement()) @id
  createdAt DateTime  @default(now())
  followers Follows[] @relation("follower")
  following Follows[] @relation("following")
}

But where I have also added a field for

model Follows {
   // how many times the person has been clicked
   clicked Int
  ...

So in the end, I think this solves things? I guess the only thing I might want to change is that I don't want to know if someone has any followers, simply how many times they have clicked a specific user.

Just add a clickCount field to your Follows table. Problem solved 🙂.

Thanks!

I am adding followers / following to my schema too and went for a self relation:

model User {
  id        String  @id @default(cuid())
  following User[]  @relation(name: "UserFollows")
  followers User[]  @relation(name: "UserFollows")
}

is this a bad idea? Would it be better to have a separate model for this and store (and maintain) the count on

User

(for perf reasons?)

Hey @Giuseppe 👋, That is a known bug (https://github.com/prisma/prisma/issues/7299 https://github.com/prisma/prisma/issues/7893) and will be resolved in the near future. In the meanwhile, I would suggest using the explicit many-to-many notation as suggested above:

model Follows {
  follower   User @relation("follower", fields: [followerId], references: [id], onDelete: Cascade)
  followerId Int
  followee   User @relation("followee", fields: [followeeId], references: [id], onDelete: Cascade)
  followeeId Int

  @@id([followerId, followeeId])
}

model User {
  id        Int       @id @default(autoincrement())
  name      String
  createdAt DateTime  @default(now())
  followers Follows[] @relation("follower")
  followees Follows[] @relation("followee")
}

I just tested and the selecting relation counts works with this approach.

awesome thanks a lot for the help!!!