Skip site navigation (1) Skip section navigation (2)

RE: [GENERAL] Creating web images from postgres data

From: "Michael A(dot) Koerber SR" <mak(at)ll(dot)mit(dot)edu>
To: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
Cc: Lincoln Spiteri <lincoln(dot)spiteri(at)st(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: RE: [GENERAL] Creating web images from postgres data
Date: 1998-10-28 19:14:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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.


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 ( 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 (get PHPLIB-6).  It also has some
> fairly good session management and form management routines.  I'm not
> sure if they are including a, 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)

In response to

pgsql-general by date

Next:From: Wim CeulemansDate: 1998-10-28 19:27:22
Subject: Case insensitive "contains" search
Previous:From: Constantin TeodorescuDate: 1998-10-28 18:46:08
Subject: Does "constraint" and "check" work in 6.3.2 ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group