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

Audience | Repository Structure | Development Setup | Daily Development Workflow | Design Principles | Testing Principles | Optional Local Postgres E2E | Conventions

Pre-release Checklist | Optional Integration Confidence | Release Metadata | Website and Docs | CRAN + GitHub Release

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

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?