[intesar]

Most apps these days use document store like MongoDB and ElasticSearch for storing and scaling data.

We do use a RDBMS as well but mostly for the transactional part and we get away with just using simple SQL, no join and complex stuff.

[redwood]

It's something of a misconception that an RDBMS should be used for transactional workloads.

RDBMSs are table stores; in a sense if anything that's a model better suited for analytical than transactional not that that's really a fair conclusion either