What is the best way to implement a base for a project with configurable news feeds?

Question

PHP

A project for a group of bloggers with a narrow theme, about 50 bloggers who post 2-3 posts a day. A lot of different types of data is attached to each post, for example: tags, categories, locations, colors, etc. up to 10 types.
Several hundred thousand registered visitors per day. Users subscribe to any of the possible binding parameters to posts, and based on this, news feeds for users are formed. Plus, unlike social networks where there are only personal feeds, there is a home page where you can change it on the fly by selecting groups of parameters.
question: when implementing a project in php (laravel), what is the best way to design a database and how to work with it? use only sql database or in combination with nosql? whether to use sharding? how and what is better to cache?
thank!

Answer 1

Since no one answers, I will write briefly my opinion, although it does not affect all issues.
I think that it is quite possible to try mongodb. Tags, categories, etc. store in the posts themselves in arrays. Use separate collections for feeds, update them if the user changes the feed settings.
As for the home page - I did not quite understand what can be changed there, so I will not say anything.
Several shards can be made if the base cannot cope. Here it will be necessary to look at bottlenecks and then decide what exactly and how to distribute.