Re: pg_advisor schema proof of concept - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: pg_advisor schema proof of concept
Date
Msg-id Pine.LNX.4.58.0403251703460.7217@sablons.cri.ensmp.fr
Whole thread Raw
In response to Re: pg_advisor schema proof of concept  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: pg_advisor schema proof of concept
List pgsql-hackers
Hello,

> Both phpPgAdmin (me) and the pgAdmin team have added or have thought
> about adding some 'schema analysis' features to our products.  If
> pg_advisor is available, I certainly won't bother and I will just
> recommend to people that they install it.

Ok.

A more precise question is: on the client side, whether PHP or anything
else, can you take advantage of the information available and provide some
usable somehow "dedicated" interface that would make it easy to access the
available informations? What would help for that purpose?

The current proposal is that the advices would be tables in a schema, so
just by browsing the tables one can access advices.  However, the tables
contain the advice data, but explanations about what these advices mean
are in another table.

So maybe there is an interface job that would be welcome to show both the
explanations and the data of interest for these explanations? Just like
in psql "\*" shortcuts query about pg_tables to show informations.

-- 
Fabien.


pgsql-hackers by date:

Previous
From: Christopher Browne
Date:
Subject: Re: subversion vs cvs
Next
From: Daniel Schuchardt
Date:
Subject: Re: Delphi