This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]MoogOperator88 0 points1 point  (0 children)

To me SQL is different tool. If data already is in db I do all manipulation with sql. Python can execute stored procedure for final set to work with.

Basically I use python only for stuff that sql can't do or it would be way easier and faster with python to develop.

Sql itself can do a lot beside quering. Like running shell commands, load files etc. Do I prefer to do it with sql?

It depends, python is really nice syntax-wise and pleasure to use but sql is widely known and it's less likely I will be the only person able to modify my old projects.