{ "_id": "6a1b0e061d7bb097a0a08ec4", "Package": "certedb", "Title": "A Certe R Package for Connecting to Databases", "Version": "1.14.7", "Authors@R": "c(\nperson(given = c(\"Matthijs\", \"S.\"),\nfamily = \"Berends\",\nrole = c(\"aut\", \"cre\"),\nemail = \"m.berends@certe.nl\"),\nperson(given = c(\"Erwin\", \"E.\", \"A.\"),\nfamily = \"Hassing\",\nrole = c(\"aut\"),\nemail = \"e.hassing@certe.nl\"),\nperson(given = c(\"Erwin\"),\nfamily = \"Dijkstra\",\nrole = c(\"aut\"),\nemail = \"e.dijkstra@certe.nl\"),\nperson(given = \"Certe Medical Diagnostics & Advice Foundation\",\nrole = c(\"cph\", \"fnd\")))", "Description": "A Certe R Package for connecting to internal Certe cBases\nand local DuckDB databases. This package is part of the\n'certedata' universe.", "URL": "https://certe-medical-epidemiology.github.io/certedb,\nhttps://github.com/certe-medical-epidemiology/certedb", "License": "GPL-2", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "Config/testthat/edition": "2", "Config/pak/sysreqs": "libcairo2-dev cmake libfontconfig1-dev\nlibfreetype6-dev libfribidi-dev make libharfbuzz-dev libicu-dev\nlibjpeg-dev libpng-dev libtiff-dev libuv1-dev libwebp-dev\nlibxml2-dev unixodbc-dev libssl-dev libx11-dev xz-utils\nzlib1g-dev", "Repository": "https://certe-medical-epidemiology.r-universe.dev", "Date/Publication": "2026-05-19 12:11:49 UTC", "RemoteUrl": "https://github.com/certe-medical-epidemiology/certedb", "RemoteRef": "HEAD", "RemoteSha": "f58cdb6bf02c8a338b7f713c4b0fefd57a65bbdf", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-30 12:36:03 UTC", "User": "root" }, "Author": "Matthijs S. Berends [aut, cre],\nErwin E. A. Hassing [aut],\nErwin Dijkstra [aut],\nCerte Medical Diagnostics & Advice Foundation [cph, fnd]", "Maintainer": "Matthijs S. Berends ", "MD5sum": "f79b45658883f7b683d9cc1e65b4755f", "_user": "certe-medical-epidemiology", "_type": "src", "_file": "certedb_1.14.7.tar.gz", "_fileid": "045780bd8afec69bc68364cbd8ccf3940acbe89d6369e70d8bc30310bc8de997", "_filesize": 176849, "_sha256": "045780bd8afec69bc68364cbd8ccf3940acbe89d6369e70d8bc30310bc8de997", "_created": "2026-05-30T12:36:03.000Z", "_published": "2026-05-30T16:19:18.542Z", "_distro": "noble", "_jobs": [ { "job": 78648973341, "time": 260, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7308245318" }, { "job": 78648973372, "time": 256, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7308244938" }, { "job": 78648973336, "time": 158, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7309552859" }, { "job": 78648973339, "time": 236, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7309565408" }, { "job": 78648748705, "time": 244, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7308216920" }, { "job": 78648973323, "time": 152, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7308233661" }, { "job": 78648973334, "time": 255, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7308244842" }, { "job": 78648973362, "time": 219, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7308240778" }, { "job": 78648973333, "time": 206, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7308239496" } ], "_buildurl": "https://github.com/r-universe/certe-medical-epidemiology/actions/runs/26683885674", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/certe-medical-epidemiology/certedb", "_commit": { "id": "f58cdb6bf02c8a338b7f713c4b0fefd57a65bbdf", "author": "Matthijs Berends ", "committer": "Matthijs Berends ", "message": "fix errors\n", "time": 1779192709 }, "_maintainer": { "name": "Matthijs S. Berends", "email": "m.berends@certe.nl", "login": "msberends", "mastodon": "@msberends@mastodon.social", "linkedin": "https://LinkedIn.com/in/msberends", "description": "Medical epidemiologist/microbiologist, head of @umcg-mmbi-epidemiology and @certe-medical-epidemiology", "uuid": 31037261 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "certestyle", "role": "Imports" }, { "package": "certetoolbox", "role": "Imports" }, { "package": "AMR", "version": ">= 2.0.0", "role": "Imports" }, { "package": "cli", "version": ">= 3.4.0", "role": "Imports" }, { "package": "DBI", "version": ">= 1.0.0", "role": "Imports" }, { "package": "dbplyr", "version": ">= 2.1.0", "role": "Imports" }, { "package": "dplyr", "version": ">= 1.0.0", "role": "Imports" }, { "package": "DT", "version": ">= 0.3.0", "role": "Imports" }, { "package": "duckdb", "version": ">= 0.8.0", "role": "Imports" }, { "package": "knitr", "version": ">= 1.40", "role": "Imports" }, { "package": "odbc", "version": ">= 1.3.0", "role": "Imports" }, { "package": "pillar", "version": ">= 1.8.0", "role": "Imports" }, { "package": "shiny", "version": ">= 1.9.0", "role": "Imports" }, { "package": "rlang", "version": ">= 1.1.0", "role": "Imports" }, { "package": "tidyr", "version": ">= 1.1.0", "role": "Imports" }, { "package": "yaml", "version": ">= 2.2.1", "role": "Imports" }, { "package": "callr", "role": "Suggests" }, { "package": "clipr", "version": ">= 0.8.0", "role": "Suggests" }, { "package": "connections", "role": "Suggests" }, { "package": "RMariaDB", "role": "Suggests" }, { "package": "rstudioapi", "role": "Suggests" }, { "package": "sf", "role": "Suggests" }, { "package": "stringr", "role": "Suggests" }, { "package": "testthat", "version": ">= 2.0.0", "role": "Suggests" }, { "package": "utils", "role": "Suggests" } ], "_owner": "certe-medical-epidemiology", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-22", "n": 1 }, { "week": "2025-24", "n": 1 }, { "week": "2025-26", "n": 4 }, { "week": "2025-31", "n": 2 }, { "week": "2025-32", "n": 2 }, { "week": "2026-06", "n": 1 }, { "week": "2026-08", "n": 3 }, { "week": "2026-14", "n": 1 }, { "week": "2026-21", "n": 2 } ], "_tags": [], "_stars": 0, "_contributors": [ { "user": "msberends", "count": 121, "uuid": 31037261 }, { "user": "erwinhassing", "count": 4, "uuid": 32546915 } ], "_userbio": { "uuid": 92214397, "type": "organization", "name": "Certe Medical Epidemiology", "description": "Repo collection of the non-profit organisation Certe, Department of Medical Epidemiology. Here to support open science." }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/certedb" }, "_devurl": "https://github.com/certe-medical-epidemiology/certedb", "_pkgdown": "https://certe-medical-epidemiology.github.io/certedb", "_searchresults": 1, "_quarto": true, "_topics": [ "quarto" ], "_rbuild": "4.6.0", "_assets": [ "extra/certedb.html", "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_cranurl": false, "_exports": [ "cbase_explorer", "certedb_getmmb", "certedb_getmmb_tat", "certedb_query", "db", "db_close", "db_connect", "db_drop_table", "db_has_table", "db_list_tables", "db_write_table", "di", "get_diver_data", "get_duckdb_data", "get_glims10_data", "get_preset", "gl", "mysql_init", "presets" ], "_help": [ { "page": "cbase_explorer", "title": "Search cBase Interactively", "topics": [ "cbase_explorer" ] }, { "page": "db_connect", "title": "Connect to a Certe Database", "topics": [ "db_close", "db_connect" ] }, { "page": "get_diver_data", "title": "Download Data from a Local or Remote Database", "topics": [ "certedb_getmmb", "certedb_getmmb_tat", "certedb_query", "get_diver_data", "get_duckdb_data", "get_glims10_data" ] }, { "page": "mysql_init", "title": "Initialise MySQL Connection for Connections Pane", "topics": [ "mysql_init" ] }, { "page": "presets", "title": "Available Presets for 'get_diver_data()'", "topics": [ "get_preset", "presets" ] } ], "_pkglogo": "https://github.com/certe-medical-epidemiology/certedb/raw/HEAD/logo.svg", "_readme": "https://github.com/certe-medical-epidemiology/certedb/raw/HEAD/README.md", "_rundeps": [ "AMR", "askpass", "AzureAuth", "AzureGraph", "backports", "base64enc", "bit", "bit64", "blob", "bslib", "cachem", "callr", "certeprojects", "certestyle", "certetoolbox", "cleaner", "cli", "clipr", "commonmark", "cpp11", "crayon", "crosstalk", "curl", "data.table", "DBI", "dbplyr", "digest", "dplyr", "DT", "duckdb", "evaluate", "fastmap", "flextable", "fontawesome", "fontBitstreamVera", "fontLiberation", "fontquiver", "fs", "gdtools", "generics", "glue", "highr", "hms", "htmltools", "htmlwidgets", "httpuv", "httr", "jose", "jquerylib", "jsonlite", "knitr", "later", "lazyeval", "lifecycle", "lubridate", "magrittr", "memoise", "Microsoft365R", "mime", "miniUI", "odbc", "officer", "openssl", "openxlsx2", "otel", "pillar", "pins", "pkgconfig", "prettyunits", "processx", "progress", "promises", "ps", "purrr", "quarto", "R6", "ragg", "rappdirs", "Rcpp", "readr", "rlang", "rmarkdown", "rstudioapi", "rvest", "sass", "selectr", "shiny", "shinyjs", "shinyWidgets", "sourcetools", "stringi", "stringr", "sys", "systemfonts", "textshaping", "tibble", "tidyr", "tidyselect", "timechange", "tinytex", "tzdb", "utf8", "uuid", "vctrs", "viridisLite", "vroom", "whisker", "withr", "xfun", "xml2", "xtable", "yaml", "zip" ], "_score": 2.6532125137753435, "_indexed": true, "_nocasepkg": "certedb", "_universes": [ "certe-medical-epidemiology", "msberends" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.14.7", "date": "2026-05-30T12:39:16.000Z", "distro": "noble", "commit": "f58cdb6bf02c8a338b7f713c4b0fefd57a65bbdf", "fileid": "f21d4473a4cf689e63091330e3481fcfedfca8e5ca93b327ce859808a3b24ddb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/certe-medical-epidemiology/actions/runs/26683885674" }, { "r": "4.6.0", "os": "linux", "version": "1.14.7", "date": "2026-05-30T12:39:10.000Z", "distro": "noble", "commit": "f58cdb6bf02c8a338b7f713c4b0fefd57a65bbdf", "fileid": "fda636bdae5d3bf33caa6b64b771e3d1853f9835ccc66c14b32ca45dae87040a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/certe-medical-epidemiology/actions/runs/26683885674" }, { "r": "4.5.3", "os": "mac", "version": "1.14.7", "date": "2026-05-30T16:15:56.000Z", "commit": "f58cdb6bf02c8a338b7f713c4b0fefd57a65bbdf", "fileid": "fa607e7e946b93d1aea8e93c805fe194104181e55c7b72d98c4c2d34fcbd5199", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/certe-medical-epidemiology/actions/runs/26683885674" }, { "r": "4.6.0", "os": "mac", "version": "1.14.7", "date": "2026-05-30T16:17:22.000Z", "commit": "f58cdb6bf02c8a338b7f713c4b0fefd57a65bbdf", "fileid": "7f9ac4c0fe8bccde64f35a9bd0c4c47e2d8170f6c95e9e7ee88bac79986bcafc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/certe-medical-epidemiology/actions/runs/26683885674" }, { "r": "4.6.0", "os": "wasm", "version": "1.14.7", "date": "2026-05-30T12:39:12.000Z", "commit": "f58cdb6bf02c8a338b7f713c4b0fefd57a65bbdf", "fileid": "956edfc69b895d5d3daac49d9242001cf9b4ea9608e36e6aee64693a3f087e63", "status": "success", "buildurl": "https://github.com/r-universe/certe-medical-epidemiology/actions/runs/26683885674" }, { "r": "4.7.0", "os": "win", "version": "1.14.7", "date": "2026-05-30T12:38:57.000Z", "commit": "f58cdb6bf02c8a338b7f713c4b0fefd57a65bbdf", "fileid": "790013be9ca049bd0edf4df76aba70a44c2393b291624f858d0b16529852583b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/certe-medical-epidemiology/actions/runs/26683885674" }, { "r": "4.5.3", "os": "win", "version": "1.14.7", "date": "2026-05-30T12:38:15.000Z", "commit": "f58cdb6bf02c8a338b7f713c4b0fefd57a65bbdf", "fileid": "185020d9fff3a905c242239d784e61bbbb2ae789c0e4607386ccabecdbc3b690", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/certe-medical-epidemiology/actions/runs/26683885674" }, { "r": "4.6.0", "os": "win", "version": "1.14.7", "date": "2026-05-30T12:38:07.000Z", "commit": "f58cdb6bf02c8a338b7f713c4b0fefd57a65bbdf", "fileid": "cfc83741f30541038219bbcc962ef2ed8c6a3ef7b6c66a91498a187f1f7be0e8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/certe-medical-epidemiology/actions/runs/26683885674" } ] }