Likes system

[DZ8540]

I need help with make like system in adonisJS application.

I tried make likeStatus in model

And make method for use likeStatus

And use it like this

And... this is works! But! When i'm used CRUD operations except get from DB, application throwed error like this

I suggested to my employee to keep all likes array with other used data, when it logged in, and set like for posts and stories in frontend side. But he told me it's not right because this array might be too big.

What is the right thing to do in this situation?

[galaczi]

If I understand you correctly, you want to check if a user liked a post. In that case why not simply use many to many relationship and query that user - item combination? If it exists, the user liked the post.

[galaczi]

You can preload the likes on the posts and then paginate them. Something like:

const posts = await Post
  .query()
  .preload('likes')
  .paginate(page, limit)

[DZ8540]

This is preloaded all likes from all users, is there an other way?

[galaczi]

I am pretty sure it preloads only the likes belonging to that page.

[DZ8540]

For each post on the current page, all users who like each post on the current page will be preloaded. The request will be very heavy, i can of course selected only users' id inside preload query, but query still be very heavy for this way(

[DZ8540]

It would be great if i could make a request to search the table for the id of the current user, and then just attach the status to the post, but i dont know how