Re: Perl + Mysql

[Dana Prescott Kennedy Powers]

Ive been thinking a bit about the cleanest way to integrate an embedded
interpreter and mysqld.
My plan right now is to a enable 'CREATE FUNCTION my_func
RETURNS STRING PERL_NAME "my_perl_script.pl";'. The mysql.func table would be
modified to add an additional column set in sql_yacc.yy, lang_type (other
ideas?), which would indicate how the udf should be loaded - either using
dlopen() ( currently the only option ), or by passing it off to an interpreter
( perl here ). Then we modify UDF_INIT to also include the function name and the
dl path, so that the interpreter can load the appropriate file when necessary.
This hopefully will leave almost all of the current udf code untouched, with the
exception of the dlopen() and dlclose() calls - and shouldnt break existing udf
functions.
Thoughts?
dpk