The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

sqlm 0.1.0

• Initial CRAN submission.

Features

• lm_sql() fits OLS linear regression models entirely in-database via a single SQL aggregation query.
• Automatic dummy encoding for character and factor predictors with CASE WHEN SQL generation.
• Interaction terms (*, :) fully supported, including interactions between numeric and categorical variables.
• Dot expansion (y ~ .) expands to all non-response columns.
• Formula transforms: I(), log(), and sqrt() translated to SQL equivalents (POWER, LN, SQRT).
• Date and datetime predictor support: Date and POSIXct columns automatically converted to numeric in SQL, matching base R’s lm() behavior.
• Grouped regression via dplyr::group_by() computes multiple models in a single GROUP BY query.
• No-intercept models (y ~ 0 + x) handled correctly.
• S7-based result objects with broom::tidy() and broom::glance() methods.
• orbital integration for in-database predictions.
• Cholesky decomposition for matrix inversion with MASS::ginv() fallback for rank-deficient designs.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.