Link Catchup

That’s what weekends will do to you: you miss stuff! Here’s a few things I’ll be reading tonight.

How HCI Killed Open Source

Great article and comic from usability guy, Tom Chi.
Brilliant comments too and so many quotables you should just read through them yourself. In an optimistic mood, I like to think there’s some way this could be solved:

OSS programmers are often just hacking in their free time because their day-jobs aren’t satisfying their desire to write strong code. So for those people, they’re coding as a hobby, not as a job, which makes it difficult to impose un-fun constraints on them like listening to a non-programmer (oh the humiliation) as to why their software isn’t usable. The trick here is to find a way that good HCI can mesh with the OSS mentality and development model. Any suggestions?

Like most things done “in their spare time”, things are far from perfect. When was the last time you cut the hedge so it was exactly straight, or washed and polished the car until it gleamed so much you could see your reflection in it – from 10 feet away? We need the hedge cutting and car washing professionals to join us in our spare time hobbies. Such a collaboration can only benefit both groups!
And if that site had permalinks to the comments I’d probably be linking to several of them. oh well, more usability work to be done! 🙂

Batmans Begins – bah, crap trailer, looks good!

Me being a big Batman fan, I just took at look at the Batman Begins trailer. It wasn’t great, you don’t get much of a look at the Caped Crusader, but it does give you a taste for the story I suppose! Nice Batman logo! Oh and wget this link if you want to download the trailer in QuickTime format. That at least is friendlier than the wmv format to Mplayer but don’t forget to download the QuickTime codecs to play it!

b2++ Updates

Regular visitors to this site will have noticed that this blog and others on the server take an inordinate amount of time to display sometimes. Basically, this machine is unfortunately under-powered but we’re working on making the best of use of the available hardware with some changes to MySQL and Apache and to b2++ too. Here’s what I did this morning:

  • Referers are checked and only if requests go to either “/”, “index.php” or “archive/” are they recorded.
  • Referers are now recorded using INSERT DELAYED.
  • I added keys on the post_date and post_category fields in *posts tables. The main SELECT is now a “range” instead of “all” request.

Here’s a short bash script you can use to update your db. Remember to change “username” and “password” to suit your own setup.

for i in `echo show tables | mysql -u username -ppassword b2|grep posts`; do echo "ALTER TABLE \`$i\` ADD INDEX ( \`post_category\` )"| mysql -u username -ppassword b2; echo "ALTER TABLE \`$i\` ADD INDEX ( \`post_date\` )"| mysql -u username -ppassword b2; done

Useful links: Mysql Optimization | Optimizing MySQL: Hardware and the Mysqld Variables (mentioned previously) | MySQL Optimisation and a few other pages.