Hi, 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 <[email protected]> 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 < > [email protected]> wrote: > >> you should read the following post: >> >> http://www.sitepoint.com/how-to-create-mysql-events/ >> >> -- >> Regards, >> Kalyankumar Ramaseshan >> >> >> >> On Sat, Mar 8, 2014 at 10:59 PM, Savita Agrawal <[email protected]> >> wrote: >> > >> > 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 : [email protected] >> > Unsubscribe : https://launchpad.net/~maria-developers >> > More help : https://help.launchpad.net/ListHelp >> > >> > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
