11 ms·
agreed, you can have reference fields to other collections and filter by them or query related data. But I wouldn't say its designed for relational workloads. S
by skatanski 3y ago
agreed, you can have reference fields to other collections and filter by them or query related data. But I wouldn't say its designed for relational workloads. Similarly I wouldn't use MongoDB for graph queries, even though it has an operator for just that.
- mgfist 3y ago> agreed, you can have reference fields to other collections and filter by them or query related data. Yes it has that, but that's an anti-pattern. What I'm referring to is schema design. In Mongo you denormalize and store relational data in the same document as references. In SQL you a record might be split up into 3 tables, in Mongo that should all live in the same document. If you can't embed and need lookups, you should avoid Mongo and other nosql DBs