Data

Tools

Indexes

Applications

Experiments

Open Source Science

rpgconn

Simple Postgres connection function

https://github.com/r-data-science/rpgconn

Science Score: 26.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ○
    CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ○
    Academic email domains
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (10.4%) to scientific vocabulary
Last synced: 10 months ago · JSON representation

Repository

Simple Postgres connection function

Basic Info
  • Host: GitHub
  • Owner: r-data-science
  • License: other
  • Language: R
  • Default Branch: main
  • Size: 104 KB
Statistics
  • Stars: 1
  • Watchers: 1
  • Forks: 0
  • Open Issues: 0
  • Releases: 0
Created over 2 years ago · Last pushed 10 months ago
Metadata Files
Readme License

README.md

rpgconn

Codecov R-CMD-check test-coverage CRAN status <!-- badges: end -->

The goal of rpgconn is to provide a simple interface for connecting to a PostgreSQL database.

Setting RPGCONNSTRING

The environment variable RPG_CONN_STRING must be set and have the format shown below.

r cs <- "user=postgres;password=some_password;host=some_host;port=5432;dbname=postgres" Sys.setenv(RPG_CONN_STRING = cs)

Installation

```r install.packages("rpgconn")

OR

remotes::install_github("r-data-science/rpgconn") ```

Example

```r library(rpgconn) library(DBI)

open connection

cn <- dbc("some_database")

List tables

dbListTables(cn)

Close connection

dbd(cn) ```

Owner

  • Name: r-data-science
  • Login: r-data-science
  • Kind: organization

GitHub Events

Total
  • Watch event: 1
  • Push event: 6
  • Pull request event: 2
Last Year
  • Watch event: 1
  • Push event: 6
  • Pull request event: 2

Packages

  • Total packages: 1
  • Total downloads: unknown
  • Total dependent packages: 0
  • Total dependent repositories: 0
  • Total versions: 1
  • Total maintainers: 1
cran.r-project.org: rpgconn

User-Friendly PostgreSQL Connection Management

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
  • Downloads: 0 Last month
Rankings
Dependent packages count: 25.7%
Dependent repos count: 31.6%
Average: 47.5%
Downloads: 85.4%
Maintainers (1)
bfatemi07@gmail.com
Last synced: 10 months ago

Dependencies

.github/workflows/R-CMD-check.yaml actions
  • actions/checkout v3 composite
  • r-lib/actions/check-r-package v2 composite
  • r-lib/actions/setup-pandoc v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
.github/workflows/test-coverage.yaml actions
  • actions/checkout v3 composite
  • actions/upload-artifact v3 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
DESCRIPTION cran
  • DBI * imports
  • RPostgres * imports
  • fs * imports
  • stringr * imports
  • usethis * imports
  • yaml * imports
  • rstudioapi * suggests
  • testthat >= 3.0.0 suggests