Monthly Archives: November 2010

WordPress Statistics Plugins

I’m always in the market for a really good WordPress statistics plugin. WordPress.com stats is not a million miles away from what I want. The standard view shows number of visitors per pages today and yesterday as well as how visitors arrived at the site through referrers or search engine queries. The only other thing [...]

Posted in WordPress | Tagged , , , | Leave a comment

Another Thing Perl and PHP have in Common…

…is that a lot of ignorant people think that they both suck. Do any other Perlers get annoyed when someone who clearly has no idea of the awesome power of Perl claims "Perl sucks" ? It’s just me then. Of course, a significant difference between the two is that no-one thinks that PHP is dead [...]

Posted in Perl | Tagged , , | 2 Comments

Other Languages Have Libraries Too

Ashley Pond V.does not know PHP: “WordPress had to cover dozens or even hundreds of pieces (feeds, site map, remote content fetching, sessions, SSL, revisions, Ajax backend, logging, caching, email) I didn’t have to think about beyond configuration settings and a little glue.” I found this quite amusing. I know the CPAN is great. It [...]

Posted in Perl, WordPress | 2 Comments

Why Work on Melody?

One of the comments on my Choosing a Blogging Engine post mentions Melody, a community fork of the Movable Type content management system which is written in Perl. Which leads me to the question in the title. Whenever I hear about people writing yet another blogging engine in Perl, Python or Ruby it brings to [...]

Posted in Perl, WordPress | Tagged , , | Leave a comment

Why I am not a Hybrid Core User

A few weeks ago, Justin Tadlock released the latest version of his excellent hybrid theme framework – Hybrid Core 1.0. I have used hybrid child themes on a number of websites with good reason. Justin’s code is clean and easy to follow the theme is extremely flexible the support Justin provides for just $25/year is [...]

Posted in WordPress | Tagged , | 4 Comments

Choosing a Blogging Engine

As I am primarily a Perl programmer, the clear and obvious choice was WordPress. I didn’t even consider looking at any of the alternatives available. If it’s good enough for him… Perl luminary, Dave Cross, had some comments on why he chose WordPress. Some of them are more than a little strange; he mentions that [...]

Posted in WordPress | 12 Comments

Improving Database Column Insertion With Thing At Point

I can make ido-insert-database-column even more useful by having it complete some text that I have already typed into the buffer. This is trivial using thing-at-point. The closest thing that matches a database column name is a filename. (defun ido-insert-database-column () (interactive) (let ((bounds (bounds-of-thing-at-point ‘filename)) (input (thing-at-point ‘filename)) selection) (setq selection (ido-completing-read “DB Column: [...]

Posted in Emacs | Leave a comment

Choosing Database Columns Using Ido Mode

For my final riff on extracting the data dictionary using Perl DBI, I’ll demonstrate using ido mode to quickly choose and insert a database column. This was inspired by a Stuart Halloway video which shows that ido mode is useful whenever you need to choose between a list of things. ido mode provides a mechanism [...]

Posted in Emacs, Perl | Tagged , | 2 Comments

Caching The Data Dictionary

In the last couple of posts I have talked about extracting table names using DBI->table_info() and extracting column names using DBI->column_info(). If for example I had a tetchy DBA who didn’t want me to hit the database every time I wanted this information, or I was too impatient to wait for socket set-up/teardown, I might [...]

Posted in Perl | Tagged , , | Leave a comment