For Want of a JOIN

Re:For Want of a JOIN by Beltiras on Thursday December 22, 2022 @10:29AM (#34094280)

I interact with SQL on a daily basis but never write a single query by hand. It's all abstracted by the Django ORM. I do have to be mindful of what I do of course but mostly I just plow away with the abstractions offered. Once in a while I have to take a look at the SQL or the query plan but those are few and far between.

[ Parent | on HN ]

Re:For Want of a JOIN by pphysch on Thursday December 22, 2022 @11:56AM (#34095502)

Sure, but there's a world of difference between someone who knows SQL and uses a ORM for productivity and someone who uses an ORM because it's the only tool in their box.

[ Parent | on HN ]

Re:For Want of a JOIN by ttfkam on Thursday December 22, 2022 @10:53PM (#34102182)

Exactly. Effective use of an ORM requires knowledge of the ORM's API in addition to SQL, not in lieu of it.

Using an ORM without a firm understanding of SQL is a recipe for disaster (or at least glacial performance).

[ Parent | on HN ]