Mariadb trigger to invoke a python code

Question

I have a python code to be executed when a database table is updated. How can I write a Mariadb trigger for the same?

Georg Richter · Accepted Answer · 2016-10-20 11:28:05Z

3

By default MariaDB doesn't support execution of external programs.

As a workaround you can call a udf (user defined function) which executes python interpreter. lib_mysqludf_sys from UDF Repository for MySQL might be the right udf for.

So your trigger definition might look like

CREATE TRIGGER my_trigger BEFORE UPDATE ON my_tbl
  ....
  SET RC= sys_exec('/usr/bin/python my_script.py');
  ....

answered Oct 20, 2016 at 11:28

Georg Richter

7,6442 gold badges19 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Phoenix Over a year ago

Have tried it. I am cyurrently using Fedora24. Unable to install mysqludf here.

Phoenix Over a year ago

The error I get is "You need libmysqlclient development software installed". However, I am using mariadb. So the corresponding package is mariadb-devel, which is already installed.

Georg Richter Over a year ago

git clone github.com/mysqludf/lib_mysqludf_sys - the shared object in this repo doesn't depend on libmysqlclient.

Phoenix Over a year ago

I used the same repo. In the install.sh file, the code is as follows:

Phoenix Over a year ago

if test $? -ne 0; then echo "ERROR: You need libmysqlclient development software installed " echo "to be able to compile this UDF, on Debian/Ubuntu just run:" echo "apt-get install libmysqlclient15-dev" exit 1

Collectives™ on Stack Overflow

Mariadb trigger to invoke a python code

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related