Re: postgres and ggobi/xgvis - Mailing list pgsql-general

From Sean Davis
Subject Re: postgres and ggobi/xgvis
Date
Msg-id 38a66dbef65e61ddf6d80c785ee7e39c@mail.nih.gov
Whole thread Raw
In response to postgres and ggobi/xgvis  (Hrishikesh Deshmukh <hdeshmuk@gmail.com>)
List pgsql-general
On Jun 8, 2005, at 7:39 PM, Hrishikesh Deshmukh wrote:

> Hi All,
>
> How easy or difficult is it to get ggobi/xgvis working with
> postgresql?!
> Is it possible to write a query and send the output straight to
> ggobi/xgvis without much work?
> Any pointers.
>

I would think that you would need to construct the input file for ggobi
from your query output.  There are many ways to do this, I would
suppose, but if I were to do it, I would make a perl script that
accepts some parameters, does the SQL query, and outputs the results
with appropriate formatting to a file.  Then call ggobi with that file
as input.  Pretty simple, but you still have to do the work of
determining the file format for ggobi and generating that file format
on your own.

As an alternative, you could use a system like R
(http://www.r-project.org) that has plugins that allow postgres access
and access to ggobi.

Sean


pgsql-general by date:

Previous
From: Howard Cole
Date:
Subject: Re: Backup Compatibility between minor versions.
Next
From: Changyu Dong
Date:
Subject: Re: vulnerability/SSL