Skip to content

sqlm

SQL-Backed Linear Regression

v0.1.0 · Feb 4, 2026 · MIT + file LICENSE

Description

Fits linear regression models on datasets residing in SQL databases without pulling data into R memory. Computes sufficient statistics inside the database engine via a single aggregation query and solves the normal equations in R.

Downloads

CRAN

198

Last 30 days

22267th

504

Last 90 days

984

Last year

Trend: +42.5% (30d vs prior 30d)

r2u CRAN

7

Last 30 days

20

Last 90 days

31

Last year

Trend: -41.7% (30d vs prior 30d)

autoCRAN

1

Last 7 days

16

Last 30 days

0

All-time

autoCRAN-only: this name is served only by autoCRAN, so the count is exact.

CRAN Check Status

13 OK
Show all 13 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK

Check History

OK 13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Jun 9, 2026
ERROR 12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Jun 8, 2026
ERROR r-devel-linux-x86_64-debian-gcc

package dependencies

Package required but not available: ‘dbplyr’

See section ‘The DESCRIPTION file’ in the ‘Writing R Extensions’
manual.
NOTE 12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Jun 7, 2026
NOTE r-devel-linux-x86_64-debian-gcc

R code for possible problems

Fatal error: cannot create 'R_TempDir'
See section ‘Good practice’ in ‘?attach’.
OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026

Dependency Network

Dependencies Reverse dependencies dplyr dbplyr DBI glue purrr S7 MASS broom tibble sqlm

Version History

1 tracked
new 0.1.0 Mar 10, 2026

R Observatory began tracking this package on Mar 10, 2026; it first appeared on CRAN Feb 4, 2026. Releases before tracking aren’t shown.