PL/Ruby equivalent in MySQL

Question

PL/Ruby is a loadable procedural language for Postgres that lets you use Ruby to write user defined functions for the database.

Anyone know of an equivalent way of writing user defined functions for MySQL in Ruby?

Answer 1

Mysql as far as I am aware only supports MySQLs own stored procedure language.

I'm a postgresql fan too, and this is something that has always frustrated me about MySQL when I have had no choice but to use it. :(

Answer 2

Starting from version 5 (I think) Mysql supports stored procedures, but the syntax is restricted to SQL:2003 which is somewhat similar to PL/SQL.

Other languages aren't supported and I'm not aware of any projects offering ruby support. Last time I checked the PL/Ruby extensions to postgres were still a bit wonky as well, though.