now the correct message to the list - sorry :-(
--- Original Nachricht --- Betreff: Re: [Owncloud] Usage of triggers: ok for OC apps or too risky ? Von: Thomas Müller <[email protected]> An: "Arthur Schiwon" <[email protected]> Datum: 30.07.2012 16:50 Am Montag, dem 30.07.2012 um 16:36 schrieb Arthur Schiwon: > Hey, > > it depends a bit on what is going to happen in the database. As long as > no ownCloud-logic is bypassed by possible write-actions, it's fine i guess. > > Cheers > Arthur > Hi, I always have bad feelings if application logic is coded in two locations (here database and php). In addition making the triggers work properly on all supported databases might cause a lot of sql migration code. I somehow dislike the idea - mainly due to bad experience in past projects. Take care, Tom > On 07/29/2012 02:13 PM, Christian Reiner wrote: > > Hello all, > > i plan to offer a live monitoring for the occurance of certain events inside > > an OC app. These events are already captured by that app, stored in the > > database and also offered via a hook. However, since OC is based on php > > inside > > a web server environment the users session is spread over several processes. > > I thought of using long polling ajax requests, but obviously want to prevent > > having to poll the database at fixed intervals. Instead, when trying to > > react > > more or less immediately on an event I have to react directly to the event. > > Since this event is captured inside another process two options arise: > > 1. inter process communication > > 2. using triggers inside the database engine > > Inter process comminucation is a great thing, however looking at the > > operating > > systems and the various approaches it seems unlikely to ger this working > > reliable outside unix like systems. On MS Windows there is no dbus, phps > > shared memory extension does not exist and named pipes are not available. I > > know there are only few installations of OC out there, but it would be a > > pitty > > to reduce the list of features on such systems anyway. So I think of using > > the > > second aproach: database triggers. > > To my surprise I read that triggers are supported by SQLite these days, and > > the 'real' database servers relevant here all do so as well. So apart from > > me > > having to implement and test that: > > > > does anyone here see a reason against using triggers in OC apps ? > > > > Thanks, > > Christian > > > > _______________________________________________ > Owncloud mailing list > [email protected] > https://mail.kde.org/mailman/listinfo/owncloud _______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
