#Perl

• A Guide to Building Perl From Source on macOS

  30 Jul 2025 | 6 minutes read

  macos perl coding software

  This guide explains how I install a clean version of Perl from source on macOS, along with the modules that I use every day.

  My philosophy for programming tools is to try to keep things as simple and transparent as possible. I often find that modern package and version managers, while powerful, add layers of complexity I don’t need. I rarely require multiple versions of a programming language on the same machine, and I don’t want to hunt for where my binaries and libraries are located. Instead, I prefer a stable, predictable architecture where I know exactly where to find everything.

  read article

• The Perl and Raku Conference 2024 - Las Vegas

  09 Jul 2024 | 10 minutes read

  perl coding software cgi vegas

  

  I was fortunate enough to attend my very first in-person Perl conference this year in Las Vegas! Ironically my first real exposure to Perl was almost 30 years (!!) ago when I read Learning Perl on a plane to Vegas!

  It was great to finally meet so many wonderful people that I felt I already knew through using their software and watching conference talks from prior years. Here were the highlights of the conference for me.

  read article

• UTC/Local Date Conversion in Perl With Time::Piece

  22 Sep 2023 | 4 minutes read

  coding perl dates

  Time::Piece is my preferred perl module for handling dates. Here is how it can be used to convert between UTC and the local time, even for past dates which may have crossed the current daylight savings time status.

  read article

• Regex is a Programming Superpower!

  21 Aug 2023 | 3 minutes read

  coding perl regex

  

  In an August 15 tweet, @iamdevloper, a very funny programmer-humor account, asked which technology you wouldn’t bother to learn over again: JavaScript, Regex, Kubernetes, or PHP. Never mind the completely obvious answer (if you aren’t in operations at Google, you probably don’t need Kubernetes), I was blown away on how many of the responders admitting to not knowing Regex.

  read article

• Using ack to search Apache web logs

  12 Jan 2021 | 1 minute read

  coding perl apache

  The ack utility uses Perl regular expressions to efficiently search source code, with smart defaults to limit the results to what you expect.

  One of the ways I use it is to search our Apache web log files. The logs capture all requests, including ones for images, style sheets, fonts, and javascript files. But usually I’m only interested in who visited which web pages, including CGI scripts.

  I’ve added a Bash function to my .bashrc file, acklog, that filters out the extraneous files automatically:

  # ack (grep) for scripts in apache
  function acklog() {
    ack "$@" | ack -v '\.(css|eot|gif|ico|jpe?g|js|png|svg|swf|webp|woff2?|xml)[? ]'
  }
  

  read article

• Installing ODBC on Linux for MSSQL and AS400 DB2

  01 Mar 2013 | 5 minutes read

  coding perl sql as400 mssql

  At work, we use Microsoft SQL Server and IBM AS400 databases. Here’s how I set our Linux boxes to allow them to connect to the databases through ODBC. There are seperate instructions for the Debian and Ubuntu (9.10 Karmic Koala) and Red Hat Enterprise Linux (RHEL4 and RHEL5) distributions.

  ODBC connections require several layers of software to work. The bottom layer consists of the individual ODBC drivers for each database system. Our top layer is the DBI/DBD interface for Perl. In between these layers is the ODBC driver manager, which keeps track of the DSN’s and their corresponding ODBC drivers.

  Packages and Software to Install

  Ubuntu Version (tested on 9.10 Karmic Koala)

  Debian Version (“unstable” distribution)

  We use unixODBC as our ODBC driver manager. First, install unixODBC:

  NOTE: Perl’s DBD::ODBC module requires the developer’s version of unixODBC, so install that one.

  # apt-get install unixodbc-dev
  

  read article

• Returing null Columns from iSeries AS400 with Perl DBI

  08 Aug 2012 | 2 minutes read

  coding perl sql as400

  We’re having an issue with database queries to the iSeries AS400 through Perl using DBI and DBD::ODBC. The issue occurs when the SQL statement contains an outer join and the query returns rows with NULL columns:

  my $sql_query = qq|select PRSK01, PSTA15
                      from TESTHA.POLMAST
                      left join TESTHA.P15POLDP
                      on POLC01 = PPOL15 where POLC01 = 003950136|;
  
  # Execute the sql query
  my $sth = $dbh->prepare( $sql_query )
                      or die $sql_query, "<BR>\n", $DBI::errstr;
  
  my $data = $dbh->selectall_arrayref( $sth, {Columns=>{}}, @sql_data )
                      or die $sql_query, "<BR>\n", $sth->errstr;
  

  The error returned is:

  DBD::ODBC::db selectall_arrayref failed: st_fetch/SQLFetch (long truncated
  DBI attribute LongTruncOk not set and/or LongReadLen too small) (SQL-HY000)
  

  read article

• Notes from the Perl FAQ

  20 Jan 2012 | 3 minutes read

  coding perl

  Like the fellow that never read his car’s owner’s manual, I had never read the entire Perl FAQ. I finally did it over the holidays, and these are some notes that I took.

  read article

• Calling a Perl CGI script from within another CGI script

  19 Nov 2010 | 1 minute read

  coding perl cgi

  Awhile back we had an issue where a coworker wanted to use one of my Perl CGI scripts inside of her scripts, using the backticks method to have it spit its output to the webpage. But for some reason, my script refuse to recognize the arguments she was passing it. The weird thing was, if we ran her script from the command line, everything worked fine.

  The issue is in the way CGI.pm detects whether it is being called from a web browser or from the command line. It checks for the presence of the REQUEST_METHOD environmental variable. If it is present, CGI knows to get its arguments from the web browser.

  read article

• Using LWP::Simple to retrieve binary data

  16 Apr 2010 | 2 minutes read

  coding perl

  We have a Perl CGI script at work that acts as a proxy. It grabs a pkcs12 digital certificate file from an internal server and delivers it to a user through his or her web browser. The pkcs12 file is in binary format.

  Everything worked fine until we put the code on a new server. Suddenly, the files downloaded by the web users were corrupted. We also began seeing the following warning in the log files:

  Wide character in print at download.cgi line 124.
  

  Here is the code…

  read article

• Things I always need to look up in Perl

  21 Dec 2009 | 2 minutes read

  coding perl

  Here are some random Perl things I always need to look up:

  read article

• Perl Modules Primer

  26 Sep 2005 | 3 minutes read

  coding perl

  Splitting a Perl application into seperate files can be trickier than doing it in other languages, like C or C++, but it is still an important part of producing maintainable code.

  read article