so we were again discussing our data model for e-commerce app.
Problem was that we had some data per product, but than many relations pointing to other products, similar products etc.
It does not felt very good to copy most of user facing data accessories and variants arrays and keep them consistent all the time.
Especially when our prices need to change a lot as a response to outer inputs.
Than we identified that for every product we want to have relations based on variant to variant basis and querying such thing become nightmare.
Now we are considering that most of our data we would keep normalized and mongo will be used as data store to keep them consistent.
And most of views etc will be generated using ElasticSearch outputs where we want to utilize parent-child relationships.
Subscription updates sounds kinda counterproductive anyway, as you dont want to shuffle items in user view while he is trying to click it.
And some live graphs etc could be done responsive way, but that is admin interface stuff and other story.
Any1 else went this way and have some hints?
Or we will hit some hidden wall which we do not see now ?