loading...

re: Convince me to use SQL VIEW POST

TOP OF THREAD FULL DISCUSSION
re: You can still easily do relational data in NoSQL. The difference is for relational data in NoSQL you need to know ahead of time the specific access...
 

have known and consistent access patterns

It would be impossible NOT to be known and consistent, actually.

I believe denormalized database is fast, but how much can I trust aggregation framework? Especially on the $lookup part.

The real problem that cannot be denormalized here is -- MongoDB cannot have nested objects that are passed by reference. (I saw closed issue on this somewhere.)

It's not impossible to have known and consistent access patterns. There are many apps that can have known patterns, even with NoSQL it's not impossible to add new access patterns just a little bit harder.

I also do not use $lookup I do not use MongoDB at all. I use DynamoDB mainly.

Code of Conduct Report abuse