{ "_id": "6ad5bde4d423e4b0c576c332", "Package": "dbreg", "Type": "Package", "Title": "Fast Regressions on Database Backends", "Version": "0.0.3.99", "Date": "2026-03-16", "Authors@R": "c(\nperson(\ngiven = \"Grant\",\nfamily = \"McDermott\",\nrole = c(\"aut\", \"cre\"),\nemail = \"contact@grantmcdermott.com\",\ncomment = c(ORCID = \"0000-0001-7883-8573\")\n),\nperson(\ngiven = \"James\",\nfamil = \"Brand\",\nemail = \"jamesbrandecon@gmail.com\",\nrole = c(\"aut\"),\ncomment = c(ORCID = \"0000-0002-1663-5583\")\n),\nperson(\ngiven = \"Apoorva\",\nfamil = \"Lal\",\nemail = \"lal.apoorva@gmail.com\",\nrole = c(\"ctb\"),\ncomment = c(ORCID = \"0000-0002-3697-614X\")\n),\nperson(\ngiven = \"Laurent\",\nfamil = \"Berge\",\nemail = \"laurent.berge@u-bordeaux.fr\",\nrole = c(\"ctb\")\n)\n)", "Description": "Leverages database backends to run regressions on very\nlarge datasets, which may not fit into R's memory. Various\nacceleration strategies---e.g., Wong et al. (2021)\n and Arkhangelsky & Imbens\n(2024) ---allow for\nhighly efficient computation, while robust standard errors are\ncomputed from sufficient statistics.", "Config/Needs/website": "etiennebacher/altdoc", "Encoding": "UTF-8", "License": "MIT + file LICENSE", "URL": "https://grantmcdermott.com/dbreg/", "BugReports": "https://github.com/grantmcdermott/dbreg/issues", "VignetteBuilder": "quarto", "Config/roxygen2/version": "8.1.0", "Config/pak/sysreqs": "xz-utils", "Repository": "https://grantmcdermott.r-universe.dev", "Date/Publication": "2026-10-19 03:22:38 UTC", "RemoteUrl": "https://github.com/grantmcdermott/dbreg", "RemoteRef": "HEAD", "RemoteSha": "9d1472b221d733910dde451df3c41ba625e07673", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-19 06:40:29 UTC", "User": "root" }, "Author": "Grant McDermott [aut, cre] (ORCID:\n),\nJames Brand [aut] (ORCID: ),\nApoorva Lal [ctb] (ORCID: ),\nLaurent Berge [ctb]", "Maintainer": "Grant McDermott ", "_user": "grantmcdermott", "_type": "src", "_file": "dbreg_0.0.3.99.tar.gz", "_fileid": "https://r2.ropensci.org/f9bf2aee4c2c364d2db8cbc3c2c574d6f102f550cb36bbeaa04002c21ab80aaf", "_filesize": 420870, "_sha256": "f9bf2aee4c2c364d2db8cbc3c2c574d6f102f550cb36bbeaa04002c21ab80aaf", "_expires": "2027-01-27T06:51:14.000Z", "_created": "2026-10-19T06:40:29.000Z", "_published": "2026-10-19T06:51:15.941Z", "_buildurl": "https://github.com/r-universe/grantmcdermott/actions/runs/39210680213", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 117925101979, "time": 187, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12168016475" }, { "job": 117925101738, "time": 308, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12167702281" }, { "job": 117925101668, "time": 113, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "12168415699" }, { "job": 117925101648, "time": 147, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12168350737" }, { "job": 117923239084, "time": 371, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12167827233" }, { "job": 117925101762, "time": 262, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12168240688" }, { "job": 117925101722, "time": 104, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12167842343" }, { "job": 117925101763, "time": 131, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "12167359792" }, { "job": 117925101745, "time": 246, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12167622401" } ], "_upstream": "https://github.com/grantmcdermott/dbreg", "_commit": { "id": "9d1472b221d733910dde451df3c41ba625e07673", "author": "Wojtek Klimowicz <62679873+wklimowicz@users.noreply.github.com>", "committer": "GitHub ", "message": "fix: keep AP identifiers that are also regressors; validate AP options (#79)", "time": 1792380158 }, "_maintainer": { "name": "Grant McDermott", "email": "contact@grantmcdermott.com", "orcid": "0000-0001-7883-8573" }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "DBI", "role": "Imports" }, { "package": "duckdb", "role": "Imports" }, { "package": "Formula", "role": "Imports" }, { "package": "generics", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "MASS", "role": "Imports" }, { "package": "Matrix", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "tinyplot", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "binsreg", "role": "Suggests" }, { "package": "here", "role": "Suggests" }, { "package": "fixest", "version": ">= 0.13.0", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "quarto", "role": "Suggests" }, { "package": "tinytest", "role": "Suggests" }, { "package": "dbplyr", "role": "Enhances" } ], "_owner": "grantmcdermott", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-42", "n": 1 }, { "week": "2025-44", "n": 1 }, { "week": "2025-45", "n": 1 }, { "week": "2025-50", "n": 1 }, { "week": "2025-51", "n": 4 }, { "week": "2025-52", "n": 3 }, { "week": "2026-01", "n": 3 }, { "week": "2026-02", "n": 6 }, { "week": "2026-03", "n": 2 }, { "week": "2026-04", "n": 3 }, { "week": "2026-05", "n": 2 }, { "week": "2026-11", "n": 1 }, { "week": "2026-12", "n": 1 }, { "week": "2026-21", "n": 4 }, { "week": "2026-42", "n": 9 }, { "week": "2026-43", "n": 1 } ], "_tags": [ { "name": "v0.0.3", "date": "2026-01-24" } ], "_stars": 82, "_contributors": [ { "user": "grantmcdermott", "count": 115, "uuid": 10285037 }, { "user": "jamesbrandecon", "count": 12, "uuid": 62019331 }, { "user": "wklimowicz", "count": 3, "uuid": 62679873 }, { "user": "etiennebacher", "count": 2, "uuid": 52219252 } ], "_userbio": { "uuid": 10285037, "type": "user", "name": "Grant McDermott", "followers": 918, "description": "Principal Economist at Amazon. Mix of economics, data science, and open source." }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dbreg" }, "_devurl": "https://github.com/grantmcdermott/dbreg", "_pkgdown": "https://grantmcdermott.com/dbreg/", "_searchresults": 25, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dbreg.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_cranurl": false, "_exports": [ "dbbinsreg", "dbivreg", "dbreg", "glance", "gof", "sql_model_matrix", "tidy" ], "_help": [ { "page": "coef.dbreg", "title": "Extract coefficients from dbreg objects", "topics": [ "coef.dbreg" ] }, { "page": "confint.dbreg", "title": "Confidence intervals for dbreg objects", "topics": [ "confint.dbreg" ] }, { "page": "dbbinsreg", "title": "Run a binscatter regression on a database backend and plot the result", "topics": [ "dbbinsreg" ] }, { "page": "dbivreg", "title": "Instrumental-variables regression on a database backend", "topics": [ "dbivreg" ] }, { "page": "dbreg", "title": "Run a regression on a database backend", "topics": [ "dbreg" ] }, { "page": "gof", "title": "Calculate goodness-of-fit metrics for dbreg objects", "topics": [ "gof" ] }, { "page": "plot.dbbinsreg", "title": "Plot method for dbbinsreg objects", "topics": [ "plot.dbbinsreg", "tinyplot.dbbinsreg" ] }, { "page": "predict.dbreg", "title": "Predict method for dbreg objects", "topics": [ "predict.dbreg" ] }, { "page": "print.dbbinsreg", "title": "Print method for dbbinsreg objects (binsreg-compatible format)", "topics": [ "print.dbbinsreg" ] }, { "page": "print.dbivreg", "title": "Print method for 'dbivreg' objects", "topics": [ "print.dbivreg" ] }, { "page": "print.dbreg", "title": "Print method for dbreg objects", "topics": [ "print.dbreg" ] }, { "page": "sql_model_matrix", "title": "Construct SQL expressions for a design matrix", "topics": [ "sql_model_matrix" ] }, { "page": "tidiers", "title": "Tidiers for `dbreg` objects", "topics": [ "glance.dbreg", "tidiers", "tidy.dbreg" ] }, { "page": "vcov.dbreg", "title": "Variance-covariance matrix for dbreg objects", "topics": [ "vcov.dbreg" ] } ], "_readme": "https://github.com/grantmcdermott/dbreg/raw/HEAD/README.md", "_rundeps": [ "DBI", "duckdb", "Formula", "generics", "glue", "lattice", "MASS", "Matrix", "tinyplot" ], "_score": 5.691965102767361, "_indexed": true, "_nocasepkg": "dbreg", "_universes": [ "grantmcdermott" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.3.99", "date": "2026-10-19T06:43:02.000Z", "distro": "resolute", "commit": "9d1472b221d733910dde451df3c41ba625e07673", "fileid": "https://r2.ropensci.org/c3cac65e8a90520a4b0bcd271c2704f85d6d9eb8c60274a62884416642f6bf60", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/grantmcdermott/actions/runs/39210680213" }, { "r": "4.6.1", "os": "linux", "version": "0.0.3.99", "date": "2026-10-19T06:45:10.000Z", "distro": "resolute", "commit": "9d1472b221d733910dde451df3c41ba625e07673", "fileid": "https://r2.ropensci.org/c1a68befd682fb458e8be426ae58e7416fcbade27a812a6cf75c39ba716c0dcb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/grantmcdermott/actions/runs/39210680213" }, { "r": "4.5.3", "os": "mac", "version": "0.0.3.99", "date": "2026-10-19T06:48:28.000Z", "commit": "9d1472b221d733910dde451df3c41ba625e07673", "fileid": "https://r2.ropensci.org/1e7b7995f5821fb28f0f90e6496bd8a70aac5f5fe85504420449620142554f23", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/grantmcdermott/actions/runs/39210680213" }, { "r": "4.6.1", "os": "mac", "version": "0.0.3.99", "date": "2026-10-19T06:49:58.000Z", "commit": "9d1472b221d733910dde451df3c41ba625e07673", "fileid": "https://r2.ropensci.org/b3adaa2e8e1e510a07e811f3581d92f94603f7e93a6cd88823254f5d2b023996", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/grantmcdermott/actions/runs/39210680213" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.3.99", "date": "2026-10-19T06:45:13.000Z", "commit": "9d1472b221d733910dde451df3c41ba625e07673", "fileid": "https://r2.ropensci.org/eaf4d0f2d8bbc848eb9846c25a6923bab24af27f1543737212b80a53d98a6f32", "status": "success", "buildurl": "https://github.com/r-universe/grantmcdermott/actions/runs/39210680213" }, { "r": "4.7.0", "os": "win", "version": "0.0.3.99", "date": "2026-10-19T06:41:43.000Z", "commit": "9d1472b221d733910dde451df3c41ba625e07673", "fileid": "https://r2.ropensci.org/9bdf08555d57b02bacd1c98fc2d9bd80a9d28ee47e0457c1d4839e202670ebd8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/grantmcdermott/actions/runs/39210680213" }, { "r": "4.5.3", "os": "win", "version": "0.0.3.99", "date": "2026-10-19T06:41:54.000Z", "commit": "9d1472b221d733910dde451df3c41ba625e07673", "fileid": "https://r2.ropensci.org/a4fa2e8fd2adb3e2c8b56c1fb4d6394d6f42cdc50ef8531c3b42a53d8093da73", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/grantmcdermott/actions/runs/39210680213" }, { "r": "4.6.1", "os": "win", "version": "0.0.3.99", "date": "2026-10-19T06:44:11.000Z", "commit": "9d1472b221d733910dde451df3c41ba625e07673", "fileid": "https://r2.ropensci.org/187bcf14ef8976944758e1d09374c1d15ad9221ccbac8a38283c7668d09a5df0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/grantmcdermott/actions/runs/39210680213" } ] }