Re: Report Generator Proposal

From: Mauricio de Castro <mcastro(at)solis(dot)coop(dot)br>
To: kaolin fire <cognosco(at)tentacle(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Report Generator Proposal
Date: 2003-09-16 10:29:39
Message-ID: 200309160729.40290.mcastro@solis.coop.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Report Generator in PHP-GTK that work with Pear-db. It's very easy for
users...

http://agata.codigolivre.org.br

Creator: Pablo (pablo(at)php(dot)net)

[]s
Mauricio

On Monday 15 September 2003 18:25, kaolin fire wrote:
> On Monday, September 15, 2003, at 02:06 PM, Gaetano Mendola wrote:
> > ""Matt Clark"" <matt(at)ymogen(dot)net> wrote:
> >> It'd be easy to automate all except the explain, a script that did
> >
> > everything else could then emit "If your preoblem relates to a
> >
> >> specific query, then run 'explain analyze <query>' and attach it to
> >> your
> >
> > message as well".
> >
> > Well, must be charge of psql store somewhere all selects performed
> > between the BEGIN REPORT and END REPORT and perform
> > the explain command of that selects with the explain; may be the really
> > difficult here is that psql
> > shall know all tables involved in a select and insert in the report the
> > descriptions of that tables.
> > Before to work on it I want be sure that is a good idea.
> >
> > Regards
> > Gaetano Mendola
>
> sounds good. maybe with the option (enabled by default?) to only show
> the columns used in the queries for the tables pulled. ((wheat from
> chaff and all that))
>
> hmm. though there's still the (some small percentage of) things that
> could be going wrong with custom stored procedures. dumping those
> would be (I'm presuming, based on the scope of the task as it's been
> described) reasonably simply, but figuring out what they touch could be
> prohibitive?
>
> kudos for any attempt, though, all around. :)
>
> -kaolin fire
> -postgresql novice
> -http://poemranker.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Maurício de Castro
Coordenador de Desenvolvimento em Software Livre
SOLIS - Cooperativa de Soluções Livres
http://www.solis.coop.br
51 3011 0610

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Markus Espenhain 2003-09-16 11:54:54 SQL-Statement
Previous Message Frédéric Burlet 2003-09-16 07:38:23 pg_ctl reload seems to not work