Re: Views, views, views! (long)

On Thu, May 05, 2005 at 08:15:27PM -0000, Andrew - Supernews wrote:
> On 2005-05-05, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> > This makes sense; I do wish that someone had mentioned it when I
> > originally raised the subject of new system views. It would have
> > saved us some work.
>
> I'd have raised it myself if I thought there was any mileage in it.
> As you can probably guess, I don't.
>
> information_schema is fine at what it is _intended_ for - as a
> standardized way of accessing a standard subset of the available
> metadata. In that sense it is still necessary - however it is not
> sufficient, and I don't believe that either the raw catalogs nor any
> reasonable extension of information_schema actually fills that gap.

The information schema has the same problem that every other system
built for every database does: it has a minimal set of abstract
information, which prevents it, by design, from having application-
specific functionality.

Kudos to the New System Views people for their hard work thus far :)

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

Remember to vote!