GGSQL with DuckDB

Saqib · 2026-04-28T17:12:32+00:00

A nice blogpost by Zach Flynn on using GGSQL with DuckDB: https://zachflynn.substack.com/p/reviewing-ggsql-a-grammar-of-graphics Sample code from the blogpost: SELECT * FROM radio_markets VISUALIZE Firms AS x DRAW histogram SCALE y LABEL title => 'Radio Station Distribution Across Markets', x => 'Radio Stations', y => 'Markets'; SELECT * FROM radio_markets WHERE Firms null LABEL title => 'Radio Stations and Physical Area', x => 'Radio Stations', y => 'Land Area (sq. mi.)', size => 'Population (100k)'

From: Saqib | Date: Tue, 28 Apr 2026 17:12:32 +0000 #
Subject: GGSQL with DuckDB
A nice blogpost by Zach Flynn on using GGSQL with DuckDB: https://zachflynn.substack.com/p/reviewing-ggsql-a-grammar-of-graphics Sample code from the blogpost: SELECT * FROM radio_markets VISUALIZE Firms AS x DRAW histogram SCALE y LABEL title => 'Radio Station Distribution Across Markets', x => 'Radio Stations', y => 'Markets'; SELECT * FROM radio_markets WHERE Firms <= 200 VISUALIZE Area AS x, Firms AS y DRAW point MAPPING Population AS size SETTING fill => null LABEL title => 'Radio Stations and Physical Area', x => 'Radio Stations', y => 'Land Area (sq. mi.)', size => 'Population (100k)'
[ Reply ]
- |-- Reply
  From: Saqib | Date: Mon, 11 May 2026 14:02:05 +0000 #
  GGSQL Community Extension for DuckDB is now available for download: https://duckdb.org/community_extensions/extensions/ggsql
  [ Reply ]

[ Back to Group: comp.databases.ggsql ]

Keyboard Shortcuts: [ j/n next | k/p prev | g top | r reply | u up ]