Dana,
Anything new with your work on embedded perl in MySQL
Our last thread on this topic was great. I brought up the matter of
possibly making PERL available on the SQL query level. This is PERL/SQL is
to MySQL as PL/SQL is to oracle.
Do we think this is more of a possibility with the status of both
MySQL 4 and PERL 6?
-RG
+------------------------------------------------------------------+
Russell E Glaue, Technologies Engineer & Integrator russ@stripped
Center for the Application of Information Technologies
WIU, 101 Horrabin Hall, 1 University Circle, Macomb, IL 61455
http://www.cait.org
On Fri, 30 Mar 2001, Dana Prescott Kennedy Powers wrote:
> Ive been working for a while on embedding perl in the mysql server, and
> Im wondering how interested anyone is in formalizing the code and
> potentially merging it with the main codebase. Ive added a --with-perl
> extention to configure which creates a unique perl interpreter space for
> each connection. I added a function which will eval a perl expression
> using extra arguments as stack values ( ie. select
> perl('reverse($_[0]);', table1.column1); ). I have convinced myself that
> creating a perl extention ( similar to mod_perl's relationship to
> mysql ) is possible - Ive done it ;) - and can be done in a clean and
> stable way.
>
> More dramatic things which I havent implemented:
> Extention to CREATE FUNCTION which will load perl scripts instead of
> dynamic libraries.
> Extention to CREATE FUNCTION which allows inline function definition and
> storage.
> Mysql Connection API module which would allow perl to create new
> connections and issue queries with them ( ? )
> A more extensible embedded interpreter api ( perhaps for python or
> javascript etc ).
>
> I was a very active participant on the mysql mailing lists about a year
> ago, and I recall someone sending a lone message about wanting to try
> something like this - it actually prompted me to try it. Anyway, im not
> sure if this has been done or discussed, but let me know what you guys
> think.
> As usual the benefit of perl is not necessarily speed of code, but speed
> of coding.
>
> dpk
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail internals-thread653@stripped
> To unsubscribe, e-mail <internals-unsubscribe@stripped>
>
>
