{ "_id": "6a1d3a9b1d7bb097a0a3ebaf", "Package": "sqlm", "Type": "Package", "Title": "SQL-Backed Linear Regression", "Version": "1.0.0", "Authors@R": "c(\nperson(\n\"Alejandro\", \"Hagan\",\nemail = \"alejandro.hagan@outlook.com\",\nrole = c(\"aut\", \"cre\")\n)\n)", "Description": "Fits linear regression models on datasets residing in SQL\ndatabases without pulling data into R memory. Computes\nsufficient statistics inside the database engine via a single\naggregation query and solves the normal equations in R.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Config/testthat/edition": "3", "RoxygenNote": "7.3.3", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://usrbinr.r-universe.dev", "Date/Publication": "2026-02-05 12:18:40 UTC", "RemoteUrl": "https://github.com/usrbinr/sqlm", "RemoteRef": "HEAD", "RemoteSha": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-01 07:51:08 UTC", "User": "root" }, "Author": "Alejandro Hagan [aut, cre]", "Maintainer": "Alejandro Hagan ", "MD5sum": "4013bf043db2409fac935e85bf9e49f0", "_user": "usrbinr", "_type": "src", "_file": "sqlm_1.0.0.tar.gz", "_fileid": "44e89450516cc97bf2681bd87c41fae654430d654c1c78e694810e710447c570", "_filesize": 463854, "_sha256": "44e89450516cc97bf2681bd87c41fae654430d654c1c78e694810e710447c570", "_created": "2026-06-01T07:51:08.000Z", "_published": "2026-06-01T07:54:03.406Z", "_distro": "noble", "_jobs": [ { "job": 78808778346, "time": 140, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7326107199" }, { "job": 78808778308, "time": 145, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7326108665" }, { "job": 78808778320, "time": 108, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "7326097465" }, { "job": 78808778307, "time": 110, "config": "macos-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7326097774" }, { "job": 78808363883, "time": 173, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7326064196" }, { "job": 78808778289, "time": 123, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7326101687" }, { "job": 78808778328, "time": 94, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7326093130" }, { "job": 78808778399, "time": 74, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "7326087805" }, { "job": 78808778331, "time": 108, "config": "windows-release", "r": "4.6.0", "check": "NOTE", "artifact": "7326098838" } ], "_buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26742086863", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/usrbinr/sqlm", "_commit": { "id": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "author": "hagan ", "committer": "hagan ", "message": "new docs\n", "time": 1770293920 }, "_maintainer": { "name": "Alejandro Hagan", "email": "alejandro.hagan@outlook.com", "login": "usrbinr", "description": "", "uuid": 87534364 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "dplyr", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "S7", "role": "Imports" }, { "package": "MASS", "role": "Imports" }, { "package": "broom", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "duckdb", "role": "Suggests" }, { "package": "orbital", "role": "Suggests" }, { "package": "withr", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "quarto", "role": "Suggests" }, { "package": "mirai", "role": "Suggests" }, { "package": "parallel", "role": "Suggests" } ], "_owner": "usrbinr", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-01", "n": 4 }, { "week": "2026-05", "n": 16 }, { "week": "2026-06", "n": 9 } ], "_tags": [], "_stars": 1, "_userbio": { "uuid": 87534364, "type": "user", "name": "usr/bin/R" }, "_downloads": { "count": 139, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlm" }, "_devurl": "https://github.com/usrbinr/sqlm", "_searchresults": 8, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/sqlm.html", "manual.pdf" ], "_homeurl": "https://github.com/usrbinr/sqlm", "_realowner": "usrbinr", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2026-02-04" } ], "_exports": [ "lm_sql", "orbital.lm_sql_result" ], "_help": [ { "page": "glance.lm_sql_result", "title": "Glance at an lm_sql_result", "topics": [ "glance.lm_sql_result" ] }, { "page": "lm_sql", "title": "SQL-Backed Linear Regression", "topics": [ "lm_sql" ] }, { "page": "orbital.lm_sql_result", "title": "Convert an lm_sql_result to an orbital object", "topics": [ "orbital.lm_sql_result" ] }, { "page": "print.lm_sql_result", "title": "Print an lm_sql_result", "topics": [ "print.lm_sql_result" ] }, { "page": "tidy.lm_sql_result", "title": "Tidy an lm_sql_result", "topics": [ "tidy.lm_sql_result" ] } ], "_pkglogo": "https://github.com/usrbinr/sqlm/raw/HEAD/man/figures/logo.svg", "_readme": "https://github.com/usrbinr/sqlm/raw/HEAD/README.md", "_rundeps": [ "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" ], "_score": 3.1760912590556813, "_indexed": true, "_nocasepkg": "sqlm", "_universes": [ "usrbinr" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.0", "date": "2026-06-01T07:53:22.000Z", "distro": "noble", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "d5aa82c5484d1e76e90f604c89625a70b69520c48cd301f5ceef1e5c3b729085", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26742086863" }, { "r": "4.6.0", "os": "linux", "version": "1.0.0", "date": "2026-06-01T07:53:27.000Z", "distro": "noble", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "5243185517358daec1b3b1b66a3a8ba318fe6c475809bb9f3e794f0450f9041b", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26742086863" }, { "r": "4.5.3", "os": "mac", "version": "1.0.0", "date": "2026-06-01T07:52:56.000Z", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "b453e396d4f4e697e83b42e22d2da74f4c6464d89f687856c60a92dd3287f636", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26742086863" }, { "r": "4.6.0", "os": "mac", "version": "1.0.0", "date": "2026-06-01T07:52:59.000Z", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "84253a036a70ddf726075e50b64bb7b90cafbc243dfd41a2c818f069c56c2de6", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26742086863" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.0", "date": "2026-06-01T07:53:25.000Z", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "a506bab4e5f904a12212fbb17c177f737e99f9ea44ecbbb8421d1c3f0cfb8eb9", "status": "success", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26742086863" }, { "r": "4.7.0", "os": "win", "version": "1.0.0", "date": "2026-06-01T07:52:27.000Z", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "b55d4b28fb7db4dbb67ddadbe439bd6a7e657ac891c5a9d213ae3de537908f6a", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26742086863" }, { "r": "4.5.3", "os": "win", "version": "1.0.0", "date": "2026-06-01T07:52:16.000Z", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "8503980799b0450b2be89123850b1b3bd99a4326ffa231501ef9e4258ccbfc6b", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26742086863" }, { "r": "4.6.0", "os": "win", "version": "1.0.0", "date": "2026-06-01T07:52:53.000Z", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "d6cfb713005acb719dbe47a63954c47640f203b6b86beff48823b8503da93fd5", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26742086863" } ] }