I know MongoDb allows this, but I was still wondering whether this is more of an edge case than an everyday feature:
Is it okay to have Documents in a Collection that are structurally not identical to each other?
I am currently working on a Products model whereby it is possible that some properties are not available (based on some user settings) and thus some fields would be completely missing whereas in other Products documents, again based on user settings, those fields might exist.
Is this a good / acceptable practice or is this a sign of poor data planning? Can this create pitfalls for optimisation/ errors down the road?