{ "_id": "6aaf983c3d719c1f8407f775", "Package": "xgb2sql", "Type": "Package", "Title": "Convert Trained 'XGBoost' Model to SQL Query", "Version": "0.1.3", "Description": "This tool enables in-database scoring of 'XGBoost' models\nbuilt in R, by translating trained model objects into SQL\nquery. 'XGBoost' provides\nparallel tree boosting (also known as gradient boosting\nmachine, or GBM) algorithms in a highly efficient, flexible and\nportable way. GBM algorithm is introduced by Friedman (2001)\n, and more details on 'XGBoost' can\nbe found in Chen & Guestrin (2016)\n.", "Authors@R": "c(\nperson(\"Chengjun\", \"Hou\", role = c(\"aut\", \"cre\"), email = \"chengjun.hou@gmail.com\"),\nperson(\"Abhishek\", \"Bishoyi\", role = c(\"aut\"), email = \"abhishek.bishoyi@gmail.com\")\n)", "Author": "Chengjun Hou [aut, cre], Abhishek Bishoyi [aut]", "Maintainer": "Chengjun Hou ", "URL": "https://github.com/chengjunhou/xgb2sql", "BugReports": "https://github.com/chengjunhou/xgb2sql/issues", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "RoxygenNote": "6.1.1", "VignetteBuilder": "knitr", "Config/pak/sysreqs": "make", "Repository": "https://chengjunhou.r-universe.dev", "Date/Publication": "2025-12-12 21:58:13 UTC", "RemoteUrl": "https://github.com/chengjunhou/xgb2sql", "RemoteRef": "HEAD", "RemoteSha": "db2503b0254a0daff54f98eb36a358240febfa97", "NeedsCompilation": "no", "Packaged": { "Date": "2026-09-20 08:21:28 UTC", "User": "root" }, "_user": "chengjunhou", "_type": "src", "_file": "xgb2sql_0.1.3.tar.gz", "_fileid": "https://r2.ropensci.org/983aa557ebea61355df4d34e7114b82c5bff21131ee08c329e37efc694d9a6fc", "_filesize": 132366, "_sha256": "983aa557ebea61355df4d34e7114b82c5bff21131ee08c329e37efc694d9a6fc", "_expires": "2026-12-29T08:24:27.000Z", "_created": "2026-09-20T08:21:28.000Z", "_published": "2026-09-20T08:24:28.712Z", "_jobs": [ { "job": 106048189967, "time": 123, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10601399872" }, { "job": 106048189979, "time": 126, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10601639527" }, { "job": 106048189993, "time": 141, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "10602010086" }, { "job": 106048190013, "time": 138, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "10601514640" }, { "job": 106047827227, "time": 170, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "10600689121" }, { "job": 106048189952, "time": 109, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "10602005180" }, { "job": 106048190044, "time": 71, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10601544776" }, { "job": 106048190109, "time": 67, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "10601935266" }, { "job": 106048190110, "time": 78, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10600833849" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/chengjunhou/actions/runs/35499200298", "_status": "success", "_upstream": "https://github.com/chengjunhou/xgb2sql", "_commit": { "id": "db2503b0254a0daff54f98eb36a358240febfa97", "author": "Chengjun Hou ", "committer": "Chengjun Hou ", "message": "Function booster2sql now allows print to console\n", "time": 1765576693 }, "_maintainer": { "name": "Chengjun Hou", "email": "chengjun.hou@gmail.com", "login": "chengjunhou", "description": "", "uuid": 11251354 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.1.0", "role": "Depends" }, { "package": "xgboost", "version": ">= 3.1.2.1", "role": "Imports" }, { "package": "data.table", "version": ">= 1.12.0", "role": "Imports" }, { "package": "ggplot2", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "chengjunhou", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-50", "n": 6 } ], "_tags": [], "_stars": 23, "_contributors": [ { "user": "chengjunhou", "count": 31, "uuid": 11251354 } ], "_userbio": { "uuid": 11251354, "type": "user", "name": "Chengjun Hou", "followers": 39 }, "_downloads": { "count": 286, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/xgb2sql" }, "_devurl": "https://github.com/chengjunhou/xgb2sql", "_searchresults": 12, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/xgb2sql.html", "LICENSE" ], "_homeurl": "https://github.com/chengjunhou/xgb2sql", "_realowner": "chengjunhou", "_cranurl": true, "_releases": [ { "version": "0.1.2", "date": "2019-03-13" }, { "version": "0.1.3", "date": "2025-12-12" } ], "_exports": [ "booster2sql", "onehot2sql" ], "_help": [ { "page": "booster2sql", "title": "Transform XGBoost model object to SQL query.", "topics": [ "booster2sql" ] }, { "page": "onehot2sql", "title": "Prepare training data in R so that it is ready for XGBoost model fitting. Meta information is stored so the exact transformation can be applied to any new data. It also outputs SQL query performing the exact one-hot encoding for in-database data preparation.", "topics": [ "onehot2sql" ] } ], "_readme": "https://github.com/chengjunhou/xgb2sql/raw/HEAD/README.md", "_rundeps": [ "data.table", "jsonlite", "lattice", "Matrix", "xgboost" ], "_vignettes": [ { "source": "xgb2sql.Rmd", "filename": "xgb2sql.html", "title": "Deploy XGBoost Model as SQL Query", "author": "Chengjun Hou, Abhishek Bishoyi", "engine": "knitr::rmarkdown", "headings": [ "Prepare Data in Both R and Database", "Transform XGBoost Model into SQL Query" ], "created": "2019-03-06 17:32:17", "modified": "2025-12-12 21:56:47", "commits": 4 } ], "_score": 5.139879086401237, "_indexed": true, "_nocasepkg": "xgb2sql", "_universes": [ "chengjunhou" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.3", "date": "2026-09-20T08:23:33.000Z", "distro": "resolute", "commit": "db2503b0254a0daff54f98eb36a358240febfa97", "fileid": "https://r2.ropensci.org/f7fc7a8cdab28fa903bc656a9aa02cf0b87ed7becb5da24946dec1062ccd8fcb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/chengjunhou/actions/runs/35499200298" }, { "r": "4.6.1", "os": "linux", "version": "0.1.3", "date": "2026-09-20T08:23:37.000Z", "distro": "resolute", "commit": "db2503b0254a0daff54f98eb36a358240febfa97", "fileid": "https://r2.ropensci.org/f62e71d4d72b390e98dc9217780979baaf0273e2419ef2935e1c64b6330f08f3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/chengjunhou/actions/runs/35499200298" }, { "r": "4.5.3", "os": "mac", "version": "0.1.3", "date": "2026-09-20T08:23:41.000Z", "commit": "db2503b0254a0daff54f98eb36a358240febfa97", "fileid": "https://r2.ropensci.org/cfaae4566646e350bd77ee763465d3c5ebd4c8b1d4dea0f4a696b17b4eb18b40", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/chengjunhou/actions/runs/35499200298" }, { "r": "4.6.1", "os": "mac", "version": "0.1.3", "date": "2026-09-20T08:23:35.000Z", "commit": "db2503b0254a0daff54f98eb36a358240febfa97", "fileid": "https://r2.ropensci.org/e9adfacf8f85c67ad9b85b5626789b6905873ecc3fe4639a15b1f149f6ec74c1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/chengjunhou/actions/runs/35499200298" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.3", "date": "2026-09-20T08:23:34.000Z", "commit": "db2503b0254a0daff54f98eb36a358240febfa97", "fileid": "https://r2.ropensci.org/218da05adf61e3ce2463cb5eb3b6bd6b78d5d33869c8a00ac041c9febe376312", "status": "success", "buildurl": "https://github.com/r-universe/chengjunhou/actions/runs/35499200298" }, { "r": "4.7.0", "os": "win", "version": "0.1.3", "date": "2026-09-20T08:22:37.000Z", "commit": "db2503b0254a0daff54f98eb36a358240febfa97", "fileid": "https://r2.ropensci.org/09b25f4475df55a5ba1f2019861384a60a17cd3edc6dcc972c2dd25cbaaa5aae", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/chengjunhou/actions/runs/35499200298" }, { "r": "4.5.3", "os": "win", "version": "0.1.3", "date": "2026-09-20T08:22:35.000Z", "commit": "db2503b0254a0daff54f98eb36a358240febfa97", "fileid": "https://r2.ropensci.org/93708f37decafb6c77b7bbfaecb9fa2c77f0819e705d68408bb38986638fcd44", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/chengjunhou/actions/runs/35499200298" }, { "r": "4.6.1", "os": "win", "version": "0.1.3", "date": "2026-09-20T08:22:43.000Z", "commit": "db2503b0254a0daff54f98eb36a358240febfa97", "fileid": "https://r2.ropensci.org/c4b44f59f5f5eaa8f97c29a6bdd888087b06b07b5c615bab18d7a4e356f2612c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/chengjunhou/actions/runs/35499200298" } ] }