|
|
|
|
|
by Ferret7446
247 days ago
|
|
The problem with ORMs is that they're a very leaky abstraction. Database performance matters a lot for any non-trivial application, and in order to use an ORM performantly you need to understand both the underlying SQL+database but also all of the nuances of how the ORM maps to SQL. So basically you end up with two situations: 1. You need to hire engineers with double the expertise (not just a SQL engineer, but a SQL+ORM engineer). 1a. You hire a SQL engineer who now has to learn Yet Another ORM. 2. You hire engineers who only know the ORM but not SQL, and your app ends up having shit performance. Basically, ORMs are simply complicated SQL generating macro frameworks. They are way too leaky to provide a useful level of abstraction like most programming languages. LLM coding tools may displace ORMs, because they can take away a lot of the tedium with integrating application SQL, which is what ORMs are supposed to do. |
|