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 Link to comment https://forums.phpfreaks.com/topic/160071-triger-fireing-python-script/ 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. Link to comment https://forums.phpfreaks.com/topic/160071-triger-fireing-python-script/#findComment-844492 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.