News for hackers. Stuff that matters.
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
Re:Python: Just Write SQL by masklinn on Monday August 14, 2023 @06:58AM (#37119566)
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
Re:Python: Just Write SQL by tracker1 on Monday August 14, 2023 @01:09PM (#37123581)
And introduce plenty more. over-fetching, unindexed joins across many tables being two of the more common.
Re:Python: Just Write SQL by wnolens on Monday August 14, 2023 @07:21AM (#37119735)
Isn't that just a useful abstraction?
Re:Python: Just Write SQL by mickeyp on Monday August 14, 2023 @07:47AM (#37119920)
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)
Re:Python: Just Write SQL by boxed on Monday August 14, 2023 @09:14AM (#37120669)
C allows people who can't build a CPU from NAND gates to do programming :P
Re:Python: Just Write SQL by felipetrz on Monday August 14, 2023 @10:22AM (#37121358)
NAND gates allow people who can't build transistors from self-mined ores to build CPUs.