← Back to NxtKnit Catalog
🔥 Score 47.5
search • Confidence 38%

VizQuery: SQL to Visuals

Data analysts often have to export tables into R or Python to create charts, adding extra steps and latency. VizQuery lets them write visual queries that generate SQL on the fly and render charts directly from the database, eliminating the need for intermediate data frames.

Quantitative Score Breakdown

complaint frequency
1.5
growth rate
9
competition density
10.5
monetization potential
14.25
technical feasibility
7.5
search interest
4.8

Evidence Signal (1)

Raw Posts
hn • r/hackernews

Comment on: ggsql: A Grammar of Graphics for SQL

I skimmed the article for an explanation of why this is needed, what problem it solves, and didn't find one I could follow. Is the point that we want to be able to ask for visualizations directly against tables in remote SQL databases, instead of having to first pull the data into R data frames so we can run ggplot on it? But why create a new SQL-like language? We already have a package, dbplyr, that translates between R and SQL. Wouldn't it be more direct to extend ggplot to support dbplyr tbl objects, and have ggplot generate the SQL?Or is the idea that SQL is such a great language to write