3 ms·
> In the age of ORMs and so on, many people have probably forgotten how to write raw SQL queries. I’ve heard this general sentiment repeated quite a lot - most
by teaearlgraycold 3y ago
> In the age of ORMs and so on, many people have probably forgotten how to write raw SQL queries.
I’ve heard this general sentiment repeated quite a lot - mostly by people that don’t use ORMs. In my experience pretty quickly you reach the limits of even the best ORMs and need to write some queries by hand. And these tend to be the relatively complicated queries. You need to know about all of the different join types, coalescing, having clauses, multiple joins to the same table with where filters, etc.
Not that this makes you a SQL expert but you can’t get too far if you don’t know SQL.
- darylteo 3y agoORM abuse are absolutely rife in small-scale/volume build industries i.e. web agencies, outsourced crews 8/10 projects I look into don't have any indexes set up. Use of ORMs with little thought into lazily loaded relations lead to 100s of queries being done per request. It's pretty mad. Do not underestimate the propensity of a developer to stick to the only tool they know how to use. Unfortunately ORMs like Eloquent make it way too easy.
- teaearlgraycold 3y ago> small-scale/volume build industries i.e. web agencies, outsourced crews Well that could explain it. I’ve only worked in companies where everyone working on the app codes with the expectation that they could be dealing with their mistakes for years.