On Thu, Mar 29, 2001 at 12:47:35PM -0600, elble@stripped wrote:
> > In a wild moment of engineering excess, I considered adding perl
> > to mysqld to make writing the algrithms easier, but wised up
> > quickly (has anyone done that for writing Procedure callbacks?).
> i've actually been thinking about this quite a bit, and drawing tenative
> parallels to mod_perl for apache.
> my thoughts were evolving along the lines of:
> MySQL <-> Trigger API <-> Module
> and then you could code whatever you wanted into the module
> (support for perl, python, whatever... my interest would
> be perl)
> i'd be interested to hear monty's views on the subject. one of my
> questions would be on where the trigger routines' text would be
> stored (if a module supports interpret-on-the-fly).
Just for the record, we tossed around the idea a bit here as well.
Haven't decided to (or not to) do it yet, but the idea was similar to
what Barrie posted.
We were thinking something like:
"Gee, you can add UDFs to MySQL today by building an .so and telling
MySQL to use it. Then it's available for queries. What if we did
something similar that allowed a user to write `triggers' that could
do fairly simple things on the server side."
The specific thing we wanted initially was the ability for the server
to send a multicast message when a particular update happened.
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951