Follow Slashdot stories on Twitter


Forgot your password?
Perl Programming

MySQL Gets Perl Stored Procedures 266

ryarger writes "Woo Hoo! After a seeming eternity of wait, there is finally an implementation of stored procedures for MySQL. It uses Perl as the stored proc language, too!" Also note that this piece of work was done by OSDNs own Krow. Very cool work I must say.
This discussion has been archived. No new comments can be posted.

MySQL Gets Perl Stored Procedures

Comments Filter:
  • Re:WTF? (Score:3, Informative)

    by dameatrius ( 182345 ) on Friday August 24, 2001 @01:32PM (#2214176)
    Actually, this is very useful. If you want to do say 6000 inserts using a comma delimited string or something along those lines, to open a connection and call a specific stored procedure is EXTREMELY slow compared to parsing the string internal to the stored procedure (recent test I did when designing some software showed an insert called 6000x took 16 seconds compared to 1.5 seconds parsing the string in the db). Now when you use a language like java or perl to do that internal to the db, it will drop that time even more as SQL design wise has string manipulation features but isn't meant to be doing it. I would much rather have a Java parser that I call inside my sp and have it take half a second versus 1.5 seconds to have PL/SQL parse my strings. If you actually did any development involving database interaction, this would be pretty obvious.
  • by Malcontent ( 40834 ) on Saturday August 25, 2001 @03:56AM (#2215849)
    " if they put hooks into a generic MySQL facility which allows *any* programming language to serve as a SP language in the server. Why can't I use Python?"

    Postgresql does this. You can use python, perl, TCL, and PL/PGSQL.

    They are debating loading up Java but there seems to be some resistance from the hackers.

e-credibility: the non-guaranteeable likelihood that the electronic data you're seeing is genuine rather than somebody's made-up crap. - Karl Lehenbauer