maria-developers team mailing list archive

[Savita Agrawal <savitarit0@xxxxxxxxx>]

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:
>
> http://www.sitepoint.com/how-to-create-mysql-events/
>
> --
> Regards,
> Kalyankumar Ramaseshan
>
>
>
> On Sat, Mar 8, 2014 at 10:59 PM, Savita Agrawal <savitarit0@xxxxxxxxx>
> 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     : maria-developers@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~maria-developers
> > More help   : https://help.launchpad.net/ListHelp
> >
>