R Observatory: Metrics for xgb2sql version 0.1.3

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

xgb2sql

0.1.3

Convert Trained 'XGBoost' Model to SQL Query

0packages depend

2.8Kdownloads / year

–test coverage

13/13checks pass

Overview

About

Maintained by Chengjun HouFirst published 2019-03-132 releasesCRAN page ↗GitHub ↗

This tool enables in-database scoring of 'XGBoost' models built in R, by translating trained model objects into SQL query. 'XGBoost' https://github.com/dmlc/xgboost provides parallel tree boosting (also known as gradient boosting machine, or GBM) algorithms in a highly efficient, flexible and portable way. GBM algorithm is introduced by Friedman (2001) doi:10.1214/aos/1013203451, and more details on 'XGBoost' can be found in Chen & Guestrin (2016) doi:10.1145/2939672.2939785.

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("xgb2sql", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("chengjunhou/xgb2sql")

Development version from chengjunhou/xgb2sql. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-xgb2sql

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-xgb2sql

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-xgb2sql

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

13OK

Slowest check: 1.7 min · r-oldrel-macos-x86_64

Code health

None

Tests · ratio 0.00

not tracked

Coverage

100%

Documentation · exports

2

Dependencies · direct

Check history

OK2026-08-04
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
NOTE2026-08-01
12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-03-10
14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 409 wordsVignettesYes · dynamicpkgdown siteNoNEWSYes · 67% structuredCode of conductNoContributing guideNo

Examples that run: 100%
Documented parameters: 100%
Return-value docs: 100%
References docs: 0%

Downloads

2.8K

CRAN downloads in the past year

Rank #17,270 · ~8/day · ~233/mo

Releases R versions

Daily download trend is not available in this view yet.

14430 days

62490 days

2.8K1 year

Compare downloads with other packages →

Also on121 r2u9 autocran

Repository

GitHub ↗ chengjunhou/xgb2sql

24Stars

3Forks

1Open issues

0Open PRs

1Releases

41Commits

3Contributors

41 commits · Last activity 2025-12-12

Repository practices

Upstream repositoryBeta

3 development-tooling and community-health practices detected across 3 families in the upstream repository

Checks run against github.com/chengjunhou/xgb2sql on 2026-08-09.

Continuous integration (1)

Travis CI

CRAN release process (1)

cran-comments.md

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

5 external dependencies (excludes base and recommended)

Depends (1)

R >= 3.1.0

Imports (2)

xgboost data.table

LinkingTo (0)

none

Suggests (3)

ggplot2 knitr rmarkdown

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

People & History

People (2)

Maintainer (1)

Chengjun Hou

Author, Maintainer

Authors (2)

Chengjun Hou

Author, Maintainer

Abhishek Bishoyi

Author

Package Timeline

2 releases. Pick two to compare their code metrics. R releases are shown for context.

R
R 4.6.0 released · 2026-04-24
0.1.3Latest
2025-12-13 · current release · diff ↗
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
R
R 4.3.0 released · 2023-04-21
R
R 4.2.0 released · 2022-04-22
R
R 4.1.0 released · 2021-05-18
R
R 4.0.0 released · 2020-04-24
R
R 3.6.0 released · 2019-04-26
0.1.2
2019-03-13
R
R 3.5.0 released · 2018-04-23

Package metadata

First published: 2019-03-13
Total releases: 2 / 7 yrs
License: MIT + file LICENSE OSI
Minimum R: ≥ 3.1.0
Download size: 25 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Appears in task views

Databases with R

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("xgb2sql")

Format

Hou, C., & Bishoyi, A. (2025). xgb2sql: Convert Trained 'XGBoost' Model to SQL Query (Version 0.1.3) [Computer software]. https://doi.org/10.32614/CRAN.package.xgb2sql

This is what citation() produces when a package has no citation file of its own. If it prints something else, use that.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for xgb2sql version 0.1.3 [Data set]. HJJB, LLC. Data release v2026-08-15. https://doi.org/10.5281/zenodo.21843040

From data release v2026-08-15, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →