Just a little idea to help give everyone's mind a break from 6.1
issues for a moment. This would probably be a 7.0 thing, depending on
how the releases go.
Has anyone thought of making use of an embedded scripting package
in PostgreSQL? This would be something along the lines of TCL or
Guile. I'd lean towards Guile, personally, as it seems the most
flexible. Guile is an embeddable Scheme (a dialect of Lisp)
interpreter. The nice thing about it is that the version of Scheme
that it implements is powerful enough to "emulate", if you will, other
languages. In fact, the guys who put Guile together have already
implemented what they call CTAX, which is a syntax very similar to C.
I'm thinking we could intergrate this in with the Postgres parser
(and probably the SQL Function managing code) to give us all sorts of
new tricks. For instance, this might be a nice, easy, powerful way to
implement some of the extensions to SQL that many commericial packages
have (ie, variables, loops, conditionals, etc).
What does everyone think of something like this?
- -Brandon :)
------------------------------