3 ms·
You can create indices in MongoDB on JSON, works pretty well. And since 4.x they have transactions over shards too!
by pas 7y ago
You can create indices in MongoDB on JSON, works pretty well.
And since 4.x they have transactions over shards too!
- tabtab 7y agoBut the "interface" to the JSON data is different than regular columns, and arguably awkward. The dynamic relational assumption is that one can use regular SQL just like with regular "static" tables (with some minor differences to make compare-type more explicit).
- pas 7y agoI find SQL much more awkward than proper language-idiomatic APIs. Yes, SQL shines when you can whip up a big multi-table join, with nice group by-s and wheres, havings and whatnots, but that's rare. Though, arguably, ORMs solved most of the crazy string concatenation query crafting craziness.