{ "_id": "6a10136bacfb0bcc41c83673", "Package": "rpgconn", "Type": "Package", "Title": "User-Friendly PostgreSQL Connection Management", "Version": "0.4.1.9000", "Authors@R": "person(given = \"Bobby\",\nfamily = \"Fatemi\",\nrole = c(\"aut\", \"cre\"),\nemail = \"bfatemi07@gmail.com\")", "Maintainer": "Bobby Fatemi ", "Description": "Provides a user-friendly interface for managing PostgreSQL\ndatabase connection settings. Supports standard PostgreSQL URI\nconnection strings (postgresql://user:pass@host:port/db) with\nquery parameters, IPv6 hosts, and URL-encoded credentials. The\npackage supplies helper functions to create, edit and load\nconnection and option configuration files stored in a\nuser-specific directory using the 'RPostgres' back end. These\nhelpers make it easy to construct a reproducible connection\nstring from a configuration file, either by reading\nuser-defined YAML files or by parsing an environment variable.\nValidation-first architecture provides clear, actionable error\nmessages instead of cryptic connection failures.", "Encoding": "UTF-8", "License": "MIT + file LICENSE", "Language": "en-US", "RoxygenNote": "7.3.3", "URL": "https://github.com/r-data-science/rpgconn,\nhttps://r-data-science.github.io/rpgconn/", "BugReports": "https://github.com/r-data-science/rpgconn/issues", "Config/testthat/edition": "3", "VignetteBuilder": "quarto", "Config/pak/sysreqs": "cmake git make libgit2-dev libicu-dev libuv1-dev\nlibssl-dev libpq-dev libx11-dev", "Repository": "https://r-data-science.r-universe.dev", "Date/Publication": "2026-02-21 08:19:24 UTC", "RemoteUrl": "https://github.com/r-data-science/rpgconn", "RemoteRef": "HEAD", "RemoteSha": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-22 08:24:03 UTC", "User": "root" }, "Author": "Bobby Fatemi [aut, cre]", "MD5sum": "d440a3dac23b27099cfc6f56b463fcf0", "_user": "r-data-science", "_type": "src", "_file": "rpgconn_0.4.1.9000.tar.gz", "_fileid": "be33ad3ae6bcffb4e515e092a606c916cc463427a3cd19c92f674a245f5f074f", "_filesize": 235191, "_sha256": "be33ad3ae6bcffb4e515e092a606c916cc463427a3cd19c92f674a245f5f074f", "_created": "2026-05-22T08:24:03.000Z", "_published": "2026-05-22T08:27:23.366Z", "_distro": "noble", "_jobs": [ { "job": 77343428677, "time": 152, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7156124777" }, { "job": 77343428654, "time": 147, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7156123574" }, { "job": 77343428704, "time": 164, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "7156128431" }, { "job": 77343428703, "time": 164, "config": "macos-release-arm64", "r": "4.6.0", "check": "ERROR", "artifact": "7156127745" }, { "job": 77342891072, "time": 221, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7156076745" }, { "job": 77343428629, "time": 124, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7156116191" }, { "job": 77343428739, "time": 119, "config": "windows-devel", "r": "4.7.0", "check": "ERROR", "artifact": "7156114570" }, { "job": 77343428685, "time": 125, "config": "windows-oldrel", "r": "4.5.3", "check": "ERROR", "artifact": "7156116159" }, { "job": 77343428714, "time": 119, "config": "windows-release", "r": "4.6.0", "check": "ERROR", "artifact": "7156115341" } ], "_buildurl": "https://github.com/r-universe/r-data-science/actions/runs/26276776300", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/r-data-science/rpgconn", "_commit": { "id": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "author": "Bobby Fatemi ", "committer": "Bobby Fatemi ", "message": "Start 0.4.1.9000 development cycle\n", "time": 1771661964 }, "_maintainer": { "name": "Bobby Fatemi", "email": "bfatemi07@gmail.com" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "DBI", "role": "Imports" }, { "package": "fs", "role": "Imports" }, { "package": "RPostgres", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "usethis", "role": "Imports" }, { "package": "yaml", "role": "Imports" }, { "package": "covr", "role": "Suggests" }, { "package": "data.table", "role": "Suggests" }, { "package": "devtools", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "pak", "role": "Suggests" }, { "package": "pkgdown", "role": "Suggests" }, { "package": "pool", "role": "Suggests" }, { "package": "quarto", "role": "Suggests" }, { "package": "rcmdcheck", "role": "Suggests" }, { "package": "roxygen2", "role": "Suggests" }, { "package": "rstudioapi", "role": "Suggests" }, { "package": "shiny", "role": "Suggests" }, { "package": "spelling", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "urlchecker", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "r-data-science", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-23", "n": 1 }, { "week": "2025-25", "n": 1 }, { "week": "2025-32", "n": 5 }, { "week": "2025-34", "n": 1 }, { "week": "2025-40", "n": 1 }, { "week": "2025-42", "n": 3 }, { "week": "2025-52", "n": 6 }, { "week": "2026-08", "n": 3 } ], "_tags": [ { "name": "v0.3.2", "date": "2025-10-16" }, { "name": "v0.4.1-cran-submitted", "date": "2026-02-21" } ], "_stars": 2, "_contributors": [ { "user": "bfatemi", "count": 46, "uuid": 15960931 }, { "user": "copilot", "count": 3, "uuid": 198982749 } ], "_userbio": { "uuid": 150476966, "type": "organization", "name": "Data Science with R", "description": "Organization containing R packages, Shiny apps, and other tools used to facilitate my data science and analytics projects." }, "_downloads": { "count": 153, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/rpgconn" }, "_devurl": "https://github.com/r-data-science/rpgconn", "_searchresults": 6, "_quarto": true, "_topics": [ "quarto" ], "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/rpgconn.html", "manual.pdf" ], "_homeurl": "https://github.com/r-data-science/rpgconn", "_realowner": "r-data-science", "_cranurl": true, "_releases": [ { "version": "0.3.1", "date": "2025-08-21" }, { "version": "0.3.2", "date": "2025-10-16" } ], "_exports": [ "dbc", "dbd", "dir_rpg", "edit_config", "edit_options", "init_yamls", "use_config" ], "_help": [ { "page": "pgdbconn", "title": "PostgreSQL Database Connection Management", "concept": [ "config-management", "configuration", "database-config", "database-connection", "postgresql" ], "topics": [ "dbc", "dbd", "dir_rpg", "edit_config", "edit_options", "init_yamls", "pgdbconn" ] }, { "page": "use_config", "title": "Adopt External Configuration File", "concept": [ "config-management", "configuration" ], "topics": [ "use_config" ] } ], "_pkglogo": "https://github.com/r-data-science/rpgconn/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/r-data-science/rpgconn/raw/HEAD/README.md", "_rundeps": [ "askpass", "bit", "bit64", "blob", "cli", "clipr", "cpp11", "crayon", "credentials", "curl", "DBI", "desc", "fs", "generics", "gert", "gh", "gitcreds", "glue", "hms", "httr2", "ini", "jsonlite", "lifecycle", "lubridate", "magrittr", "openssl", "pkgconfig", "purrr", "R6", "rappdirs", "rlang", "RPostgres", "rprojroot", "rstudioapi", "stringi", "stringr", "sys", "timechange", "usethis", "vctrs", "whisker", "withr", "yaml", "zip" ], "_vignettes": [ { "source": "advanced-workflow.qmd", "filename": "advanced-workflow.html", "title": "Advanced Workflow", "engine": "quarto::html", "headings": [], "created": "2025-12-26 21:29:44", "modified": "2025-12-26 21:29:44", "commits": 1 }, { "source": "rpgconn.qmd", "filename": "rpgconn.html", "title": "Get started with rpgconn", "engine": "quarto::html", "headings": [], "created": "2025-12-26 21:29:44", "modified": "2026-02-21 07:56:28", "commits": 2 }, { "source": "maintainer-guide.qmd", "filename": "maintainer-guide.html", "title": "Maintainer Guide", "engine": "quarto::html", "headings": [], "created": "2026-02-21 07:56:28", "modified": "2026-02-21 07:56:28", "commits": 1 }, { "source": "quickstart.qmd", "filename": "quickstart.html", "title": "Quickstart", "engine": "quarto::html", "headings": [], "created": "2025-12-26 21:29:44", "modified": "2025-12-26 21:29:44", "commits": 1 }, { "source": "release-playbook.qmd", "filename": "release-playbook.html", "title": "Release Playbook", "engine": "quarto::html", "headings": [], "created": "2026-02-21 07:56:28", "modified": "2026-02-21 07:56:28", "commits": 1 } ], "_score": 5.6020599913279625, "_indexed": true, "_nocasepkg": "rpgconn", "_universes": [ "r-data-science" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.1.9000", "date": "2026-05-22T08:26:26.000Z", "distro": "noble", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "6184797c57be417d0b85a9e5c3492e0583ddd9e4fb3df7f40e9a3b7561de0f62", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/26276776300" }, { "r": "4.6.0", "os": "linux", "version": "0.4.1.9000", "date": "2026-05-22T08:26:25.000Z", "distro": "noble", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "b40f2e0b4ef340aa9386279b5bb998c99af246b713382dfe8246aac4cad6cc17", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/26276776300" }, { "r": "4.5.3", "os": "mac", "version": "0.4.1.9000", "date": "2026-05-22T08:26:49.000Z", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "8d26aafdbc4a6c167b63979134494d479894b10f9bf974f694069c1cec6fc953", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/26276776300" }, { "r": "4.6.0", "os": "mac", "version": "0.4.1.9000", "date": "2026-05-22T08:26:32.000Z", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "370e6049d9afc3f283059f6babd0af1147cfa253f18f26546088fc5bad7e5109", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/26276776300" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.1.9000", "date": "2026-05-22T08:26:22.000Z", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "6b02d27685ede6d331b189fe75e792e02504508f3aab702dd148fb833beff99e", "status": "success", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/26276776300" }, { "r": "4.7.0", "os": "win", "version": "0.4.1.9000", "date": "2026-05-22T08:25:49.000Z", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "49f198fe1853d6a9a0018d672f72127a157a9589a5694526b8d85593bb1d8956", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/26276776300" }, { "r": "4.5.3", "os": "win", "version": "0.4.1.9000", "date": "2026-05-22T08:25:56.000Z", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "deeda826f86431a82e0a0839c899ad1abb199c5d3ae767061902281d58d385c1", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/26276776300" }, { "r": "4.6.0", "os": "win", "version": "0.4.1.9000", "date": "2026-05-22T08:25:50.000Z", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "19ee80a0b79fcd7519e3ef372a4ff36d9489baa2cd01abf3bf7df3790ccd83f2", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/26276776300" } ] }