{ "_id": "6a103715acfb0bcc41c9a375", "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-05-12 06:32:22 UTC", "User": "root" }, "Author": "Roberto Villegas-Diaz [aut, cre] (ORCID:\n),\nSPECIAL Research Group @ University of Reading [cph]", "Maintainer": "Roberto Villegas-Diaz ", "MD5sum": "255cb14b72c1c0a52736a9e7ed6b7e68", "_user": "special-uor", "_type": "src", "_file": "dabr_0.0.4.tar.gz", "_fileid": "18cd82d19233fc74cdf751f06a2a94c24a45cb6c2b9030a26325f62a0b33468b", "_filesize": 116087, "_sha256": "18cd82d19233fc74cdf751f06a2a94c24a45cb6c2b9030a26325f62a0b33468b", "_created": "2026-05-12T06:32:22.000Z", "_published": "2026-05-22T10:59:33.163Z", "_distro": "noble", "_jobs": [ { "job": 77366274643, "time": 109, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "6937270457" }, { "job": 77366274939, "time": 100, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "6937267155" }, { "job": 77366275066, "time": 151, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "6937273780" }, { "job": 77366275109, "time": 117, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "6937266285" }, { "job": 77366274644, "time": 141, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6937242192" }, { "job": 77366274412, "time": 100, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7158880970" }, { "job": 77366274849, "time": 59, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "6937256658" }, { "job": 77366274965, "time": 91, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "6937264792" }, { "job": 77366275142, "time": 68, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "6937258839" } ], "_buildurl": "https://github.com/r-universe/special-uor/actions/runs/25717594595", "_status": "success", "_host": "GitHub-Actions", "_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", "uuid": 5126692 }, "_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", "description": "SPECIAL Research Group @ University of Reading" }, "_downloads": { "count": 251, "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.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dabr.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_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-05-12T06:34:21.000Z", "distro": "noble", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "1a00f526bc0f599a679eca04b34efae2e0151cce53e611bec245c9d81a8c2878", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/25717594595" }, { "r": "4.6.0", "os": "linux", "version": "0.0.4", "date": "2026-05-12T06:34:09.000Z", "distro": "noble", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "b84edf0860078617352a562d111bf7703a747ff4e0a085d32e5a68d0ad299249", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/25717594595" }, { "r": "4.5.3", "os": "mac", "version": "0.0.4", "date": "2026-05-12T06:34:39.000Z", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "fd618353c80aed20fc4eadde5a35972696464d49a0a71586cad0b7750a819dac", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/25717594595" }, { "r": "4.6.0", "os": "mac", "version": "0.0.4", "date": "2026-05-12T06:34:07.000Z", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "b1002451ac4e67c4ff06ce80ec24fc50b7e486b2fd749f42e4be355a110c5606", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/25717594595" }, { "r": "4.7.0", "os": "win", "version": "0.0.4", "date": "2026-05-12T06:33:22.000Z", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "97a5afdaa3b41875b2b64cba18d881b6f9a04f5d1dfb058f605df7152fedb6de", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/25717594595" }, { "r": "4.5.3", "os": "win", "version": "0.0.4", "date": "2026-05-12T06:33:54.000Z", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "df6cc999dfb08cdfeab6e22dd5fc6b01c008b17d2ba14241ca2f2d0a951e8c8f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/25717594595" }, { "r": "4.6.0", "os": "win", "version": "0.0.4", "date": "2026-05-12T06:33:23.000Z", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "e36f4682122cb2ddc77285852f48494af20a36f5bdf31a2007ec60794cef8fa4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/25717594595" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.4", "date": "2026-05-22T10:59:20.000Z", "commit": "5c223451c8c2538fb010591668edd8146429151e", "fileid": "9cd276520f4c8376fa0bb0b3dc12c89fe335acc10e9654d290edf1f734d36910", "status": "success", "buildurl": "https://github.com/r-universe/special-uor/actions/runs/25717594595" } ] }