'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-db.ctti-clinicaltrials.org", port=5432, user=(sign up/in to get a username), password="your AACT password") > aact_sample <- dbGetQuery(con, "select distinct study_type from studies") > write.csv(aact_sample, file='aact_sample.csv') > print(aact_sample)
You will need the following information to access the database directly in the cloud.
Hostname: aact-db.ctti-clinicaltrials.org Port: 5432 Database name: aact User name: (sign up/in to get a username) Password: 'your AACT password'