Statistics that live in your SQL

kept by eddie jun 26

the-stats-duck v0.6.0 adds OLS regression, bootstrap, expanded distributions, and a Vega-Lite plot grammar to DuckDB SQL.

GitHub - posit-dev/ggsql: A SQL extension for declarative data visualisation based on the Grammar of Graphics.
ggsql is a SQL extension that enables declarative data visualization within SQL queries using the Grammar of Graphics, currently supporting DuckDB and SQLite.
also on Vega-Lite, Posit, DuckDB, #open-source, #developer-tools
A lot of population numbers are fake
Census and population estimates in many countries are systematically inaccurate due to fraud, weak infrastructure, or political incentives, not merely benign error.
also on #statistics
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, #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, #developer-tools