open sources

geoff on 2001-12-13T23:19:55

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 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...

---

Pg

Matts on 2001-12-14T10:10:23

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 :-)

Re:Pg

pudge on 2001-12-14T15:19:35

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.