aact_connect: Establish a connection to AACT database

In howardbaek/aactr: Connection To The AACT Database

Description

This function allows you to access the PostgreSQL AACT database in the cloud using R without needing to install PostgreSQL on your local machine.

Usage

aact_connect(user, password)

Arguments

user	A character vector containing username of database account
password	A character vector containing password of database account

Details

To get started, please create a database account at this link:
https://aact.ctti-clinicaltrials.org/users/sign_up.

To securely save credentials, create a config yaml file: yaml::write_yaml(data.frame(user = "USERNAME", password = "PASSWORD"), "config"). Then, load the config file and save it to an object: config <- yaml::yaml.load_file("config"). Now, you can safely access your database credentials with config$user and config$password.

Alternatively, you can directly enter your username and password as arguments.

Author(s)

Howard Baek <[e-mail]>

See Also

• https://aact.ctti-clinicaltrials.org/r

• https://aact.ctti-clinicaltrials.org/points_to_consider

Examples

## Not run: 
con <- aact_connect(config$user, config$password)

## End(Not run)

howardbaek/aactr documentation built on Dec. 20, 2021, 4:48 p.m.