ggsql: A grammar of graphics for SQL
summary
An alpha tool implements a grammar of graphics inside SQL so queries return plots without exporting to R or Python. It splits a SQL SELECT from a trailing VISUALIZE clause, sends the SELECT to DuckDB and composes the plot layer stack. Examples show visualize longitude as X, latitude as Y, adding color, line width for troop counts and a Mercator projection, served via a DuckDB extension plus CLI, Jupyter kernel, WASM demo and VS Code support.
AI-written summary · about
chapters (6)
- 0:00Introduction to ggsql
- 1:58Design philosophy
- 3:30Comparative analysis
- 5:37Commonalities with SQL
- 8:02Minard chart demonstration
- 10:47Integrations and availability
related talks
32mBecause SQL is everywhere but you don't want to use it
41mGraphGen: Conducting Graph Analytics over Relational Databases
34mVisualizations in Golang
38mBuilding a Grammar for Statistical Graphics in Clojure
36mBeyond dbt: Modern SQL Transformation and Lineage with SQLGlot and SQLMesh
31mFuturistic SQL: Making the impossible possible
45mGraph databases, PostgreSQL and SQL/PGQ
25mSimplify Property Graphs Using SQL with Database 23ai