ORM and SQL … I mean it’s lived up to the bad side of the reputation.

It hides it. As someone said here:

"Osiris on June 18, 2021 | unvote | parent | context | favorite | on: DenoDB

I hate ORMs with the fury of a thousand suns. The problem is that I know SQL but now I have to spend a bunch of time trying to figure out how to convert SQL into ORM X just so it can convert it back to inefficient SQL. SQL mostly translates between various databases but ORMs are unique and you have to learn a new API for each one.

I’m on a project using TypeORM and it has been fantastic at helping developers on my team make really bad schemas due to not understanding how to use TypeORM to make the right relationships.

Currently I’m looking at pg-types because you just write SQL and it just helps by making some TypeScript types for you.

(I have used ORMs in C#, PHP, and JavaScript and I hate all of them)."

https://news.ycombinator.com/item?id=27547163

  • RoundSparrow @ BT@bulletintree.comOPM
    link
    fedilink
    arrow-up
    1
    ·
    1 year ago

    404: TypeError: Cannot read properties of undefined (reading ‘replies’)

    lemmy.world throwing this just on routine home page. It’s been this way since I started visiting in May… and I can crash a single-user server pretty easily by matching the number of communities and posts in the database. IT isn’t DDOS, it’s bad SQL.