{ "_id": "6ac8b56fde46216d5edd5f72", "Package": "dabr", "Title": "Database Management with R", "Version": "0.0.4", "Authors@R": "c(\nperson(given = \"Roberto\",\nfamily = \"Villegas-Diaz\",\nrole = c(\"aut\", \"cre\"),\nemail = \"r.villegas-diaz@outlook.com\",\ncomment = c(ORCID = \"0000-0001-5036-8661\")),\nperson(\"SPECIAL Research Group @ University of Reading\", role = c(\"cph\")))", "Description": "Provides functions to manage databases: select, update,\ninsert, and delete records, list tables, backup tables as CSV\nfiles, and import CSV files as tables.", "License": "GPL-3", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.2.1", "URL": "https://github.com/special-uor/dabr/,\nhttps://special-uor.github.io/dabr/,\nhttps://research.reading.ac.uk/palaeoclimate/", "BugReports": "https://github.com/special-uor/dabr/issues/", "Language": "en-GB", "Config/pak/sysreqs": "libmysqlclient-dev", "Repository": "https://special-uor.r-universe.dev", "Date/Publication": "2022-10-16 12:47:51 UTC", "RemoteUrl": "https://github.com/special-uor/dabr", "RemoteRef": "HEAD", "RemoteSha": "5c223451c8c2538fb010591668edd8146429151e", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-09 09:24:23 UTC", "User": "root" }, "Author": "Roberto Villegas-Diaz [aut, cre] (ORCID:\n),\nSPECIAL Research Group @ University of Reading [cph]", "Maintainer": "Roberto Villegas-Diaz ", "_user": "special-uor", "_type": "src", "_file": "dabr_0.0.4.tar.gz", "_fileid": "https://r2.ropensci.org/364e046aa58b08d5160d336b2fb98292a57917714a63ba4a6cdd16be21ffb7c4", "_filesize": 115506, "_sha256": "364e046aa58b08d5160d336b2fb98292a57917714a63ba4a6cdd16be21ffb7c4", "_expires": "2027-01-17T09:35:41.000Z", "_created": "2026-10-09T09:24:23.000Z", "_published": "2026-10-09T09:35:43.351Z", "_buildurl": "https://github.com/r-universe/special-uor/actions/runs/37910759068", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 113756141754, "time": 93, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11606892052" }, { "job": 113756141558, "time": 128, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11606418780" }, { "job": 113756141538, "time": 154, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11606971942" }, { "job": 113756141683, "time": 122, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11606753162" }, { "job": 113755158304, "time": 167, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11606321960" }, { "job": 113756141545, "time": 101, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11607145995" }, { "job": 113756141727, "time": 64, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11606398556" }, { "job": 113756141596, "time": 57, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11606526624" }, { "job": 113756141738, "time": 49, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11606372018" } ], "_upstream": "https://github.com/special-uor/dabr", "_commit": { "id": "5c223451c8c2538fb010591668edd8146429151e", "author": "Roberto Villegas-Diaz ", "committer": "Roberto Villegas-Diaz ", "message": "Ignore the new cran-comments.md file\n", "time": 1665924471 }, "_maintainer": { "name": "Roberto Villegas-Diaz", "email": "r.villegas-diaz@outlook.com", "login": "villegar", "orcid": "0000-0001-5036-8661", "twitter": "@r_villegas_diaz", "description": "Plant-powered 🌱 data enthusiast", "uuid": 5126692 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "knitr", "role": "Imports" }, { "package": "magrittr", "role": "Imports" }, { "package": "RMariaDB", "role": "Imports" }, { "package": "tibble", "role": "Imports" } ], "_owner": "special-uor", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 4, "_contributors": [ { "user": "villegar", "count": 110, "uuid": 5126692 } ], "_userbio": { "uuid": 71322599, "type": "organization", "name": "SPECIAL Research Group", "followers": 12, "description": "SPECIAL Research Group @ University of Reading" }, "_downloads": { "count": 335, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dabr" }, "_devurl": "https://github.com/special-uor/dabr", "_pkgdown": "https://special-uor.github.io/dabr/", "_searchresults": 0, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dabr.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md" ], "_homeurl": "https://github.com/special-uor/dabr", "_realowner": "special-uor", "_cranurl": true, "_releases": [ { "version": "0.0.1", "date": "2020-11-05" }, { "version": "0.0.2", "date": "2020-12-07" }, { "version": "0.0.3", "date": "2021-05-22" }, { "version": "0.0.4", "date": "2022-10-17" } ], "_exports": [ "%>%", "attributes", "close_conn", "delete", "get_attr", "insert", "is.connected", "list_tables", "open_conn_mysql", "quote", "select", "select_all", "update" ], "_help": [ { "page": "attributes", "title": "Combine attributes", "topics": [ "attributes" ] }, { "page": "close_conn", "title": "Close connection to database", "concept": [ "DB functions" ], "topics": [ "close_conn", "close_conn.default", "close_conn.MariaDBConnection" ] }, { "page": "delete", "title": "Execute 'DELETE' query", "concept": [ "DB functions" ], "topics": [ "delete", "delete.MariaDBConnection" ] }, { "page": "get_attr", "title": "Get attributes of a table", "topics": [ "get_attr", "get_attr.MariaDBConnection" ] }, { "page": "insert", "title": "Execute 'INSERT' query", "concept": [ "DB functions" ], "topics": [ "insert", "insert.MariaDBConnection" ] }, { "page": "is.connected", "title": "Verify connection", "topics": [ "is.connected", "is.connected.MariaDBConnection" ] }, { "page": "list_tables", "title": "List tables", "concept": [ "DB functions" ], "topics": [ "list_tables", "list_tables.MariaDBConnection" ] }, { "page": "open_conn_mysql", "title": "Connect to database", "concept": [ "DB functions" ], "topics": [ "open_conn_mysql" ] }, { "page": "quote", "title": "Add single quotes", "topics": [ "quote" ] }, { "page": "select", "title": "Execute 'SELECT' query", "concept": [ "DB functions" ], "topics": [ "select", "select.MariaDBConnection" ] }, { "page": "select_all", "title": "Select all the records", "concept": [ "DB functions" ], "topics": [ "select_all", "select_all.MariaDBConnection" ] }, { "page": "update", "title": "Execute 'UPDATE' query", "concept": [ "DB functions" ], "topics": [ "update", "update.MariaDBConnection" ] } ], "_readme": "https://github.com/special-uor/dabr/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cli", "cpp11", "DBI", "evaluate", "generics", "glue", "highr", "hms", "knitr", "lifecycle", "lubridate", "magrittr", "pillar", "pkgconfig", "rlang", "RMariaDB", "tibble", "timechange", "utf8", "vctrs", "xfun", "yaml" ], "_score": 3.3010299956639813, "_indexed": true, "_nocasepkg": "dabr", "_universes": [ "special-uor", "villegar" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.4", "date": "2026-10-09T09:26:51.000Z", "distro": "resolute", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "https://r2.ropensci.org/b3ebabb7f88419acd0873901bd083a90f599f9e6286e35cae6740d884c27cba3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/37910759068" }, { "r": "4.6.1", "os": "linux", "version": "0.0.4", "date": "2026-10-09T09:27:09.000Z", "distro": "resolute", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "https://r2.ropensci.org/26ca3e25d7385b51931cb1a74da69dc52e2842a561ce3a0fedd9fee8d773b065", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/37910759068" }, { "r": "4.5.3", "os": "mac", "version": "0.0.4", "date": "2026-10-09T09:32:58.000Z", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "https://r2.ropensci.org/82e12006f4cda3b474b7aad805254b03e19d9689f9d5f752e5f837532a5c8a5d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/37910759068" }, { "r": "4.6.1", "os": "mac", "version": "0.0.4", "date": "2026-10-09T09:34:43.000Z", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "https://r2.ropensci.org/14f065fc42ab5a1fd81629987cfa57d0c6937f65f7c6b8dbbdccd9ca60dd6a6a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/37910759068" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.4", "date": "2026-10-09T09:26:56.000Z", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "https://r2.ropensci.org/52588de3170ffd0cf449729cb36414ff08b24c2d9d0a016539bd5e4af7cbb016", "status": "success", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/37910759068" }, { "r": "4.7.0", "os": "win", "version": "0.0.4", "date": "2026-10-09T09:26:12.000Z", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "https://r2.ropensci.org/79f9adfd5574a1eec4bb596ddf28c7dcda52a5f5ffe41e03802cb1d0ac1934b8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/37910759068" }, { "r": "4.5.3", "os": "win", "version": "0.0.4", "date": "2026-10-09T09:25:42.000Z", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "https://r2.ropensci.org/1c8b2a4ee224b90d56bc16a166305fdfeb023312d1567a6d8d800af03948b4b3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/37910759068" }, { "r": "4.6.1", "os": "win", "version": "0.0.4", "date": "2026-10-09T09:26:03.000Z", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "https://r2.ropensci.org/ee72443c1aec05946f5d1423005cb8945b670ab7e215510b6ddc26bd544c09bd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/37910759068" } ] }