from a business perspective is an orm also an extra hiring and learning aspect. it can speed up development but at the same time can have impact on the team that is building the tools.
ORMs can also be helpful because they automatically do input sanitisation so you don’t need to concern yourself with SQL injections. Some inexperienced developers could easily introduce an SQLI vulnerability if they’re not careful writing raw SQL queries
Once you grok an ORM realizing it’s a Python dictionary and Python lists just doing set operations… MAGIC‼️ You realize what the alchemy is in SQLAlchemy 🤩🤯
Every attempt that I have made to use an ORM has failed. It is great for the easy stuff (but so is SQL) and it is really hard once you go beyond the basics. It is not any easier. The "simplification" just makes it dumber, which makes it more complex.
from a business perspective is an orm also an extra hiring and learning aspect. it can speed up development but at the same time can have impact on the team that is building the tools.
ORMs can also be helpful because they automatically do input sanitisation so you don’t need to concern yourself with SQL injections. Some inexperienced developers could easily introduce an SQLI vulnerability if they’re not careful writing raw SQL queries
The SQL injection problem was solved a long time ago. No need to use an ORM for that.
Use parametric queries, and you do not have to worry about SQL injection. ORMs are a cancer.
Just raw dawg squeeel...
I do enjoy some squeel. Even when I use an orm I find myself deep into some squeel
In ASM, no other way
Right everything else is bloat
@@LampJustinit’s useful for type safety tho bro
Kids use ORMs cause they’re cool. Solution providers use the right tech, nearest the data
Once you grok an ORM realizing it’s a Python dictionary and Python lists just doing set operations… MAGIC‼️ You realize what the alchemy is in SQLAlchemy 🤩🤯
Not everything is about python
Eww
What ORM is your favourite?
Drizzle
Eloquent
EntityFramework (yes, I'm a dotnet dev, sorry)
Prisma 🔥
gorm (golang dev here)
Write your own ORM. That all.
SQL based.Easier and most comfortable
Every attempt that I have made to use an ORM has failed. It is great for the easy stuff (but so is SQL) and it is really hard once you go beyond the basics.
It is not any easier. The "simplification" just makes it dumber, which makes it more complex.
Stop being lazy, learn and use SQL.
Add a query builder if you’re working with juniors that can’t write safe sanitized input.
And you’re good to go.