Hello there,
I am evaluating ScyllaDB for purpose of creating an application that would be in Reddit style. So, I have like Subreddits (Topics), Posts (Questions) and Comments (answers for that specific post).
Do I need to separate tables for Topics, Questions and Comments? Do they need to have some between them with relations? Performance-wise, what is the best model?
What do you think about this proposal? And should I have relations between them.
The best model depends on what you expect to be the most common query.
You should start with listing queries. e.g. all posts for a subreddit, all comments within a post, and weight them by frequency and importance. The table structure will be derived from that.