GitHub - posit-dev/ggsql: A SQL extension for declarative data visualisation based on the Grammar of Graphics.

kept by eddie apr 21

ggsql is a SQL extension that enables declarative data visualization within SQL queries using the Grammar of Graphics, currently supporting DuckDB and SQLite.

Statistics that live in your SQL
the-stats-duck v0.6.0 adds OLS regression, bootstrap, expanded distributions, and a Vega-Lite plot grammar to DuckDB SQL.
also on Vega-Lite, Posit, DuckDB, #open-source, #developer-tools
In Defense of YAML :: Posit Open Source
Posit releases py-yaml12, a Rust-backed Python library implementing YAML 1.2, arguing many criticisms of YAML stem from outdated PyYAML's 1.1 behavior rather than the modern spec.
also on Posit, #open-source, #developer-tools
The Mythical Agent-Month – Wes McKinney
AI coding agents accelerate accidental complexity but leave essential design problems unsolved, echoing Brooks's "No Silver Bullet" from 1986.
also on Posit, #productivity, #developer-tools
Ironclaw — AI CRM, hosted locally on your Mac
DenchClaw is an open-source AI CRM and workflow automation tool that runs locally on a Mac, using a Chrome profile to automate tasks like database queries, lead enrichment, and outreach.
also on DuckDB, #open-source, #productivity, #developer-tools
GitHub - columnar-tech/databow at console.dev
databow is a command-line tool for querying databases via ADBC, offering an interactive SQL shell, syntax highlighting, formatted output, and file export.
also on DuckDB, #open-source, #developer-tools