Re: Proper tool to display graphics?

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Carlos Ojea Castro <carlosojea(at)leveltelecom(dot)es>, pgsql-general(at)postgresql(dot)org
Subject: Re: Proper tool to display graphics?
Date: 2004-02-05 17:16:38
Message-ID: 200402050916.38635.scrawford@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 05 February 2004 1:48 am, Carlos Ojea Castro wrote:
> Hello:
>
> I want to display graphics from my postgresql database, but I must
> choose the proper tool first....

Wanting to "display graphics" is rather vague. Are you talking
Entity-Relationship Diagrams? Directed trees? Pie/Bar/Line charts?

Do you want to create them interactively? Generate them on a web site?
How much programming are you willing to do?

For business graphics the choices run the gamut from queries imported
into OpenOffice to (gasp) MS Access talking to PG via ODBC.

For web we have found jpgraph to be very nice. Not free for commercial
use but dirt cheap and well worth the small price. It's runs under
PHP so you can incorporate it in a web page or a shell script. It
supports a variety of business and scientific graph styles.

AT&T's graphviz is interesting for directed tree and similar diagrams.
You can roll your own queries to generate the necessary input files.
This is what pgautodoc does to create database diagrams.

R is a statistical package which can create a variety of graphical
outputs and there are a number of projects to integrate R with PG.

That's just a start. You might try searching freshmeat.net if these
don't meet your needs.

Cheers,
Steve

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Garamond 2004-02-05 17:27:18 functional index "real world" uses
Previous Message Tom Lane 2004-02-05 17:15:26 Re: size of mailing lists?