In mentoldo/rsqlauthandle: Authentication on SQL DB

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "man/figures/README-",
  out.width = "100%"
)

rsqlauthandle

The goal of rsqlauthandle is to handle in a simple and secure way your sql db servers authentications.

Installation

You can install the development version of rsqlauthandle like so:

devtools::install_github('mentoldo/rsqlauthandle')

Example

To use rsqlauthandle in a project:

library(rsqlauthandle)

set_credentials(alias = 'postgres_db',
                dialect = 'postgresql',
                host = 'localhost',
                port = '5432',
                user = 'user',
                db_name = 'customers')

It sets the credential for a DB conection. Then, we can use it with:

con <- connect_postgres(alias='rsqlauthandle')

con is a DBIConnection object that we can use to list tables, get a table or query it.

dbListTables(con)
dbReadTable(con, 'accounts')
dbReadTable(con, "SELECT * FROM accounts")

mentoldo/rsqlauthandle documentation built on Dec. 21, 2021, 4:57 p.m.