A
A
akrvch2021-01-11 02:13:09
SQL
akrvch, 2021-01-11 02:13:09

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

4 answer(s)
V
Vasily Bannikov, 2021-01-11
@akrvch

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

K
ky0, 2021-01-11
@ky0

For general development. For the same reason, for example, it is desirable for a cultured person to know the trigonometry and valency of hydrogen.

D
Developer, 2021-01-11
@samodum

Who said what is needed? If you don't want to, don't teach.

D
dooMoob, 2021-01-11
@dooMoob

Why should I learn Russian if T9 corrects the words himself?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question