List:Internals« Previous MessageNext Message »
From:barries Date:March 29 2001 7:42pm
Subject:Re: Hacking triggers into 2.23.34a?
View as plain text  
On Thu, Mar 29, 2001 at 01:35:54PM -0600, elble@stripped wrote:
> > 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.
> 
> yah, i think we're all on the same wavelength here...

Unless somebody steps forward with an existing implementation or shoots
down the approach/suggests a better one, I'll probably start on the
trigger classes early next week.  The big hurdle for me is learning how
to unpack records into List<Item> containers (since update triggers need
pre and post, otherwise all triggers could work like Procedures do and
just accept fields).

'course, since *I* don't need the old_rec, I guess I could hack it in
to just pass "fields".  But I'd like to do the right thing(tm) here.

- Barrie
Thread
Hacking triggers into 2.23.34a?barries29 Mar
  • Re: Hacking triggers into 2.23.34a?elble29 Mar
    • Re: Hacking triggers into 2.23.34a?barries29 Mar
      • Re: Hacking triggers into 2.23.34a?elble29 Mar
    • Re: Hacking triggers into 2.23.34a?Jeremy D . Zawodny29 Mar
      • Re: Hacking triggers into 2.23.34a?elble29 Mar
        • Re: Hacking triggers into 2.23.34a?barries29 Mar
          • Re: Hacking triggers into 2.23.34a?Sasha Pachev30 Mar
          • Re: Hacking triggers into 2.23.34a?barries30 Mar
            • Re: Hacking triggers into 2.23.34a?Michael Widenius31 Mar
        • Re: Hacking triggers into 2.23.34a?Sasha Pachev30 Mar
  • Re: Hacking triggers into 2.23.34a?Antony T Curtis30 Mar
  • Hacking triggers into 2.23.34a?Michael Widenius31 Mar
    • Re: Hacking triggers into 2.23.34a?barries31 Mar
      • Re: Hacking triggers into 2.23.34a?Michael Widenius1 Apr
        • Re: Hacking triggers into 2.23.34a?barries1 Apr
          • Re: Hacking triggers into 2.23.34a?barries1 Apr
            • Re: Hacking triggers into 2.23.34a?Michael Widenius1 Apr
              • Re: Hacking triggers into 2.23.34a?barries2 Apr
                • Re: Hacking triggers into 2.23.34a?Michael Widenius2 Apr
          • Re: Hacking triggers into 2.23.34a?Michael Widenius1 Apr
  • SQL92?Antony T Curtis2 Apr