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.
KoliStat blog
Notes from the founder on building modern tooling for clinical and tabular data — SAS, DuckDB, WebAssembly, and the craft of byte-parity engineering.
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.
You don't know XPT files
A friendly tour of the SAS Transport (XPT) format: everything you never wanted to know about it, and how to decode its IBM hexadecimal floats.
Welcome to the KoliStat blog
Notes from the founder on building modern tooling for clinical and tabular data — what we ship, how we build it, and the trade-offs that show up along the way.