Answer the question
In order to leave comments, you need to log in
Why does a Python Django developer need to know SQL?
Why does a Python Django developer need to know the SQL language if Django itself can translate python into sql?
I understand that the question is probably stupid, but I'm just learning, but there's no one to ask, she didn't find a clear answer in Google
Answer the question
In order to leave comments, you need to log in
1. To write efficient queries that fit well on indexes and execute quickly
2. To avoid stupid mistakes when writing a query that is fundamentally impossible to turn into SQL
3. To avoid ORM pitfalls such as N+1 and (xs as it is called - when ORM unloads all data from the database, and then processes them on the application side)
4. In order not to generate security holes.
5. To write queries without ORM - sometimes it's faster to go to datagrip and enter the query there than to write a one-time script.
ORM, IMHO, is only needed to speed up writing queries and abstract from the syntax of a particular DBMS, but not to replace SQL
For general development. For the same reason, for example, it is desirable for a cultured person to know the trigonometry and valency of hydrogen.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question