Re:Python: Just Write SQL
by jbreckmckye on Monday August 14, 2023 @06:38AM
(#37119438)
From my experience, ORMs allow folk who know nothing about databases to continue knowing nothing about databases
And from my experience, forcing people who know nothing about databases to write SQL will not make them learn about databases, all you end up with is worse SQL and more injections.
Although the worse offenders by far are those which decide ORM = bad and bypass it at every opportunity.
Re:Python: Just Write SQL
by jbreckmckye on Monday August 14, 2023 @09:01AM
(#37120551)
That's fair, ORMs can be slow but they rule out a whole category of basic mistakes
And introduce plenty more. over-fetching, unindexed joins across many tables being two of the more common.
Isn't that just a useful abstraction?
So let's ban ORMs because newbies don't know the entire toolchain. Yes, that will definitely solve it.
Why stop there? Let's ban RDBMS. If you can't contemplate a binary file structure and index strategy perfectly tailored to your application's needs ahead of using an RDBMS, why should we deign to let you use an abstraction layer with clever query planning and algorithms?
It's all too easy to morally 'ban' people from technology and gatekeep it behind wishy-washy nonsense like "ORMs are bad for beginners."
Re:Python: Just Write SQL
by jbreckmckye on Monday August 14, 2023 @08:41AM
(#37120370)
I'm not sure if you are trying to reply to a different thread, but this level of hyperbolic attack is unwarranted. I have said nothing about "morally banning" people from using databases.
Re:Python: Just Write SQL
by jbreckmckye on Monday August 14, 2023 @09:00AM
(#37120540)
(this was a flippant remark, if I could edit it I would reword it)
C allows people who can't build a CPU from NAND gates to do programming :P
You're conflating ORM with people who know nothing about databases. Why?