Posts Categorized: Technical Blog

A MySQL Community Member Opinion of Oracle Buying Sun

The bottom line: As both a community member of MySQL, and a service provider, I am not worried about Oracle buying Sun and acquiring MySQL in the process. While it is theoretically possible that Oracle could decide to slow the growth of MySQL, it is not probable — if Oracle wanted to damage MySQL, Oracle would have caused a lot more damage a long time ago.

Active support for MySQL 5.0 ends soon

According to the official lifecycle calendar, active support for MySQL 5.0 (including regular binary updates) will end on December 31st, 2009. Upgrading to MySQL 5.1 is not difficult, though it requires more steps than just upgrading the packages. There is a link to a post which walks you through the upgrade.I hope this helps folks out, and please feel free to ask any questions. Pythian is available to assist you in the upgrade process, just contact us if you want to engage our help.

Today’s Perl Lesson

One thing I find fascinating in Perl is that I am always seeing new ways to perform the same mundane task. Today I had to output some tabular data, so I thought it would be nice if I alternated colors for each row. Easy enough in Perl—just create a hash with your colours as the value and then the swapping variable as the key, like this…

DBD::Oracle on AIX 5.1

I installed DBD::Oracle on an IBM AIX 5.1 box, and for once I have some good news. Anyone who has ever tried this will know of some of the troubles I speak of. When dealing with DBI and any DBD on a AIX box, you either must either be lucky enough to have the same compiler installed that built the version of Perl that comes with the box (I have never seen this happen); or you have to spend a great deal of time downloading and installing your own GCC and the building your own version of Perl. Fortunately, all the hard work was done for me by other members of my team. Here’s how to do it.

Perl CGI::param Overloaded Method?

This is a little story of a little bug. This gremlin suddenly appeared in a CGI.PM web-based application I work with. To make a long story short, an email was coming out something like this . . . I discovered that the page was in fact receiving three values for CGT::param(“rep_no”) when user was of type ‘B’, and thus sending that as an array to the send_TXT_email method, and as a result, buggering up the email content. Even more digging I found out the root cause was a web page that was three pages back from the one that was sending the email. Here’s the quick fix.

Page 57 of 61« First...102030...5556575859...Last »