{ "_id": "6ac4b9ebf511ae58c09a07df", "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-10-06 09:02:08 UTC", "User": "root" }, "Author": "Alejandro Hagan [aut, cre]", "Maintainer": "Alejandro Hagan ", "_user": "usrbinr", "_type": "src", "_file": "sqlm_1.0.0.tar.gz", "_fileid": "https://r2.ropensci.org/2c8aec712ac05b8a3a2811115b603c8a121c45cf8f4be1bb0cdcdbf6f935f00f", "_filesize": 466491, "_sha256": "2c8aec712ac05b8a3a2811115b603c8a121c45cf8f4be1bb0cdcdbf6f935f00f", "_expires": "2027-01-14T09:05:46.000Z", "_created": "2026-10-06T09:02:08.000Z", "_published": "2026-10-06T09:05:47.899Z", "_jobs": [ { "job": 112191803607, "time": 123, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "11400329531" }, { "job": 112191803464, "time": 124, "config": "linux-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "11400577992" }, { "job": 112191803698, "time": 166, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "11400424205" }, { "job": 112191803608, "time": 172, "config": "macos-release-arm64", "r": "4.6.1", "check": "NOTE", "artifact": "11400219991" }, { "job": 112190526135, "time": 191, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11400727461" }, { "job": 112191803557, "time": 98, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11400219859" }, { "job": 112191803762, "time": 80, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "11400642799" }, { "job": 112191803629, "time": 81, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "NOTE", "artifact": "11400374061" }, { "job": 112191803640, "time": 82, "config": "windows-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "11400473042" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/usrbinr/actions/runs/37439784906", "_status": "success", "_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 }, "_distro": "resolute", "_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", "followers": 19 }, "_downloads": { "count": 257, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlm" }, "_devurl": "https://github.com/usrbinr/sqlm", "_searchresults": 8, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/sqlm.html", "LICENSE" ], "_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-10-06T09:04:10.000Z", "distro": "resolute", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "https://r2.ropensci.org/8bd7d529fcc8af799bea3872be15851a2d694485d4ddd8b1317e69d1a85aaf1f", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/37439784906" }, { "r": "4.6.1", "os": "linux", "version": "1.0.0", "date": "2026-10-06T09:04:08.000Z", "distro": "resolute", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "https://r2.ropensci.org/f3830d2d496f9e6a61cddd1f18c7a7236c9daa6781a9415c81ca8ad2d9b6a5d7", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/37439784906" }, { "r": "4.5.3", "os": "mac", "version": "1.0.0", "date": "2026-10-06T09:04:30.000Z", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "https://r2.ropensci.org/faf94340944ebc5d9dfe5c7072cb4c8fe738bb5c84ffaf227a611fbaea89ba21", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/37439784906" }, { "r": "4.6.1", "os": "mac", "version": "1.0.0", "date": "2026-10-06T09:04:17.000Z", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "https://r2.ropensci.org/bb699461398d263c974c2171c02d06d9ab327925f3bb1ca05484114bd9ab5247", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/37439784906" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.0", "date": "2026-10-06T09:04:02.000Z", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "https://r2.ropensci.org/0df0d3c0e520af519ad8a7527cb802cf004145e88ffb94cef3797c7421b9c825", "status": "success", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/37439784906" }, { "r": "4.7.0", "os": "win", "version": "1.0.0", "date": "2026-10-06T09:03:27.000Z", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "https://r2.ropensci.org/48455e2c51a4f81563b2ce95ccd8d40ae07d7f37871e0c4947c4fe1064899333", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/37439784906" }, { "r": "4.5.3", "os": "win", "version": "1.0.0", "date": "2026-10-06T09:03:19.000Z", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "https://r2.ropensci.org/f5d3655f1bd6aac2c4d67e1aa636d73d955cb3ef8e3ae2649b453d171763079a", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/37439784906" }, { "r": "4.6.1", "os": "win", "version": "1.0.0", "date": "2026-10-06T09:03:27.000Z", "commit": "21e6f2ecdd07fd3f218e3f9084e0b9896a098687", "fileid": "https://r2.ropensci.org/d7f8bf8b3d8dc623b2cb4b23bc221de5eed6a142f66fdfdd020e2bf6998da53e", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usrbinr/actions/runs/37439784906" } ] }