Bedevere in DuckDB Monthly #46
MotherDuck featured Bedevere in this month's DuckDB newsletter. For readers arriving from it: what Bedevere is, how can keep the files on your machine, and where the Windows desktop beta stands.
Posts tagged the-stats-duck
Bedevere 0.15: what changed since June
Three Bedevere releases in one post: the Paper theme, whole-table export to Parquet, SAS, and SPSS, charts that render inside embeds, saved queries that stay saved, and a native desktop beta. Two live demos you can edit.
the-stats-duck v0.7 — a regression in every GROUP BY
v0.7 of our open-source DuckDB statistics extension adds lm_fit: an OLS aggregate that fits one regression per GROUP BY group, with heteroskedasticity- and cluster-robust standard errors (HC0–HC3, CR0/CR1). Plus a portable bootstrap and a new linear-algebra kernel underneath.
Story of an interesting bug, found (and solved) by Claude Code
Two RNG bugs, one debugging session: DuckDB broadcasting a single random draw across 2,048 rows, and a standard-library uniform distribution with a clipped tail. Both produced plausible-looking numbers, both are invisible in code review — and both fell to a Monte Carlo checklist, run by Claude Code.
the-stats-duck v0.6.0 — statistics that live in your SQL
A tour of the-stats-duck v0.6.0: a one-shot data profiler, regression and bootstrap CIs in plain SQL, ten new distributions, and SAS/XPT imports that got 52x faster — with live Bedevere demos you can poke at.