Re: [HACKERS] Function management in PG

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: "Robins Tharakan" <tharakan(at)gmail(dot)com>, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Function management in PG
Date: 2008-10-02 16:12:46
Message-ID: 200810021212.47067.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-hackers

On Tuesday 30 September 2008 02:19:31 Robins Tharakan wrote:
> Hi,
> While making a complex database back-end, I have at-hand about 200 odd
> functions and frankly 'management of functions' is already getting quite
> tedious. Since the count is certain to rise, I am looking for a good tool
> to do this.
>
> By management, I guess I am looking at some kind of tagging mechanism,
> where it could keep stored a list of tags for each function (tags that I
> provide, for each new function created) and it be able to provide a
> comfortable way of searching/browsing through the list.
>
> Originally, I also wished that this could allow me to see whether a given
> function directly (or indirectly) 'can' change the database, but I guess
> the 'Volatile' function type suffices my need there. The problem with that
> is that I still can't see a function's volatility alongside a list of
> functions. Now making a front-end in PHP seems a few days of work, and
> although not impossible, I wondered whether this has already been done.
>

Well, phppgadmin (1) already shows comments for functions in its function
listing, so you could put tagging there (and i think our search feature
searches comments as well). A patch adding volitility and security (definer|
caller) info into the listing screen would probably be accepted :-)

> How do you manage large list of functions (where a hard segregation isn't
> hard and therefore one can't separate functions based on schemas) ?Any
> pointers to a Free or Commercial tool would be of immense help.
>

if you don't due a lot of function overloading, getddl (2) can be used to push
function code into subversion... thats more code management than api
management, but might be helpful. (note, getddl is still pretty rough around
the edges).

(1) http://phppgadmin.sourceforge.net/
(2) https://labs.omniti.com/trac/pgsoltools/wiki/getddl

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2008-10-07 12:26:09 Re: Buglets in dlgFunction
Previous Message Dave Page 2008-10-02 08:53:39 Re: Buglets in dlgFunction

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua Drake 2008-10-02 16:13:38 Re: Block-level CRC checks
Previous Message Aidan Van Dyk 2008-10-02 16:05:59 Re: Block-level CRC checks