The WorkingWithBlobs document describes how you’re supposed to be able to work with binary columns in Class::DBI. The example shows is for Oracle, and the corresponding Postgres code should work like this: __PACKAGE__->data_type(column_name => { pg_type => DBD::Pg::PG_BYTEA } );…

I was emailing with John Gruber about his SmartyPants plugin. It wasn’t correctly parsing a file and we were trying to figure out the right preg expressions to match HTML comments, PHP, etc. I learned quite a bit from our…