search

PediatricOpenTargets / OpenPedCan-api

2 stars 7 forks source link

Refactor API HTTP server to use PostgreSQL database as data backend #21

Closed logstar closed 3 years ago

logstar commented 3 years ago

Refactor API HTTP server code to build a PostgreSQL database and load data from the database to handle HTTP requests.

The PostgreSQL database will be available through Amazon Relational Database Service (RDS). Code and documentations will be in another GitHub repository.

Use R odbc package https://db.rstudio.com/r-packages/odbc/ to build the PostgreSQL database.

Refactor R functions in src directory to use R odbc package to load data from the PostgreSQL database.

cc @taylordm @chinwallaa @blackdenc