7 ms·
I much prefer writing actual functions in a real programming language to the verbose non-reusable non-composable relic that is SQL syntax. Give me a better que
by nerdponx 6y ago
I much prefer writing actual functions in a real programming language to the verbose non-reusable non-composable relic that is SQL syntax.
Give me a better query language and I will gladly drop Pandas and Data.Table.
- beforeolives 6y agoYes, SQL does have the problem of bad composeability and some things being less explicit than they are when working with dataframes. Dplyr is probably the most sane API out of all of them.
- alexilliamson 6y ago+1 for dplyr. I've used both pandas and dplyr daily for a couple years at different times in my career, and there is no comparison in mind when it comes to usability/verbosity/number of times I need to look at the documentation.
- RA_Fisher 6y agoI agree, the degree of expressiveness that dplyr achieves is impressive. The library has had a great impact on my work. The syntax is easy to remember so you don't have to constantly look up minor variations in usage. Also, the pipelining aspect makes it dead-simple to debug. It's especially powerful when combined with the purrr library: https://purrr.tidyverse.org/ https://purrr.tidyverse.org/
- semitones 6y agoSQL is a real programming language.
- thinkharderdev 6y agoIt's not turing complete which is I think why it doesn't feel like a "real" programming language.
- sagarm 6y agoRecursive CTEs exist; while I haven't investigated thoroughly, I would be surprised if they didn't make SQL turing complete. More usefully, most databases allow you to write user-defined functions in other languages, including imperative SQL dialects.
- steve-chavez 6y agoSQL is turing complete. A demonstration with recursive CTEs is done here[1]. [1]: https://wiki.postgresql.org/wiki/Cyclic_Tag_System https://wiki.postgresql.org/wiki/Cyclic_Tag_System
- thinkharderdev 6y agoOh wow. I stand corrected. Thanks!