I have written a simple perl script that makes use of gnuplot. It is
quite austere and was designed to be used with PSQL. The idea is to run
it like this
psql> \o | pp [a bunch of options]
psql> select a,b,c,d from some_table order by a;
The perl script pp and gnuplot create a postscript graph with
a == the_x_axis and b,c,d on the y-axis.
This may be way too simple for your application, but if it is of interest
I'll post it for your use.
Dr Michael A. Koerber
Radar Imaging Techniques
On Wed, 28 Oct 1998, Jackson, DeJuan wrote:
> > Hello all,
> > I am currently starting up a pilot project to demonstrate the power of
> > the linux/postgres/php trio in an enterprise setting.
> > I would like to be able to output graphs from data stored in a
> > postgres
> > table for viewing on a web browser as a means of data presentation.
> > Could anyone give me some suggestions as to what the best approach
> > would
> > be to achieve this.
> I personally would use PHP (http://www.php.net/) to accomplish this
> goal. The PHP project has a GD interface which allows you to
> dynamically create images. You could also generate the graph using
> gnuplot and display the image using PHP. You can find a graphing
> example at http://phplib.shonline.de/ (get PHPLIB-6). It also has some
> fairly good session management and form management routines. I'm not
> sure if they are including a db_pgsql.inc, but I've made my own (this
> will make more since as you look at PHPLIB). Let me know if you have
> any questions.
> > Regards
> > Lincoln Spiteri
> > STMicroelectronics (Malta)
In response to
pgsql-general by date
|Next:||From: Wim Ceulemans||Date: 1998-10-28 19:27:22|
|Subject: Case insensitive "contains" search|
|Previous:||From: Constantin Teodorescu||Date: 1998-10-28 18:46:08|
|Subject: Does "constraint" and "check" work in 6.3.2 ?|