RE: [GENERAL] Creating web images from postgres data

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;
psql> \o

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.

mike

Dr Michael A. Koerber
MIT/LL
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.
> -DEJ
>
> > Regards
> >
> > Lincoln Spiteri
> > STMicroelectronics (Malta)
>