Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

geoff (2013)

geoff
  reversethis-{gro ... om} {ta} {ffoeg}
http://www.modperlcookbook.org/

see http://www.modperlcookbook.org/~geoff/ [modperlcookbook.org] for personal information, links to presentations, GPG key, and so on.

Journal of geoff (2013)

Thursday December 13, 2001
06:19 PM

open sources

[ #1633 ]
today I wrote a sendmail log parsing script. a few interesting things happened while I was working on it.

$ perl -cw myscript

yielded

"use" may collide with future keyword

eh? seems that /usr/bin/perl on this box was Perl 4 *gasp*

that was good for a chuckle.

anyway, instead of writing my own log parser (which is probably just as common as writing your own templating system) I borrowed one. I used mtop which was written by friend and former co-worker Jeff Horwitz. thanks to Jeff, all I have to do is tear apart his work to get what I need, not write it myself. kudos to open source...

speaking of Jeff, a few months ago he lets me in on an alpha of extproc_perl. If you like perl and are an oracle slave (like me), then you should probably check it out. extroc_perl is mod_perl ala oracle - perl embedded in oracle, so you can use perl methods and regular expressions from SQL or PL/SQL. smashing, baby.

With the book and all, I haven't had the time to properly play with extproc_perl, but I think the time is ripe. Last friday, he stops by for lunch and I get the skinny on what's going with it. Besides a bit of press on the DBI users list, it appears as though everyone will know about extroc_perl before too long (wink, wink). So, if you want to be cool, impress your friends, and be a trend-setter, check it out...
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • I'm surprised more people don't know that you can actually write entire stored procedures in PostgreSQL using Perl. This is pretty neat - you can open cursors and navigate through them using all the common idioms in Perl we know and love (map, grep, etc).

    Also, on a similar note: Pg 7.2b4 was released this week, with mucho performance improvements over 7.1... Should blow MySQL out of the water real soon now :-)
    • There is something similar like that for MySQL, though I can't say how good it is. It's still early in development, called myperl [tangent.org].