'R' is a free, reliable and popular software environment for statistical computing and graphics. It compiles and runs on a wide variety of UNIX platforms, Windows and MacOS. R provides one of the easiest and cheapest ways to access and analyze the wealth of information in the AACT database.
You can access the PostgreSQL AACT database in the cloud using 'R' without needing to install PostgreSQL on your local machine.
If R (and RStudio) not already installed on your local machine, you may install from the following links:
Once R is installed, launch R (or RStudio) and enter the following commands at the prompts.
> install.packages("RPostgreSQL") trying URL 'https://cran.rstudio.com/bin/macosx/mavericks/contrib/3.3/RPostgreSQL_0.4-1.tgz' Content type 'application/x-gzip' length 306320 bytes (299 KB) ================================================== downloaded 299 KB > library(RPostgreSQL) Loading required package: DBI > drv <- dbDriver('PostgreSQL') > con <- dbConnect(drv, dbname="aact",host="aact-prod.cr4nrslb1lw7.us-east-1.rds.amazonaws.com", port=5432, user="aact", password="aact") > aact_sample <- dbGetQuery(con, "select distinct study_type from studies") > write.csv(aact_sample, file='aact_sample.csv') > print(aact_sample)