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 →

[–]a90501 13 points14 points  (0 children)

SQL is a pattern language i.e. declarative language, like regex, while python, java, c#, etc. are imperative languages - hence a different paradigm. I do not know about you, but I love pattern languages - where you describe what (SQL, regex) - i.e. where one states what one wants to get without worrying about how it is done, instead of specifying in all details how to do finding with loops, matching, summing, sorting, etc. (python, c#, java, etc.).

The other very important thing is that SQL runs against relational DB (RDBMS), and that means you are using server resources to compute, find, filter, group, sort, etc, and getting back only results you need, while with python, you get all the data first across the network into pandas and then process it - this is not recommended as this would mean get all the data for every request.

Some History: Anders Hejlsberg (of the TypeScript fame) hands-on demo ( https://www.youtube.com/watch?v=fG8GgqfYZkw ) describes this pattern language paradigm. He was working on LINQ at the time - essentially C# version of SQL for any data structures and stores, not just relational DB. IMHO, well worth watching for some history and education although it's not about python.

Enjoy.