{
  "_id": "6a480cd9e06c18f0a6529e0a",
  "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-07-03 19:21:21 UTC",
    "User": "root"
  },
  "Author": "Edgar Ruiz [aut],\nMax Kuhn [aut, cre]",
  "Maintainer": "Max Kuhn <max@posit.co>",
  "_user": "tidymodels",
  "_type": "src",
  "_file": "modeldb_0.3.1.9000.tar.gz",
  "_fileid": "https://r2.ropensci.org/0b0625569aa70e9d392c5888ed78560cd5fcb311ae2df503244ad05278172b61",
  "_filesize": 531320,
  "_sha256": "0b0625569aa70e9d392c5888ed78560cd5fcb311ae2df503244ad05278172b61",
  "_expires": "2026-10-11T19:26:15.000Z",
  "_created": "2026-07-03T19:21:21.000Z",
  "_published": "2026-07-03T19:26:17.381Z",
  "_jobs": [
    {
      "job": 85060124799,
      "time": 157,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "8073582080"
    },
    {
      "job": 85060124821,
      "time": 150,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8073580482"
    },
    {
      "job": 85060124786,
      "time": 78,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "8073592818"
    },
    {
      "job": 85060124785,
      "time": 127,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8073601605"
    },
    {
      "job": 85059683695,
      "time": 231,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8073549731"
    },
    {
      "job": 85060124789,
      "time": 134,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "8073577176"
    },
    {
      "job": 85060124808,
      "time": 106,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "8073571209"
    },
    {
      "job": 85060124804,
      "time": 254,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "8073601707"
    },
    {
      "job": 85060124812,
      "time": 97,
      "config": "windows-release",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8073569346"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/tidymodels/actions/runs/28679422604",
  "_status": "success",
  "_upstream": "https://github.com/tidymodels/modeldb",
  "_commit": {
    "id": "5d925298563a83c3ecca194bec4923e8defc5625",
    "author": "‘topepo’ <mxkuhn@gmail.com>",
    "committer": "‘topepo’ <mxkuhn@gmail.com>",
    "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
  },
  "_distro": "resolute",
  "_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": 79,
  "_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",
    "followers": 555
  },
  "_downloads": {
    "count": 636,
    "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.1",
  "_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",
    "LICENSE",
    "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.600057627735967,
  "_indexed": true,
  "_nocasepkg": "modeldb",
  "_universes": [
    "tidymodels",
    "topepo"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.3.1.9000",
      "date": "2026-07-03T19:23:50.000Z",
      "distro": "resolute",
      "commit": "5d925298563a83c3ecca194bec4923e8defc5625",
      "fileid": "https://r2.ropensci.org/c04f990f2d6aafd8c742b5ae1dc4edb1943b76e51d2545925c4fb1566a9b40f4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/28679422604"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.3.1.9000",
      "date": "2026-07-03T19:23:41.000Z",
      "distro": "resolute",
      "commit": "5d925298563a83c3ecca194bec4923e8defc5625",
      "fileid": "https://r2.ropensci.org/afb268c4fe725071aea5be48d1a72c9bcaeebd36d1f070a84d67426ea0a1eba0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/28679422604"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.1.9000",
      "date": "2026-07-03T19:24:56.000Z",
      "commit": "5d925298563a83c3ecca194bec4923e8defc5625",
      "fileid": "https://r2.ropensci.org/2eaf8768dd6165db94e49d90f56351aecdc71b873c604841047fe5ed3512b7ed",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/28679422604"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.3.1.9000",
      "date": "2026-07-03T19:25:33.000Z",
      "commit": "5d925298563a83c3ecca194bec4923e8defc5625",
      "fileid": "https://r2.ropensci.org/fba89786da49ce8fb5cd269e59ba6324690457ca7fcbcd9b97e8082b4fc3a084",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/28679422604"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.1.9000",
      "date": "2026-07-03T19:23:55.000Z",
      "commit": "5d925298563a83c3ecca194bec4923e8defc5625",
      "fileid": "https://r2.ropensci.org/36be6f8004d274082bc33b0ea5dc13fa7cb753c8f1efcf7dd4f73c627be7ba0a",
      "status": "success",
      "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/28679422604"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.1.9000",
      "date": "2026-07-03T19:22:58.000Z",
      "commit": "5d925298563a83c3ecca194bec4923e8defc5625",
      "fileid": "https://r2.ropensci.org/9e7b48e2d79dd4d09d0d0d622dd5f3177c7fb5c32207fcc5d71513609183330b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/28679422604"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.1.9000",
      "date": "2026-07-03T19:25:22.000Z",
      "commit": "5d925298563a83c3ecca194bec4923e8defc5625",
      "fileid": "https://r2.ropensci.org/fc282186db4d31c23990bc29a00fa97e8c586b8ab29e0335b5ed681a9fd976fc",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/28679422604"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.3.1.9000",
      "date": "2026-07-03T19:22:35.000Z",
      "commit": "5d925298563a83c3ecca194bec4923e8defc5625",
      "fileid": "https://r2.ropensci.org/0ea1b4c60cd405f12d20031c9bca6694c674c9c0a739a4e738955fa27b88c461",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tidymodels/actions/runs/28679422604"
    }
  ]
}