Do you use relational and document-oriented subds in the same project?

Question

SQL

Hello! Have you ever worked on projects that use both a relational database and a document -oriented database ? For example .. Perhaps someone had a case that user profile data was stored in rdbms and, moreover, operations on accounts were performed as part of transactions of this sudb, and all other data (related to these users or not) are sparse documents (for example in MongoDB as BSON).
You can forget about Redis in the context of this question. Redis - key-value dudb.

Answer 1

Yes, this is more than a normal scenario. Let's say store everything in postgresql and do data aggregation to speed up selections in some kind of elasticsearch or mongu.
And if you also practice CQRS , then generally nishtyak. Then our commands will work only with postgresql and initiate the update of aggregations, and queries - with elastic.

Answer 2

The transaction is stored in mongodb, but in parallel it is necessary to pour some of the data into SybaseIQ. This is needed mainly to calculate various perverted reports for business; in Monge this will not work.

Answer 3

Yes, we apply. All data that has a normal schema - in postgres, data for which there is no common schema (including custom attributes for domain entities - various notes and comments, its own set for each user) - in mongo.

Answer 4

Yes, I had to. What is the question?