I am working on a Xamarin.Forms PCL social media app project. People can like posts and comment on them which is saved in MySQL. I would like to add an activity page.
What is the best way to calculate users activity, I don't think UNION will work since the comments table has a different structure than the likes table.
I was considering creating an activity table which would be "userid|message|timestamp" then just grab all those but that doesn't seem very efficient.
Also how do I prevent spam of notifications if a user likes/unlikes a picture multiple times to spam another user?