Every so often I encounter some dev that is not familiar with SQL. So instead of writing a single SQL and relatively "simple" SQL request that does the job db-side (say with a few joins and coalesce but no sub-query), they write several requests then process the result in python.
The argument ? "SQL is complicated, it is simpler to just do it in Python."
Is it though ? I guess it depends on the request and the exact processing we are talking about but in many cases I suspect it is because that person is not familiar with SQL.
What "simple" means is not so simple to define. Sometimes it means "easy for me".
Every so often I encounter some dev that is not familiar with SQL. So instead of writing a single SQL and relatively "simple" SQL request that does the job db-side (say with a few joins and coalesce but no sub-query), they write several requests then process the result in python.
The argument ? "SQL is complicated, it is simpler to just do it in Python."
Is it though ? I guess it depends on the request and the exact processing we are talking about but in many cases I suspect it is because that person is not familiar with SQL.
What "simple" means is not so simple to define. Sometimes it means "easy for me".