Run Predictions Inside the Database
Overview
It parses a fitted 'R' model object, and returns a formula in 'Tidy Eval' code that calculates the predictions. It works with several databases back-ends because it leverages 'dplyr' and 'dbplyr' for the final 'SQL' translation of the algorithm. Dozens of model classes are supported; see the "Supported models" article at https://tidypredict.tidymodels.org/articles/models.html for the current list.
vignettes/h2o.Rmdnow shuts down the H2O cluster it starts, so the Java process it spawns no longer outlives the vignette build (leftover processes were flagged on CRAN's check systems).
From NEWS.md in the release
Install
Health
ERRORre-building of vignette outputsr-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc, r-devel-windows-x86_64, r-oldrel-windows-x86_64, r-release-windows-x86_64
r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc
Error(s) in re-building vignettes: --- re-building ‘C5.0.Rmd’ using rmarkdown [WARNING] Deprecated: --mathjax. Use --math-method=mathjax[:URL] instead. --- finished re-building ‘C5.0.Rmd’ --- re-building ‘aorsf.Rmd’ using rmarkdown [WARNING] Deprecated: --mathjax. Use --math-method=mathjax[:URL] instead. --- finished re-building ‘aorsf.Rmd’ --- re-building ‘bagging.Rmd’ using rmarkdown [WARNING] Deprecated: --mathjax. Use --math-method=mathjax[:URL] instead. --- finished re-building ‘bagging.Rmd’ --- re-building ‘bart.Rmd’ using rmarkdown [WARNING] Deprecated: --mathjax. Use --math-method=mathjax[:URL] instead. --- finished re-building ‘bart.Rmd’ --- re-building ‘cubist.Rmd’ using rmarkdown [WARNING] Deprecated: --mathjax. Use --math-method=mathjax[:URL] instead. --- finished re-building ‘cubist.Rmd’ --- re-building ‘fda.Rmd’ using rmarkdown [WARNING] Deprecated: --mathjax. Use --math-method=mathjax[:URL] instead. --- finished re-building ‘fda.Rmd’ --- re-building ‘float-precisio ...[truncated]... -mathjax. Use --math-method=mathjax[:URL] instead. --- finished re-building ‘sparsediscrim.Rmd’ --- re-building ‘sql.Rmd’ using rmarkdown [WARNING] Deprecated: --mathjax. Use --math-method=mathjax[:URL] instead. --- finished re-building ‘sql.Rmd’ --- re-building ‘tree-internals.Rmd’ using rmarkdown [WARNING] Deprecated: --mathjax. Use --math-method=mathjax[:URL] instead. --- finished re-building ‘tree-internals.Rmd’ --- re-building ‘tree.Rmd’ using rmarkdown [WARNING] Deprecated: --mathjax. Use --math-method=mathjax[:URL] instead. --- finished re-building ‘tree.Rmd’ --- re-building ‘xgboost.Rmd’ using rmarkdown [WARNING] Deprecated: --mathjax. Use --math-method=mathjax[:URL] instead. --- finished re-building ‘xgboost.Rmd’ --- re-building ‘xrf.Rmd’ using rmarkdown [WARNING] Deprecated: --mathjax. Use --math-method=mathjax[:URL] instead. --- finished re-building ‘xrf.Rmd’ SUMMARY: processing the following file failed: ‘lm.Rmd’ Error: Vignette re-building failed. Execution halted
r-devel-windows-x86_64, r-release-windows-x86_64
Error(s) in re-building vignettes: --- re-building 'C5.0.Rmd' using rmarkdown --- finished re-building 'C5.0.Rmd' --- re-building 'aorsf.Rmd' using rmarkdown --- finished re-building 'aorsf.Rmd' --- re-building 'bagging.Rmd' using rmarkdown --- finished re-building 'bagging.Rmd' --- re-building 'bart.Rmd' using rmarkdown --- finished re-building 'bart.Rmd' --- re-building 'cubist.Rmd' using rmarkdown --- finished re-building 'cubist.Rmd' --- re-building 'fda.Rmd' using rmarkdown --- finished re-building 'fda.Rmd' --- re-building 'float-precision.Rmd' using rmarkdown --- finished re-building 'float-precision.Rmd' --- re-building 'glm.Rmd' using rmarkdown --- finished re-building 'glm.Rmd' --- re-building 'glmnet.Rmd' using rmarkdown --- finished re-building 'glmnet.Rmd' --- re-building 'h2o.Rmd' using rmarkdown openjdk version "11.0.18" 2023-01-17 OpenJDK Runtime Environment Temurin-11.0.18+10 (build 11.0.18+10) OpenJDK 64-Bit Server VM Temurin-11.0.18+10 (build 11.0.18+10, mix ...[truncated]... rmarkdown --- finished re-building 'regression.Rmd' --- re-building 'rf.Rmd' using rmarkdown --- finished re-building 'rf.Rmd' --- re-building 'rpart.Rmd' using rmarkdown --- finished re-building 'rpart.Rmd' --- re-building 'save.Rmd' using rmarkdown --- finished re-building 'save.Rmd' --- re-building 'sda.Rmd' using rmarkdown --- finished re-building 'sda.Rmd' --- re-building 'sparsediscrim.Rmd' using rmarkdown --- finished re-building 'sparsediscrim.Rmd' --- re-building 'sql.Rmd' using rmarkdown --- finished re-building 'sql.Rmd' --- re-building 'tree-internals.Rmd' using rmarkdown --- finished re-building 'tree-internals.Rmd' --- re-building 'tree.Rmd' using rmarkdown --- finished re-building 'tree.Rmd' --- re-building 'xgboost.Rmd' using rmarkdown --- finished re-building 'xgboost.Rmd' --- re-building 'xrf.Rmd' using rmarkdown --- finished re-building 'xrf.Rmd' SUMMARY: processing the following file failed: 'lm.Rmd' Error: Vignette re-building failed. Execution halted
r-oldrel-windows-x86_64
Error(s) in re-building vignettes: --- re-building 'C5.0.Rmd' using rmarkdown --- finished re-building 'C5.0.Rmd' --- re-building 'aorsf.Rmd' using rmarkdown --- finished re-building 'aorsf.Rmd' --- re-building 'bagging.Rmd' using rmarkdown --- finished re-building 'bagging.Rmd' --- re-building 'bart.Rmd' using rmarkdown --- finished re-building 'bart.Rmd' --- re-building 'cubist.Rmd' using rmarkdown --- finished re-building 'cubist.Rmd' --- re-building 'fda.Rmd' using rmarkdown --- finished re-building 'fda.Rmd' --- re-building 'float-precision.Rmd' using rmarkdown --- finished re-building 'float-precision.Rmd' --- re-building 'glm.Rmd' using rmarkdown --- finished re-building 'glm.Rmd' --- re-building 'glmnet.Rmd' using rmarkdown --- finished re-building 'glmnet.Rmd' --- re-building 'h2o.Rmd' using rmarkdown openjdk version "11.0.11" 2021-04-20 OpenJDK Runtime Environment AdoptOpenJDK-11.0.11+9 (build 11.0.11+9) OpenJDK 64-Bit Server VM AdoptOpenJDK-11.0.11+9 (build 11.0.11+ ...[truncated]... rmarkdown --- finished re-building 'regression.Rmd' --- re-building 'rf.Rmd' using rmarkdown --- finished re-building 'rf.Rmd' --- re-building 'rpart.Rmd' using rmarkdown --- finished re-building 'rpart.Rmd' --- re-building 'save.Rmd' using rmarkdown --- finished re-building 'save.Rmd' --- re-building 'sda.Rmd' using rmarkdown --- finished re-building 'sda.Rmd' --- re-building 'sparsediscrim.Rmd' using rmarkdown --- finished re-building 'sparsediscrim.Rmd' --- re-building 'sql.Rmd' using rmarkdown --- finished re-building 'sql.Rmd' --- re-building 'tree-internals.Rmd' using rmarkdown --- finished re-building 'tree-internals.Rmd' --- re-building 'tree.Rmd' using rmarkdown --- finished re-building 'tree.Rmd' --- re-building 'xgboost.Rmd' using rmarkdown --- finished re-building 'xgboost.Rmd' --- re-building 'xrf.Rmd' using rmarkdown --- finished re-building 'xrf.Rmd' SUMMARY: processing the following file failed: 'lm.Rmd' Error: Vignette re-building failed. Execution halted
- ERROR8 OK, 5 ERRORNow
- ERROR11 OK, 2 ERROR2026-09-28
- OK13 OK2026-08-04
- NOTE12 OK, 1 NOTE2026-08-01
- OK13 OK2026-07-04
- WARNING12 OK, 1 WARNING2026-07-03
Show 5 earlier changesHide 5 earlier changes
- OK13 OK2026-06-19
- WARNING12 OK, 1 WARNING2026-06-17
- OK13 OK2026-06-09
- ERROR12 OK, 1 ERROR2026-06-08
- OK14 OK2026-03-10
Documentation
The repository also keeps web-only articles.
- Help pages
- 37 (22 internal)includes a package overview page
- Examples that run
- 100%15 run in a plain check (6 of them under a condition)
- Exported functions with examples
- 54%
- Documented parameters
- 100%
- Return-value docs
- 58%
- Help pages citing references
- 0%
- bagger models HTML
- bart models HTML
- Create a regression spec - version 2 HTML
- Create a tree spec - version 2 HTML
- Cubist models HTML
- Database write-back HTML
- Decision trees, using C5.0 HTML
- Decision trees, using rpart HTML
- fda models HTML
- Float precision at split boundaries HTML
Show 27 moreHide 27 vignettes
- Generalized Linear Regression HTML
- glmnet models HTML
- Gradient boosting, using H2O HTML
- How tidypredict generates tree formulas HTML
- lda models HTML
- LightGBM models HTML
- Linear Regression HTML
- MARS models via the `earth` package HTML
- mixOmics PLS models HTML
- Model-based boosting, using mboost HTML
- multinom models HTML
- NaiveBayes models HTML
- nnet models HTML
- Non-R Models HTML
- nullmodel models HTML
- Oblique Random Forest, using aorsf HTML
- qda models HTML
- Random Forest HTML
- Random Forest - partykit HTML
- Random Forest, using Ranger HTML
- RuleFit, using xrf HTML
- Save and re-load models HTML
- sda models HTML
- sparsediscrim models HTML
- Support vector machines, using kernlab HTML
- Supported models HTML
- XGBoost models HTML
Downloads
Repository
- PRs merged (all time)
- 100%
- Median days to close, 50 most recently updated closed issues
- 4
- Median days to close, 50 most recently updated closed PRs
- 0
Stars over time
Forks over time
Releases over time
Issues over time
PRs over time
Commits over time
Commit identities over time
15 development-tooling and community-health practices detected across 6 families in the upstream repository
Checks run against github.com/tidymodels/tidypredict on 2026-10-11.
The R CMD check workflow runs on Linux, macOS and Windows, and on R-devel
GitHub Pages site last deployed 2026-09-04 · The repository has a site deploy workflow
pkgdown site last built 2026-09-04, before release 1.2.1 (2026-09-09)
Show all practicesHide 2 practices
This repository shows signs of AI coding tools.
- Claude Codefirst seen 2026-02-11Seen in the repository: .claude, .claude/skillsNamed in .Rbuildignore: .claude
Dependencies
Installing tidypredict adds 26 packages (15 with compiled code, 20 MB of source tarballs). Heaviest: stringi 11 MB, jsonlite 1.0 MB, vctrs 1.0 MB.
Code & Tests
People & History
Previously maintained by Edgar Ruiz (0.5) and Max Kuhn (0.4.5 to 0.4.9).
Pick two releases to compare their code metrics.
- 1.2.1Latest
- 1.2.02026-09-04 · diff ↗ ·
added 15 exports
.c50_tree_info_full, .extract_bagger_classprob, .extract_bagger_trees, .extract_bart_scaling, .extract_bart_trees, tidypredict_class_exprs, tidypredict_class_trees, tidypredict_combine_trees, tidypredict_load, tidypredict_n_trees, tidypredict_normalized, tidypredict_outcome_levels, tidypredict_output_type, tidypredict_save, tidypredict_trees - RR 4.6.0 released · 2026-04-24
- 1.1.12026-02-27 · diff ↗
- 1.1.02026-02-27 · diff ↗ ·
added 15 exports
.build_case_when_tree, .build_linear_pred, .build_nested_case_when_tree, .extract_catboost_trees, .extract_earth_multiclass, .extract_glmnet_multiclass, .extract_lgb_trees, .extract_ranger_classprob, .extract_ranger_trees, .extract_rf_classprob, .extract_rf_trees, .extract_rpart_classprob, .partykit_tree_info_full, .rpart_tree_info_full, set_catboost_categories - 1.0.12025-12-13 · diff ↗
- 1.0.02025-11-29 · diff ↗
- RR 4.5.0 released · 2025-04-11
- 0.5.1
- RR 4.4.0 released · 2024-04-24
- RR 4.3.0 released · 2023-04-21
- 0.52023-01-18 · diff ↗
- 0.4.92022-05-25 · diff ↗
- RR 4.2.0 released · 2022-04-22
- RR 4.1.0 released · 2021-05-18
- 0.4.82020-10-28 · diff ↗
Show 16 earlier eventsHide 16 earlier events
- 0.4.72020-10-05 · diff ↗
- 0.4.62020-07-23 · diff ↗
- RR 4.0.0 released · 2020-04-24
- 0.4.52020-02-10 · diff ↗
- 0.4.42020-02-09 · diff ↗
- 0.4.32019-09-03 · diff ↗
- 0.4.22019-07-15 · diff ↗
- 0.4.12019-07-15 · diff ↗
- 0.4.0
- RR 3.6.0 released · 2019-04-26
- 0.3.0
- 0.2.12018-12-20 · diff ↗
- RR 3.5.0 released · 2018-04-23
- 0.2.02018-02-26 · diff ↗
- 0.1.02018-01-17
- RR 3.4.0 released · 2017-04-21
Package metadata
- First published
- 2018-01-17
- Total releases
- 22 / 8 yrs
- License
- MIT + file LICENSE OSI · relicensed from GPL-3 in 0.4.9
- Minimum R
- ≥ 4.1
- Download size
- 698 KB
Cite
Cite this package
Run in R for the authors' preferred citation:
citation("tidypredict")This package has no citation file, so citation() returns this entry built from DESCRIPTION.
Cite the R Observatory
For a number measured here: a download total, a coverage figure, an archival date.
From data release v2026-10-17, which the citation names so these numbers can be found later. More on citing and the projects behind them.