maria-developers team mailing list archive
Mailing list archive
Re: Some questions on GSOC project User Defined Event
If we want the application developers to take advantage from events
occurring on a table then we could reuse a plugin from drizzle database
which one of friends developed as part of gsoc last year. This plugin
allows the drizzle client to call a function wait_for(type_of_event,
table_name, num_of_events, time_out) and returns when this event occurs in
the table the given number fo times. Currently drizzle uses this in their
replication slave as well. I am not sure how stable this plugin is.
p.s.: I apologize for sending so many emails.
On Sun, Mar 9, 2014 at 1:08 AM, Savita Agrawal <savitarit0@xxxxxxxxx> wrote:
> Hi Kalyan,
> Event support is already there in mariadb. Events are the jobs which are
> run in certain time interval. I am asking about a new project idea which is
> mentioned in mariadb gsoc page. It is unclear to me, what are the use cases
> of user defined events( Events and user defined events are not the same,
> simply because it is mentioned in the page as a new project idea. :) )
> As far as I know user defined events are supposed to save applications
> resources used in polling. But I think the application developer could have
> created a trigger and udf and use lib_mysqludf_sys<https://github.com/mysqludf/lib_mysqludf_sys#readme> to
> invoke external application. But there are security issues in this method.
> Is it the primary/only reason for this project?
> On Sun, Mar 9, 2014 at 12:15 AM, Kalyankumar Ramaseshan <
> rkalyankumar@xxxxxxxxx> wrote:
>> you should read the following post:
>> Kalyankumar Ramaseshan
>> On Sat, Mar 8, 2014 at 10:59 PM, Savita Agrawal <savitarit0@xxxxxxxxx>
>> > Hi,
>> > what is the difference between a trigger and user defined event?
>> > In postgres there is a clear distintion between trigger and event
>> > trigger. Triggers are activated when DML statements are executed
>> whereas event triggers are activated when DDL statements are executed.
>> > But in soliddb (from which our post in JIRA page is inspired), it seems
>> like user defined events can be activated for DML statements. What is it
>> that can't be done with triggers and can be done with user defined event?
>> > Why is the restriction that events can only be posted and received by
>> stored procedures only?
>> > Cheers,
>> > Savita
>> > _______________________________________________
>> > Mailing list: https://launchpad.net/~maria-developers
>> > Post to : maria-developers@xxxxxxxxxxxxxxxxxxx
>> > Unsubscribe : https://launchpad.net/~maria-developers
>> > More help : https://help.launchpad.net/ListHelp