Should you use SQL or an ORM for Databases!? 👩‍💻 #python #coder #technology #coding #software

[marcgentner]

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.

[mtsurov]

You may use ORM unless you want to the data to be fast, consistent, atomic, normalized, safe, reportable.
For anything else ORM is great.

[jackdavenport]

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

[rein_engel]

Point is, once you learned and understood sql really well, learning an orm is just overhead with little benefit. At that point just use sql

[AdventMoxy]

Kids use ORMs cause they’re cool. Solution providers use the right tech, nearest the data

[jesavius]

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 🤩🤯

[CalifornianViking]

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.

[jaimel]

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.