TopicObserver.com

Trond Pettersen on Web Development and Topic Maps

PHP is not Java but Java is not a Singleton

In a reply to my twitter rant about PHP’s lack of method overloading a while ago, I was pointed to PHP Advent 2008 / PHP is not Java by Luke Welling. The post discusses how PHP code may turn unnecessary complex by applying Java-style design to PHP code. Well, it tries to.

The point of the article is valid: you should definitively make use of the language’s built-in features instead of inventing your own. It uses a very bad example, though, and that’s what this rant is all about. Now, I am very late to the party here, but still want to point out the misconception.

Welling wrote:

In case you are not familiar with it, the singleton pattern is a general solution to many situations where you want only one instance of a particular class. [...]

class Singleton
{
    private static $myObject;

    private function Singleton()
    {
        // Providing a constructor to eliminate default public one.
    }

    public static function getInstance()
    {
        if (! isset(Singleton::$myObject) )
        {
            Singleton::$myObject = new MyObject();
        }

        return Singleton::$myObject;
    }

    private function __clone()
    {
    }
}

True.

An experienced PHP developer is much more likely to implement the same pattern as follows:

global $myObject;

if (!isset($myObject)) {
    $myObject = new MyObject();
}

False.

An experienced PHP developer would know that the Singleton pattern could still be used because it makes sure you only create 1 instance of the MyObject class. In Luke Welling’s example, you would always have to remember to check if there was an existing instance of $myObject available, else you’d end up with more than 1 instance of the class. Even worse: what if $myObject was not set, but MyObject had already been instantiated somewhere in your code? $myOtherObject, for instance? You could end up with $stillAnotherObject. More than 1 database connection, etc.

Hence, the experienced PHP developer would make use of the Singleton pattern, and do this instead:

global $myObject;

if (!isset($myObject)) {
    $myObject = Singleton::getInstance();
}

Or just

$myObject = Singleton::getInstance();

He’d then rest assured that even if MyObject had already been instantiated, $myObject would now reference the single instance.

(And I am still annoyed by the lack of method overloading in PHP5.x — it’s just stupid!)

Moving to Los Angeles

The reason why this place has been really quiet lately (and I haven’t found a VPS yet), is that I’ve been quite busy moving to, meeting relatives and interviewing for jobs in the US.

Luckily, the largest uncertainty is no longer an issue. Come May, I will be joining Yahoo! Music‘s team of great engineers!

In the future I promise not to blog about such stuff here, but if you are interested in what our lives are like in the US you might want to check out our new blog at living-in-the.us.

Downtime

We’re currently in the middle of moving to the USA. As a result, I’ve had to wave good bye to my fiber-enabled home.

I’ve unplugged my Ubuntu server, am changing web hosts and therefore expect this blog, and the recently re-launched billy-corgan.com (should now redirect here), to experience some downtime during the upcoming weeks.

Billy-Corgan.com Re-Launched as Topic Maps Based Website

Billy-Corgan.com was the first public web site I ever created and ran. I first started playing with it (and web techs) in 1998/99. In 2000, I moved it from GeoCities to its own domain name. The site had it’s golden age in 2003/2004, with up to 4 million page views / month. I believe that is a rather high number for a non-popish fan site. Back then it was a PHP/MySQL driven site.

In 2005 I decided to stop maintaining Billy-Corgan.com due to various reasons, the most prominent ones being a lack of time and a decreasing level of devotion (esp. with regards to the online community and drama that follows).

For the last 5 years the site has therefore contained little to no information. Up until 2 days ago, it did only contain the Machina II MP3s (Smashing Pumpkins released this album on the Internet, for free, back in 2000!). At the same time, there have been hundreds of daily visitors (Google Analytics stats). And the old MySQL database has been kept intact on my backup devices. Therefore, I recently decided to re-lauch the site with some of the “static” content (lyrics, discography, photos + MP3s as before). No need for it to remain empty, right?

Moving to Topic Maps

So: what to do when putting some old database content on the web? I did not want to create a huge new web site and spend a lot of time writing (plain) PHP scripts and SQL queries. Didn’t have time for that right now.

Well, obviously I chose to create a Topic Maps based web app, with Ontopia being my preferred Topic Maps engine.

I started by creating a couple of new database views (to make for a simpler mapping) and a few stored procedures for “sanitizing”  some of the data (used in the views’ SQL). From there, the remaining tasks were pretty simple:

  1. Create an LTM file (my preferred format) containing the ontology (concepts like Song, Person, Composer-Of, etc.). ~100 lines of LTM.
  2. Write a DB2TM mapping file, specifiying which columns are mapped to what Topic Maps concepts. 136 lines of XML.
  3. Write JSP files — as discussed in my previous post on Web App Development with Ontopia. Ended up with 10 specialized JSPs.

UI Functionality

I also wanted to add some “fun” functionality by creating an Ajax enabled photo gallery. I did explore some pre-built galleries such as Galleriffic, but ended up building my own using a combination of jQuery and jQuery cycle. The album degrades gracefully by not requiring JavaScript support — all links work without JS (example: 1979 vs. Zero).

Further, I implemented an audio “player” for the MP3s based on the HTML5 <audio /> element. At this time the browser support is very limited, though, as these are MP3s and not e.g. OGG. In the lack of MP3 audio support I fall back to using Flowplayer’s audio plugin (Flash based). I’ve also played with some CSS3 properties like border-radius, as seen on the index page (granted your browser supports either -webkit-border-radius, -moz-border-radius or border-radius (why so many?)).

The result can be viewed at Billy-Corgan.com.

MySQL BLOB to File in 20+ Lines of PHP Code

One of the nice things about PHP is how extremely quick it is to hack together a script that will save your day.

Today, I needed to throw together a script for converting some images stored as BLOBs in an old MySQL database of mine, to JPEG files stored on the file system (obviously, I knew that my database only contained JPEGs). It was a one time job, and so I set out to create a quick and dirty script to get the job done.

The job only took me about 20 lines of code, due to PHP’s built-in MySQL support and file handling support. I’ve cleaned it up a bit before posting it here, though, so now it takes a whole lot of 27 lines due to the verboseness of the somewhat cleaned up code.

In cases like this, hard coding the DB credentials and directory paths wont make me loose sleep. Neither does doing it the procedural way. The script did it’s job, and I got what I wanted … without spending a single calorie too much.

<?php
$conn = mysql_connect('localhost', 'myuser', 'mypass');
mysql_select_db('mydb', $conn);

// returns rows of id, img_name and img_data
$sql = 'select * images';
$queryResult = mysql_query( $sql, $conn );

while( $row = mysql_fetch_object( $queryResult )) {
	processRow( $row );
}

mysql_close($conn);

function processRow( $row ) {
	$basedir = 'images/';
	$imagename = makeSafeImageName( $row->img_name );
	// in my case, file names are not unique, so I add the id
	$filename = $basedir . $imagename . '-' . $row->id . '.jpg';
	file_put_contents( $filename, $row->img_data );
	echo 'done dumping ' . $filename ."\n";
}

function makeSafeImageName( $source ) {
	return strtolower(preg_replace('/([^\w\d\-_]+)/', '-', $source));
}
?>

(Execute from command line with php my-script.php, or web server).

Readable Code: In the Eye of the Beholder?

In his most recent blog posting – In the Eye of the Beholder (ah, reminds me of EoB II), JavaScripter James Padolsey (if you do some JavaScripting / jQuery, follow his blog) argues that the readability of anything is entirely dependent on who’s doing the reading. He also states that readability depends on how proficient the reader is in the given programming language.

I tend to disagree. Readability and understanding are two separate concerns. Readability is about aesthetics. Understanding is about knowledge. Code can be understood without being classified as “readable”.
Read the full post »

What I Like About C#

Coming from the Open Source world I had never really worked with .NET – except for some minor Sharepoint 2007 stuff – until last September. That’s when I joined a project maintaining a .NET application written in C#.

Since I had previously worked with Java, becoming a (visiting) C# developer wasn’t that much of a leap. After all, C# was partly influenced by Java (learning new frameworks did of course impose some learning curve, but that’s of course independent of language).

C# has some nifty features that Java lacks, though. In many ways, it feels like a more modern language — pardon me for saying so! :D

What follows are some of the things that I’ve started to like about C#.
Read the full post »

  • RSS @twitter

    • Could not connect to Twitter
  • Tags

  • Topics

  • Recent Comments

  • Topic Map Feeds