Stuff
Thursday, July 31st, 2008Apologies for the cruddy title but I really couldn’t think of a better one, but I did only get up in the last half-hour.
Today’s comics are updated, plus eagle-eyed readers will notice a new comic: Sporkman. Night before last, John Troutman - artist behind Flat Feet & High Heels, as well as Sporkman - dropped me an email, asking if I’d like to take on Sporkman here at WordOwl.
I did ask a couple of questions, and John fired back some really useful answers to them, the most important of which is that I have a colour reference for just about every character in the strip, so I can colour up the strips nicely.
So as of today Sporkman has joined WordOwl.
I’m annoyed at myself I only got 17 strips in yesterday, but there is a reason behind that. As I go along transcribing, I periodically update the development server with the latest strips, make sure everything works how it’s meant to. And for some reason the entire character searching system was broken on Sporkman.
To give you an example, I have 17 strips, 14 of which feature Sporkman in some capacity, and yet searches for Sporkman himself were throwing out all 17 strips.
After routing through thousands of database records, hundreds of lines of code and writing new debug code into it all, I finally figured out what was going on. For those of you who understand SQL, the problem was a JOIN between two tables that wasn’t specific enough.
In English, I have a list of characters and a list of text entries that they say. The name entry is the same as what you see on the search page (a name, possibly just the first name in some cases). But if you have two comics with characters with the same name, there is going to be cross-over: I have characters called Amanda and Rob in both Sporkman and Flat Feet, and both were getting messed up because of it.
Once I’d waded through all this for about 3 hours I finally fixed it, but it meant that was 3 hours I didn’t get to transcribing. I’ve also been looking at upgrading Sphinx now that the final release of 0.9.8 is out, just to take up more time.
So all in all I’m a bit annoyed at myself for not getting as much done as I would have liked.
Lastly, I’d just like to throw a shout-out to Blank It, one of the youngest strips in WordOwl. Created by Aric McKeown and Lemmo Pew (of Ashfield and Lethal Doses fame respectively), Blank It is a nicely refreshing comic. Lemmo, the artist, said some very nice things about WordOwl in the blog, which I really appreciate. It’s stuff like this that makes me feel good about working on WordOwl - it is coming from the creator after all. So, everyone who has a few minutes for some good comic humour, please head over to http://blankitcomics.com/
If I keep getting praise like that, I might even end up making a Praise page.
Plan of Action today is unfortunately not comic related. A small dose of shopping followed by a larger dose of visiting family.

hopeful

content