the_oliver Posted May 28, 2009 Share Posted May 28, 2009 Hi, Is it posisble to have a trigger, when an update is made, set of a php or python scrip? (Script is used to open sockets and update other database) Many Thanks Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted May 28, 2009 Share Posted May 28, 2009 I know you can write triggers in python (and possibly PHP), so if the trigger language can execute scripts I don't see why not. Of course the database user will need the proper execute permissions. An alternative would be in your update trigger you set a modified_tm column or insert into a second table. Then you can write a cron-task, or even a service, to monitor for changes and perform any sync operations you need performed. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.