Installation

$ git clone git://github.com/mattn/mysql-mruby.git$ cd mysql-mruby$ make$ sudo cp mysql_mrb.so /foo/bar/lib/mysql/plugin/

$ mysql -urootmysql> create function mrb_eval returns string soname 'mrb_eval.so';

Usage

mysql> SELECT mrb_eval('[1,2,3].map {|x| "hello" + x}');+-------------------------------------------+| mrb_eval('[1,2,3].map {|x| "hello#{x}"}') |+-------------------------------------------+| ["hello1", "hello2", "hello3"]            |+-------------------------------------------+1 row in set (0.00 sec)

mysql> select mrb_eval('ARGV', now(), now());+------------------------------------------------+| mrb_eval('ARGV', now(), now())                 |+------------------------------------------------+| ["2015-05-01 19:53:02", "2015-05-01 19:53:02"] |+------------------------------------------------+1 row in set (0.00 sec)

mysql> create table foo(id integer primary key auto_increment, value text);Query OK, 0 rows affected (0.39 sec)mysql> insert into foo(value) values('foo');Query OK, 1 row affected (0.08 sec)mysql> insert into foo(value) values('boo');Query OK, 1 row affected (0.02 sec)mysql> select mrb_eval('ARGV[0]', value) from foo;+----------------------------+| mrb_eval('ARGV[0]', value) |+----------------------------+| foo                        || boo                        |+----------------------------+2 rows in set (0.00 sec)

Author