X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D498BD1D2DF for ; Mon, 9 Feb 2004 20:02:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 00348-08 for ; Mon, 9 Feb 2004 16:02:18 -0400 (AST) Received: from extern.nyscul.org (nyscul.org [168.215.102.130]) by svr1.postgresql.org (Postfix) with ESMTP id C0FB7D1B897 for ; Mon, 9 Feb 2004 16:02:16 -0400 (AST) Received: from mailserv.nyscul.org ([10.1.17.1]) by extern.nyscul.org with esmtp (Exim 3.35 #1 (Debian)) id 1AqHbJ-00068s-01; Mon, 09 Feb 2004 15:01:49 -0500 Received: from dzoll.nyscul.org (mail@dzoll10.nyscul.org [10.1.101.1]) by mailserv.nyscul.org (8.12.3/8.12.3/Debian-5) with ESMTP id i19K1O6m029505; Mon, 9 Feb 2004 15:01:25 -0500 Received: from dzoll by dzoll.nyscul.org with local (Exim 3.36 #1 (Debian)) id 1AqHat-00010G-00; Mon, 09 Feb 2004 15:01:23 -0500 Date: Mon, 9 Feb 2004 15:01:23 -0500 From: "David L. Zoll" To: Carlos Ojea Castro Cc: Pgsql-interfaces Subject: Re: Proper tool to display graphics? Message-ID: <20040209200123.GI7222@dzoll.nyscul.org> References: <40225EF4.4050807@leveltelecom.es> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <40225EF4.4050807@leveltelecom.es> User-Agent: Mutt/1.5.5.1+cvs20040105i X-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/8 X-Sequence-Number: 4701 On Thu, Feb 05, 2004 at 04:19:16PM +0100, Carlos Ojea Castro wrote: > > 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? It's hard to tell what you are asking, since you give very little detail. pgautodoc (http://www.rbt.ca/autodoc/) creates UML diagrams of the database structure, sutable for use in HTML, Dia, Dot/GraphViz and Docbook. If that's what you are looking for, you might find it very useful. If you are looking to display graphics stored in a database, or generate dynamic graphics based on data in the database, you're out of luck with pgautodoc. In those cases, perl, php and python all are good. They each have unique advantages and disadvantages, use what you're most comfortable with. If you are looking to generate dynamic graphics based on data stored in the database, make sure to check out the GD library. All three languages (perl, php and python) have APIs for GD available. Best of Luck -Gleef (David Zoll, NYSCUL)