Perl

It’s been a while since I posted anything here, I blame winter plus a host of all sorts of things that have been keeping me busy. Since the last blog post, there have been a number of things. Delano and I released One-Time Secret, along with Ruby, PHP and (thanks to Kyle Dawkins) Perl client libraries for using the API. OTS was a bit of distraction from our work on Blame Stella, but rest assured that work on Blame Stella 2.0 is still under way. We should have news on both of these projects in the near future. In this time, I did write a couple of blog posts for One-Time Secret. If you haven’t seen them, they’re here: A minor rant and pet peeve of mine: ‘Good’ vs ‘Strong’ passwords Some helpful tips on Protecting your credentials from criminals I’ve got a bunch of exciting new things on the […]... Read More

I had a problem that I needed to solve recently, and the most elegant way to do this was with a stored procedure. However, the procedure needed to return 2 columns – an index id and a sort order. One way to tackle this is to have the plperl function called by a wrapping plpgsql function, but that’s ugly. I wanted to do it all in plperl, but couldn’t find any documentation on it with custom rowtypes. So, off to IRC for some info. xzilla on #postgresql (irc.freenode.net) pointed me out to a recent blog posting of his that seemed to do what I wanted using Out parameters. This was really great, and I knew I had something I could work with there. Thanks xzilla! So, I took it a bit further and modified his example slightly to see if I could also do it without the out parameters and […]... Read More

Christopher Murtagh

Ponderer, feminist, musician and dad.

Postgresql, plperl and custom rowtypes