{ "_id": "6ad5cd054a34890ab4938c06", "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-10-19 07:45:42 UTC", "User": "root" }, "Author": "Bobby Fatemi [aut, cre]", "_user": "r-data-science", "_type": "src", "_file": "rpgconn_0.4.1.9000.tar.gz", "_fileid": "https://r2.ropensci.org/e55182d748f9e8ba5ed917a2b44d4fbb780bfc1b3e04f15a9bc7434cb16b9ec5", "_filesize": 236043, "_sha256": "e55182d748f9e8ba5ed917a2b44d4fbb780bfc1b3e04f15a9bc7434cb16b9ec5", "_expires": "2027-01-27T07:55:48.000Z", "_created": "2026-10-19T07:45:42.000Z", "_published": "2026-10-19T07:55:49.848Z", "_buildurl": "https://github.com/r-universe/r-data-science/actions/runs/39217693813", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 117946655018, "time": 181, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12170158730" }, { "job": 117946654934, "time": 136, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12170995714" }, { "job": 117946654885, "time": 196, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "12170767203" }, { "job": 117946654987, "time": 152, "config": "macos-release-arm64", "r": "4.6.1", "check": "ERROR", "artifact": "12170374793" }, { "job": 117945458681, "time": 199, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12169979704" }, { "job": 117946654879, "time": 107, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12170965627" }, { "job": 117946654985, "time": 150, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "12170293192" }, { "job": 117946654981, "time": 146, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "ERROR", "artifact": "12169954612" }, { "job": 117946655101, "time": 159, "config": "windows-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "12169893684" } ], "_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", "login": "artagent0", "description": "\n", "uuid": 167954983 }, "_distro": "resolute", "_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-42", "n": 3 }, { "week": "2025-52", "n": 6 }, { "week": "2026-08", "n": 3 } ], "_tags": [ { "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 }, { "user": "artagent0", "count": 2, "uuid": 167954983 } ], "_userbio": { "uuid": 150476966, "type": "organization", "name": "Data Science with R", "followers": 3, "description": "Organization containing R packages, Shiny apps, and other tools used to facilitate my data science and analytics projects." }, "_downloads": { "count": 204, "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.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/rpgconn.html", "LICENSE" ], "_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", "gitcreds", "glue", "hms", "httr2", "ini", "jsonlite", "lifecycle", "lubridate", "magrittr", "openssl", "pak", "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": [ "Connection String Formats Reference", "URI Format (Recommended)", "Minimal", "With Authentication", "With Query Parameters", "Keyword/Value Format", "Semicolon-Delimited (Legacy)", "Whitespace-Delimited (libpq Standard)", "With Quoted Values", "SSL/TLS Configuration", "sslmode Parameter", "Examples", "IPv6 Hosts", "URL-Encoded Credentials", "When URL Encoding is Required", "URL Encoding in R", "Custom Configuration Paths", "Per-Project Configs", "Environment-Based Config Selection", "Separating Secrets from Config", "Environment-Specific Configurations", "Pattern 1: Single Config, Multiple Entries", "Pattern 2: Multiple Config Files", "Pattern 3: Environment Variable Override", "Multiple Databases", "Sequential Connections", "Concurrent Connections (Advanced)", "Troubleshooting", "Error: \"RPG_CONN_STRING not set\"", "Error: \"Connection string must include a '/{database}' segment\"", "Error: \"Connection string must not contain whitespace\"", "Error: \"Port in connection string is not a valid integer\"", "Connection Timeout", "SSL/TLS Issues", "Performance Tips", "Connection Reuse", "Connection Pooling", "Security Best Practices", "Never Commit Secrets", "Separate Dev and Prod Configs", "Use Read-Only Credentials for Analytics", "Environment Variable Precedence", "Advanced Query Parameters", "Runtime Configuration", "Application Name", "Statement Timeout", "Testing Strategies", "Pattern 1: Test-Specific Environment", "Pattern 2: Shared Test Fixtures", "Pattern 3: Mock Connections", "CI/CD Integration", "GitHub Actions", "Docker Compose", "Package Development Using rpgconn", "In Your Package", "In Package Tests", "Learn More" ], "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": [ "The Problem", "The rpgconn Solution", "1. Fail-Fast Validation", "2. Portable Format", "3. Secure by Default", "Design Philosophy", "Single Responsibility", "Zero Dependencies Beyond Essentials", "Progressive Enhancement", "Architecture", "Connection String Parsing", "Validation-First Approach", "URL Encoding Support", "Comparison: rpgconn vs DBI::dbConnect()", "Without rpgconn", "With rpgconn", "When NOT to Use rpgconn", "Next Steps", "Learn More" ], "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": [ "Audience", "Repository Structure", "Development Setup", "Daily Development Workflow", "Design Principles", "Testing Principles", "Optional Local Postgres E2E", "Conventions" ], "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": [ "Installation", "Choose Your Setup Path", "Cloud Database Setup", "Step 1: Get Your Connection String", "Step 2: Set Environment Variable", "Step 3: Connect", "Local Database Setup", "Prerequisites", "Step 1: Create Database and User", "Step 2: Build Connection String", "Step 3: Connect and Test", "YAML Configuration Setup", "Step 1: Initialize Config Files", "Step 2: Edit Configuration", "Step 3: Connect Using Named Config", "Step 4: Optional - Customize Connection Options", "Common Workflows", "Workflow 1: Quick Query", "Workflow 2: Long-Running Script", "Workflow 3: Shiny App", "Workflow 4: Testing with Fixtures", "Debugging Connection Issues", "Check Connection String is Set", "Preview Connection Arguments Without Connecting", "Test Raw DBI Connection", "Next Steps", "Need Help?" ], "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": [ "Pre-release Checklist", "Optional Integration Confidence", "Release Metadata", "Website and Docs", "CRAN + GitHub Release" ], "created": "2026-02-21 07:56:28", "modified": "2026-02-21 07:56:28", "commits": 1 } ], "_score": 5.477121254719663, "_indexed": true, "_nocasepkg": "rpgconn", "_universes": [ "r-data-science", "artagent0" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.1.9000", "date": "2026-10-19T07:48:33.000Z", "distro": "resolute", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "https://r2.ropensci.org/e89d325f56ba86ad626c233aedc6601fc0d9b07212bdca828e9fd6b0406d4cfa", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/39217693813" }, { "r": "4.6.1", "os": "linux", "version": "0.4.1.9000", "date": "2026-10-19T07:47:51.000Z", "distro": "resolute", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "https://r2.ropensci.org/a42485d451c4e900ed5b191692ab47d9dfbbf48bae262501e9dadbdd6e8c6b80", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/39217693813" }, { "r": "4.5.3", "os": "mac", "version": "0.4.1.9000", "date": "2026-10-19T07:55:06.000Z", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "https://r2.ropensci.org/68600f28c41b105d0a221af2424db85a035df41931f65f45a801a25d5e58a2d7", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/39217693813" }, { "r": "4.6.1", "os": "mac", "version": "0.4.1.9000", "date": "2026-10-19T07:54:24.000Z", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "https://r2.ropensci.org/0c46eb0ecc8a4190834b2aa4b33a7c20bd7684406b5750028e91bf9a8e95ee3a", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/39217693813" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.1.9000", "date": "2026-10-19T07:47:44.000Z", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "https://r2.ropensci.org/fdc182c45cea37dde924417b1f0b4542f64065bf73e8f93a0516989dd2538975", "status": "success", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/39217693813" }, { "r": "4.7.0", "os": "win", "version": "0.4.1.9000", "date": "2026-10-19T07:47:57.000Z", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "https://r2.ropensci.org/508daa5b25803a7287b70430e9b7c34e22bd22d827ac6dbd88bc789a81eb0fa4", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/39217693813" }, { "r": "4.5.3", "os": "win", "version": "0.4.1.9000", "date": "2026-10-19T07:47:52.000Z", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "https://r2.ropensci.org/288643778982e88446f2bd86432a63bbd75a2f6db62ef55ebb6de818e7d1845f", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/39217693813" }, { "r": "4.6.1", "os": "win", "version": "0.4.1.9000", "date": "2026-10-19T07:48:06.000Z", "commit": "0231c3562b2756c930ae9c5ae929a43fe7d981e8", "fileid": "https://r2.ropensci.org/2caeea07adfc660ff7990638445fbadb34476e80dfe62af0f771ff757ccd735f", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/r-data-science/actions/runs/39217693813" } ] }