Run python script on Database event
Thanks for your answers, i found a solution here:
http://crazytechthoughts.blogspot.fr/2011/12/call-external-program-from-mysql.html
A Trigger must be defined to call an external function once the DB Table is modified:
DELIMITER $CREATE TRIGGER Test_TriggerAFTER INSERT ON SFCRoutingTableFOR EACH ROWBEGINDECLARE cmd CHAR(255);DECLARE result int(10);SET cmd = CONCAT('python /home/triggers.py');SET result = sys_exec(cmd);END;$DELIMITER ;Here, to call my python script, I use 'sys_exec' which is a UDF (User Defined Function). You can download the library from here: https://github.com/mysqludf/lib_mysqludf_sys
You can use 'Stored Procedures' in your database a lot of RDBMS engines support one or multiple programming languages to do so. AFAIK postgresql support signals to call external process to. Google something like 'Stored Procedures in Python for PostgreSQL' or 'postgresql trigger call external program'