On Sep 4, 2012, at 4:36 PM, A.M. wrote: Or you could return the heatmap/plot as BYTEA data or use arrays as necessary. I was actually thinking exactly the same thing. Part of the reason I use PostgreSQL for all my bioinformatics work is that there is a need to correctly associate analysis results with the data and experimental methods they come from. I have tables for experimental runs, technicians, procedures, samples, drugs, etc. and I use foreign key constraints to connect them all. The idea is to have all the information readily accessible to reproduce complex results in modern scientific fashion. If I store the plots in the DB, I can connect them to all these basic information tables. -Aram |
