Please enter e-mail address to continue:
	Submit

Saving Settings

The code samples below are mainly simple utility scripts written in Perl and shown as samples of coding style. For complete Object-Oriented Perl samples (open source code), including Catalyst MVC projects, please follow links provided on home page.

Reload Apache Server - This is a session driven script (via Poe::Session and the POE::Kernel) written in Perl and used for mod_perl development servers. It will fetch a list of files (defined by project files on disk) from a MySQL database table, check if any files have been modified on disk via 'stat', restart apache if required, and then sleep for x (defined by $ARGV[0]) seconds. If database table does not exist it will create and populate during the initial startup check.

Catalyst XML::Feed Module - This is a complete Catalyst controller module which is used to generate RSS feeds dynamically through MySQL database queries.

Export Data Using Spreadsheet::WriteExcel - This is a complete Catalyst controller module which is used to export specific database records to Excel spreadsheet file.

Quantcast Rank - This utility script will query the local database, store site_id and url columns in an array, then for each site listing fetches the site rank from Quantcast.com using LWP::Simple module. Once the rank has been found, the script will insert or update (DBIx::Class) the SiteRank database table with the site id and rank. The results can be view at CatalystSites.org by clicking the "By Rank" link in the main navigation.

Email Alert - This utility script was written for a project I worked on for a popular DJ booking site. The script queries the members database table, checks for members who have not logged in for more than three months, and then sends out a list to admin. This was to be setup as a cron job and run on a daily bases.

Populate FedACH - This utility script opens a local text file downloaded from the Federal Reserve of all bank routing numbers. The script will unpack and format data, and then populates the database using the DBIx class. More info: https://www.fededirectory.frb.org/download.cfm

Update FedACH - This utility script fetches a text files from the Federal Reserve of all bank routing numbers. The script then updates an existing database using the DBIx class update_or_create keyed on the routing number. More info: https://www.fededirectory.frb.org/download.cfm

Sedo Top Domains - This script fetches a text file from Sedo.com of top domain listings on their site. The script will parse and format data into a table to be displayed on a web page.