- Scenario involves building a platform where relational queries, aggregation, large paginatd lists are unavoidable.
- Data can be stored as json objects.
- Same database software (not db instance), will be the choice for multiple microservices involving users, orders, catalog etc.,
- Most of the micro services are written on nodejs.
- Small memory footprint, less db administration preferred.
Don't choose databases based on coolness. Choose a database that will keep you from being woken up at 3AM.<p>PostgreSQL managed by your cloud vendor would do everything you want, probably.