{ "_id": "6a17ea69acfb0bcc41da2bad", "Package": "modeldb", "Title": "Fits Models Inside the Database", "Version": "0.3.1.9000", "Authors@R": "c(\nperson(\"Edgar\", \"Ruiz\", , \"edgar@posit.co\", role = \"aut\"),\nperson(\"Max\", \"Kuhn\", , \"max@posit.co\", role = c(\"aut\", \"cre\"))\n)", "Description": "Uses 'dplyr' and 'tidyeval' to fit statistical models\ninside the database. It currently supports KMeans and linear\nregression models.", "License": "MIT + file LICENSE", "URL": "https://modeldb.tidymodels.org,\nhttps://github.com/tidymodels/modeldb", "BugReports": "https://github.com/tidymodels/modeldb/issues", "VignetteBuilder": "knitr", "Config/Needs/website": "tidyverse/tidytemplate", "Config/testthat/edition": "3", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://tidymodels.r-universe.dev", "Date/Publication": "2025-08-22 17:23:02 UTC", "RemoteUrl": "https://github.com/tidymodels/modeldb", "RemoteRef": "HEAD", "RemoteSha": "5d925298563a83c3ecca194bec4923e8defc5625", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-28 06:59:37 UTC", "User": "root" }, "Author": "Edgar Ruiz [aut],\nMax Kuhn [aut, cre]", "Maintainer": "Max Kuhn ", "MD5sum": "9ed3fdc2d18585dceb33ac1a0b43a7a1", "_user": "tidymodels", "_type": "src", "_file": "modeldb_0.3.1.9000.tar.gz", "_fileid": "305578c5b67b66c1e3dc078ff560ccd1e5b0a5c793439a6046a7548c483dca79", "_filesize": 529927, "_sha256": "305578c5b67b66c1e3dc078ff560ccd1e5b0a5c793439a6046a7548c483dca79", "_created": "2026-05-28T06:59:37.000Z", "_published": "2026-05-28T07:10:33.246Z", "_distro": "noble", "_jobs": [ { "job": 78239992867, "time": 154, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7259641747" }, { "job": 78239992854, "time": 191, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7259651552" }, { "job": 78239992889, "time": 87, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7259762246" }, { "job": 78239992843, "time": 111, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7259664846" }, { "job": 78239405018, "time": 271, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7259599081" }, { "job": 78239992826, "time": 135, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7259636707" }, { "job": 78239992844, "time": 146, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7259639444" }, { "job": 78239992856, "time": 119, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7259632430" }, { "job": 78239992917, "time": 228, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7259661412" } ], "_buildurl": "https://github.com/r-universe/tidymodels/actions/runs/26559678545", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/tidymodels/modeldb", "_commit": { "id": "5d925298563a83c3ecca194bec4923e8defc5625", "author": "‘topepo’ ", "committer": "‘topepo’ ", "message": "Increment version number to 0.3.1.9000\n", "time": 1755883382 }, "_maintainer": { "name": "Max Kuhn", "email": "max@posit.co", "login": "topepo", "description": "", "uuid": 5731043 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.6", "role": "Depends" }, { "package": "cli", "role": "Imports" }, { "package": "dplyr", "version": ">= 0.7", "role": "Imports" }, { "package": "ggplot2", "role": "Imports" }, { "package": "progress", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "rlang", "version": ">= 1.1.1", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "tidypredict", "role": "Imports" }, { "package": "covr", "role": "Suggests" }, { "package": "DBI", "role": "Suggests" }, { "package": "dbplyr", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "methods", "role": "Suggests" }, { "package": "nycflights13", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.2.0", "role": "Suggests" } ], "_owner": "tidymodels", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-34", "n": 2 } ], "_tags": [ { "name": "v0.3.1", "date": "2025-08-22" } ], "_topics": [ "database", "dbplyr", "dplyr", "ggplot2", "modeling", "rlang", "sql", "tidyeval", "visualization" ], "_stars": 78, "_contributors": [ { "user": "edgararuiz", "count": 98, "uuid": 77294576 }, { "user": "topepo", "count": 35, "uuid": 5731043 }, { "user": "edgararuiz-zz", "count": 19, "uuid": 7875923 }, { "user": "juliasilge", "count": 13, "uuid": 12505835 }, { "user": "hfrick", "count": 4, "uuid": 12950918 }, { "user": "emilhvitfeldt", "count": 2, "uuid": 14034784 }, { "user": "garrettmooney", "count": 1, "uuid": 4910020 }, { "user": "hadley", "count": 1, "uuid": 4196 }, { "user": "karldw", "count": 1, "uuid": 12504708 } ], "_userbio": { "uuid": 29100987, "type": "organization", "name": "tidymodels" }, "_downloads": { "count": 582, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/modeldb" }, "_devurl": "https://github.com/tidymodels/modeldb", "_pkgdown": "https://modeldb.tidymodels.org", "_searchresults": 63, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/modeldb.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/tidymodels/modeldb", "_realowner": "tidymodels", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2018-05-07" }, { "version": "0.1.1", "date": "2019-01-07" }, { "version": "0.1.2", "date": "2019-03-04" }, { "version": "0.2.0", "date": "2019-07-20" }, { "version": "0.2.1", "date": "2020-02-07" }, { "version": "0.2.2", "date": "2020-02-10" }, { "version": "0.2.3", "date": "2022-08-16" }, { "version": "0.3.0", "date": "2023-11-01" }, { "version": "0.3.1", "date": "2025-08-22" } ], "_exports": [ "add_dummy_variables", "as_parsed_model", "db_calculate_squares", "linear_regression_db", "plot_kmeans", "simple_kmeans_db" ], "_help": [ { "page": "add_dummy_variables", "title": "Creates dummy variables", "topics": [ "add_dummy_variables" ] }, { "page": "as_parsed_model.modeldb_lm", "title": "Prepares parsed model object", "topics": [ "as_parsed_model.modeldb_lm" ] }, { "page": "linear_regression_db", "title": "Fits a Linear Regression model", "topics": [ "linear_regression_db" ] }, { "page": "plot_kmeans", "title": "Visualize a KMeans Cluster with lots of data", "topics": [ "db_calculate_squares", "plot_kmeans" ] }, { "page": "simple_kmeans_db", "title": "Simple kmeans routine that works in-database", "topics": [ "simple_kmeans_db" ] } ], "_pkglogo": "https://github.com/tidymodels/modeldb/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/tidymodels/modeldb/raw/HEAD/README.md", "_rundeps": [ "cli", "cpp11", "crayon", "dplyr", "evaluate", "farver", "generics", "ggplot2", "glue", "gtable", "highr", "hms", "isoband", "jsonlite", "knitr", "labeling", "lifecycle", "magrittr", "pillar", "pkgconfig", "prettyunits", "progress", "purrr", "R6", "RColorBrewer", "rlang", "S7", "scales", "stringi", "stringr", "tibble", "tidypredict", "tidyr", "tidyselect", "utf8", "vctrs", "viridisLite", "withr", "xfun", "yaml" ], "_vignettes": [ { "source": "kmeans.Rmd", "filename": "kmeans.html", "title": "K Means models", "author": "Edgar Ruiz", "engine": "knitr::rmarkdown", "headings": [ "Intro", "Example setup", "Running Kmeans clustering", "Under the hood", "Safeguards for long running jobs" ], "created": "2018-03-04 19:21:37", "modified": "2023-10-31 18:13:29", "commits": 13 }, { "source": "linear-regression.Rmd", "filename": "linear-regression.html", "title": "Linear regression models", "author": "Edgar Ruiz", "engine": "knitr::rmarkdown", "headings": [ "Intro", "Example setup", "Model inside the database", "Categorical variables", "Multiple linear regression", "Interactions", "Full example" ], "created": "2019-03-02 02:47:34", "modified": "2023-10-31 18:48:08", "commits": 3 } ], "_score": 7.594525139136006, "_indexed": true, "_nocasepkg": "modeldb", "_universes": [ "tidymodels", "topepo" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.1.9000", "date": "2026-05-28T07:02:02.000Z", "distro": "noble", "commit": "5d925298563a83c3ecca194bec4923e8defc5625", "fileid": "7475246bb9baf98fc7f9b7111e2cc714ef820ae20b75eb0749d4c721e6bc0e75", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/26559678545" }, { "r": "4.6.0", "os": "linux", "version": "0.3.1.9000", "date": "2026-05-28T07:02:42.000Z", "distro": "noble", "commit": "5d925298563a83c3ecca194bec4923e8defc5625", "fileid": "f41262121d430a9baac5360f5f96c16d149932dff8c0ae4c4c2b931dae13827f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/26559678545" }, { "r": "4.5.3", "os": "mac", "version": "0.3.1.9000", "date": "2026-05-28T07:09:52.000Z", "commit": "5d925298563a83c3ecca194bec4923e8defc5625", "fileid": "044c72b52c21b413ce37a94fb1553f5850e005780bf5ef32aa3a7f0fa47bf83a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/26559678545" }, { "r": "4.6.0", "os": "mac", "version": "0.3.1.9000", "date": "2026-05-28T07:03:36.000Z", "commit": "5d925298563a83c3ecca194bec4923e8defc5625", "fileid": "6e14ffd49aa2160a135332b8df86d37a34835e0ccadba6373064be36f3458453", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/26559678545" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.1.9000", "date": "2026-05-28T07:02:13.000Z", "commit": "5d925298563a83c3ecca194bec4923e8defc5625", "fileid": "d4c44b5486a320d2e8848e68da1ceb75589d253a230aefd52479c52bcedf5fe3", "status": "success", "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/26559678545" }, { "r": "4.7.0", "os": "win", "version": "0.3.1.9000", "date": "2026-05-28T07:01:44.000Z", "commit": "5d925298563a83c3ecca194bec4923e8defc5625", "fileid": "83e20f61b45087d255f783cecf072d20e19af2d5597b89dea01ef57bd767c8bf", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/26559678545" }, { "r": "4.5.3", "os": "win", "version": "0.3.1.9000", "date": "2026-05-28T07:01:29.000Z", "commit": "5d925298563a83c3ecca194bec4923e8defc5625", "fileid": "40cbaf903ae409e3cac75781e8bf1993b4f6c4f0f751ad04155e6e7b106bc28c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/26559678545" }, { "r": "4.6.0", "os": "win", "version": "0.3.1.9000", "date": "2026-05-28T07:03:09.000Z", "commit": "5d925298563a83c3ecca194bec4923e8defc5625", "fileid": "415bc4bb2aa9453b2ea06078ea9fea437d68b8197c497cf4fefadcbbde316696", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/26559678545" } ] }