Ask HN: Tools to visualize data in SQL databases?

Re:Ask HN: Tools to visualize data in SQL databases? by disgruntledphd2 on Sunday February 13, 2022 @06:45PM (#30326797)

PSA: If you haven't already learned pandas, learn dplyr/ggplot2 instead. Yes, R is a pretty clunky language (but it's closer to lisp than pretty much anything else as popular) but ggplot2 and dplyr are 100% the best currently available way to visualise tables in SQL.

[ Parent | on HN ]

Re:Ask HN: Tools to visualize data in SQL databases? by r_power_user on Sunday February 13, 2022 @10:54PM (#30328197)

I would second the decision to use ggplot2 / dplyr, and would also add data.table to the mix. That combination has been invaluable for me, allowing me to visualize all of my structured data.

[ Parent | on HN ]

Re:Ask HN: Tools to visualize data in SQL databases? by optimalonpaper on Monday February 14, 2022 @09:57AM (#30332717)

I started with R, but then switched to Python because all pipelines were already written in Python (web-scrapers, some data-processing scripts, REST APIs), so I just learned pandas and it's been fine, although I do think dplyr's syntax is great and I prefer it to pandas'.

[ Parent | on HN ]

Re:Ask HN: Tools to visualize data in SQL databases? by disgruntledphd2 on Monday February 14, 2022 @11:07AM (#30333662)

Yeah, totally. I spend a lot more of my time writing Python for anything that isn't data exploration/analysis, for exactly that reason.

I still refuse to learn pandas enough to replace dplyr though, as it's just so painful to use the API compared to how easy this stuff is in R.

[ Parent | on HN ]