News for hackers. Stuff that matters.
Re:12 requests per second: A realistic look at Python web fr... by lordnacho on Friday February 19, 2021 @04:03AM (#26191042)
IMO both are required. I'm lucky in that I did a lot of plain SQL early on, and found ORMs later, but I think ORMs do cut out a lot of time for quick-and-dirty queries that end up not being the bottleneck. The problem arises once you find a bottleneck, you won't know how to optimize it if you haven't done a bit of SQL mucking about earlier.

Also, the big thing is you won't know how to translate to other ORMs if you don't know SQL. Eg once you know that you want an index, it's a matter of a web search to find out what the syntax is in your ORM. But if you just started with ORM, you might not realize that kind of thing is part of how it works.

Re:12 requests per second: A realistic look at Python web fr... by kaba0 on Friday February 19, 2021 @06:17AM (#26191876)
Yeah, ORMs are specifically made for insert-heavy operations or very basic mapping of rows to objects. Analytical queries and the rest should be done with SQL.
Re:12 requests per second: A realistic look at Python web fr... by jtdev on Friday February 19, 2021 @08:53AM (#26193120)
I keep seeing some variation of: “ORMs are really intended for x” or “ORMs work best when y is true”. At some point we should take an honest look to determine if ORMs provide enough benefit to justify their existence. “I can talk to the database without knowing SQL” doesn’t cut it.
Re:12 requests per second: A realistic look at Python web fr... by kaba0 on Friday February 19, 2021 @12:33PM (#26195530)
Yes they do? They are basically available in every language, in some ecosystems there are multiple alternatives as well and there would not be that big of a market unless it is useful.