Package: sqlm 1.0.0

sqlm: SQL-Backed Linear Regression

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.

Authors:Alejandro Hagan [aut, cre]

sqlm_1.0.0.tar.gz
sqlm_1.0.0.zip(r-4.7-any)sqlm_1.0.0.zip(r-4.6-any)sqlm_1.0.0.zip(r-4.5-any)
sqlm_1.0.0.tgz(r-4.6-any)sqlm_1.0.0.tgz(r-4.5-any)
sqlm_1.0.0.tar.gz(r-4.7-any)sqlm_1.0.0.tar.gz(r-4.6-any)
sqlm_1.0.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
sqlm/json (API)

# Install 'sqlm' in R:

install.packages('sqlm', repos = c('https://usrbinr.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/usrbinr/sqlm/issues

On CRAN:

3.18 score 1 stars 8 scripts 257 downloads 2 exports 27 dependencies

Last updated from:21e6f2ecdd. Checks:7 NOTE, 2 OK. Indexed: yes.

Target	Result	Time
linux-devel	NOTE	123
source / vignettes	OK	191
linux-release	NOTE	124
macos-release	NOTE	172
macos-oldrel	NOTE	166
windows-devel	NOTE	80
windows-release	NOTE	82
windows-oldrel	NOTE	81
wasm-release	OK	98

Exports:lm_sql orbital.lm_sql_result

Dependencies:backports blob broom cli cpp11 DBI dbplyr dplyr generics glue lifecycle magrittr MASS pillar pkgconfig purrr R6 rlang S7 stringi stringr tibble tidyr tidyselect utf8 vctrs withr

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Glance at an lm_sql_result	glance.lm_sql_result
SQL-Backed Linear Regression	lm_sql
Convert an lm_sql_result to an orbital object	orbital.lm_sql_result
Print an lm_sql_result	print.lm_sql_result
Tidy an lm_sql_result	tidy.lm_sql_result