| From: | Aram Fingal <fingal(at)multifactorial(dot)com> |
|---|---|
| To: | Postgres-General General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: crosstab |
| Date: | 2012-09-04 21:59:16 |
| Message-ID: | EDDB3318-F02B-4508-A01B-E1E9BC168721@multifactorial.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Claire Chang | 2012-09-04 23:11:20 | MS Sync framework sync SQL Server 2012 to PostgreSQL 9 |
| Previous Message | Craig Ringer | 2012-09-04 21:52:49 | Re: Maintaining a materialized view only on a replica |