Hello:

I want to display graphics from my postgresql database, but I must
choose the proper tool first.
Which one is more suitable?:
perl?
php?
pg_autodoc?
another one?

Thank you in advance,
Carlos



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

On Thu, 5 Feb 2004, Carlos Ojea Castro wrote:
[color=blue]
>
> Hello:
>
> I want to display graphics from my postgresql database, but I must
> choose the proper tool first.
> Which one is more suitable?:
> perl?
> php?
> pg_autodoc?
> another one?[/color]

php and the gdlib work pretty well. It's not as simple as programming in
logo, but it's pretty close. :-)


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

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

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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

>[color=blue]
>[color=green]
>>I want to display graphics from my postgresql database, but I must
>>choose the proper tool first....
>>[/color]
>
>Wanting to "display graphics" is rather vague. Are you talking
>Entity-Relationship Diagrams? Directed trees? Pie/Bar/Line charts?
>[/color]

Thank you for your response, Steve. I want to display Pie/Bar/Line charts
[color=blue]
>Do you want to create them interactively? Generate them on a web site?
>How much programming are you willing to do?
>[/color]

Yes, I want to create them interactively, but not necessary on a web site.
I am willing to program as much as neccesary.
[color=blue]
>For business graphics the choices run the gamut from queries imported
>into OpenOffice to (gasp) MS Access talking to PG via ODBC.
>[/color]
I am using PostgreSQL under linux
[color=blue]
>
>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
>[/color]
Thank you Steve, so: is PG a good choice for me?
Cheers,
Carlos



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

"Carlos Ojea Castro" <carlosojea@leveltelecom.es> wrote in message
news:40227DDA.8030908@leveltelecom.es...[color=blue][color=green]
> >
> >[color=darkred]
> >>I want to display graphics from my postgresql database, but I must
> >>choose the proper tool first....
> >>[/color]
> >
> >Wanting to "display graphics" is rather vague. Are you talking
> >Entity-Relationship Diagrams? Directed trees? Pie/Bar/Line charts?
> >[/color]
>
> Thank you for your response, Steve. I want to display Pie/Bar/Line charts
>[/color]


If you're comfortable w/ Perl, DBI, and SQL, might I suggest
DBIx::Chart ? www.presicient.com/dbixchart

It should make the process somewhat
transparent by extending (bastardizing?) SQL syntax, so it looks like
Pg generates your graphs directly...and should work with other dbms's
as well. Oh, and its FOSS.

Dean Arnold
Presicient Corp.
www.presicient.com

On Thu, Feb 05, 2004 at 06:31:06PM +0100, Carlos Ojea Castro wrote:
[color=blue][color=green][color=darkred]
> >>I want to display graphics from my postgresql database, but I must
> >>choose the proper tool first....[/color]
> >
> >Wanting to "display graphics" is rather vague. Are you talking
> >Entity-Relationship Diagrams? Directed trees? Pie/Bar/Line charts?[/color]
>
> Thank you for your response, Steve. I want to display Pie/Bar/Line charts[/color]

I've used the Chart module for Perl with some success. Had to hack it a
little to allow truetype fonts and some weird local requirements, but
it's nice to work with.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La naturaleza, tan frágil, tan expuesta a la muerte... y tan viva"

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org