We had a problem: how to efficiently manage public genomic dataset, which may get very large, and integrate them with private genomic information stored in a PostgreSQL database.
We leveraged a very powerful, but probably less known PostgreSQL technology called Foreign Data Wrappers, to build an efficient solution: we will describe what we did and how to replicate our solution and our setting.
Hospitals, research insitutions, universities and every company that wants to internally manage large genomic datasets as gnomAD, DBSNFP, CADD, Clinvar, etcetera, will find our presentation very interesting.
