Re: Hacking triggers into 2.23.34a?

[Jeremy D . Zawodny]

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
-- 
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: [phone]    Fax: [phone]
Cell: [phone]