Ja, but you need an index for each thread, some kind of time partitioned thread index for each community, same for all.
Then you need to query all comments or posts by user, so that’s another index, then you need some way of querying for hot, or controversial or what have you.
It’s doable, but fiddly. Tempted to have a go though!
I just mentioned Dynamo as an idea without thinking about it too much.
Dynamo works well for one and two dimensional data structures but for more complex things you probably want a regular database. I expect it could be done efficiently but not at a good cost and without tons of technical difficulty.
Ja, but you need an index for each thread, some kind of time partitioned thread index for each community, same for all.
Then you need to query all comments or posts by user, so that’s another index, then you need some way of querying for hot, or controversial or what have you.
It’s doable, but fiddly. Tempted to have a go though!
I just mentioned Dynamo as an idea without thinking about it too much.
Dynamo works well for one and two dimensional data structures but for more complex things you probably want a regular database. I expect it could be done efficiently but not at a good cost and without tons of technical difficulty.