Re: Views, views, views: Summary of Arguments - Mailing list pgsql-hackers

From David Fetter
Subject Re: Views, views, views: Summary of Arguments
Date
Msg-id 20050512235907.GF11078@fetter.org
Whole thread Raw
In response to Re: Views, views, views: Summary of Arguments  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: Views, views, views: Summary of Arguments
Re: Views, views, views: Summary of Arguments
List pgsql-hackers
On Thu, May 12, 2005 at 05:52:43PM -0400, Robert Treat wrote:
> On Thursday 12 May 2005 01:32, Christopher Kings-Lynne wrote:
> > > FWIW, I don't see the issue as "internal vs external" at all.
> > > What's bothering me is whether these views can be considered
> > > sufficiently more stable and better designed than the physical
> > > system catalogs to justify recommending that application
> > > designers should rely on the views instead of the catalogs.
> > > That point doesn't seem to me to have been proven.  The recent
> > > arguments in favor seem to boil down to "novices will find these
> > > easier to use", which is very possibly true, but novices don't
> > > have the same needs as programs.
> >
> > As lead phpPgAdmin developer, I'm officially in favour of them.
> > The main reason being all the extra fruit they have that shows
> > database size, etc.
> >
> 
> As non-lead phpPgAdmin developer, I'd be against using them in
> phppgadmin.  (note this doesnt mean I am against them in pgsql
> itself)

On what grounds?

> > That means we can display this meta information in phpPgAdmin and
> > not worry about having to re-implement it all.
> >
> 
> You have to query something...  doesn't bother me to go to the
> source. 

A PostgreSQL developer has shown in this very thread that it is
extremely easy to screw up a query against those catalogs.  Maybe
you're better than he is, but that's not a reason to keep something
simpler out.

Cheers,
D
-- 
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Views, views, views: Summary of Arguments
Next
From: Christopher Kings-Lynne
Date:
Subject: PostgreSQL running out of file handles