maria-developers team mailing list archive

[Savita Agrawal <savitarit0@xxxxxxxxx>]

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 <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:
>>
>> 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
>> >
>>
>
>