"weighted" newsfeed

This isn't trivial. There are 100s and 1000s of variables that goes into weight calculation, including but not limited to other user's interaction with certain feed. Plus, the weight calculated for a certain event will be different for you and me.

Start by studying the variables that define your event.

I't should not be that complicated. It's more about a concept on how to calculate such a weighting "on the fly" (or not).

Fairly trivial... Include a signed integer field to store the 'weight' value, default everything to 0. If a particular item needs to be 'better positioned' give it a lower (negative) number, if it should be toward the end of the list of items, give it a higher (positive) value. Then always include an orderby on the weight, in ascending order so lower values bubble up to the top. If you need to also sort by other criteria, use multiple orderby's.

It really doesn't need to be more complicated than that. Now, if you want items to float toward the top based on their popularity (how often they're viewed, etc) you could include some additional logic to dynamically update those items' weight values on the fly. You can of course complicate it as much as you want, but really.. a simple signed integer that is used with an orderby is probably sufficient.

If not -- give specific examples of what you need to achieve that you don't think that will accomplish. :)

Fairly trivial... Include a signed integer field to store the 'weight' value

I didn't realise you were just looking for this. I thought,, it was more about how you calculate the weights

Also, but it seems that I approached it the wrong way :) I've also found a nice post about building newsfeeds: http://blog.gainlo.co/index.php/2016/03/29/design-news-feed-system-part-1-system-design-interview-questions/