I am asking actually which kind of data store / data format shall I choose to persist posts + reply threads (very similar to facebook posts or stackoverflow posts)
I am designing for a new application and I don't want to suffer later for the performance
I browsed a bit to check for an answer to my question , but all I found actually was "How to tune an RDBMS design to handle this requirement"
But is really RDBMS is the best fitting for this ? most answers where somehow outdated or wanted to tune some legacy systems and No-SQL DBs are not considered hence.
I thought about storing the entire thread as one json for the sake of fastread performance But also I think it will make a problem for update , maintenance and traffic specially because I need to apply security roles on thread component (some users can see some replies, others not)
Any recommendations or references are appreciated