3 ms·
SQL orm feel kludgey because they are, entities on rdbms are normalized in their fractional parts and interconnected by a multitude of relations so that you hav
by LoSboccacc 6y ago
SQL orm feel kludgey because they are, entities on rdbms are normalized in their fractional parts and interconnected by a multitude of relations so that you have multiple entry point to obtain different views of the same data and multiple ways to organise and prune results to find interconnection across multiple entities
once you reduce all that to object traversal all your options are lost, your only entry point is the entity and the only connections are direct paths
it's not the underlying query language, it's the flattening to object
- willtim 6y ago> it's not the underlying query language, SQL and it's implementations do not support nested relations. The parent is suggesting that e.g. nested relations would enable better ORM solutions.
- LoSboccacc 6y ago> nested relations parent was right that hierarchical queries are not well supported, but that's not the same as outright using nested relations; also if you're not going to store data following normal forms for convenience no wonder sql is going to have a hard time querying it. at which point you're better off with an object storage and a searchable index to the side anyway