I have two tables in DB. One is users and another is follow_system.
whenever somebody follows a user it got pushed in follow_system but the problem I am facing is it is not reflecting in real-time on the client side. So what is an effective way to update the cache when I am mutating the follow_system table but want to update users?
Tables Structure:
follow_system{
id: bigint!
follower:String;
following: String;
}
users:{
id:Int;
username:String;
email: String;
}