Archive for October, 2009

Installing Facebook Open Platform on Fedora 8

October 3rd, 2009

This is a step by step I wrote ages ago whilst installing Facebook Open Platform on Fedora 8. I did the FBOP working in the end, although found little to no use for it – there were parts missing (mainly the fbml form parser) so I couldn’t get it set up to create a local facebook testing environment, which is what I wanted to do. I haven’t developed a Facebook App for a while, so I’m not sure if they’ve made any ground releasing a more complete version of the open platform.
» Read more: Installing Facebook Open Platform on Fedora 8

Ordinal Suffix PHP Function – Convert integer to ordinal suffix

October 3rd, 2009

Here’s a function to get the ordinal suffix of an integer in PHP.
» Read more: Ordinal Suffix PHP Function – Convert integer to ordinal suffix

Efficiently Truncate InnoDB Tables

October 1st, 2009

I was sent a great article today on performance tuning for MySQL’s InnoDB Storage Engine.

I thought the last point was particularly interesting – I always thought that a TRUNCATE TABLE was always better than a DELETE FROM as it can just drop all the data without looking at each individual row – apparently that’s not the case and they’re pretty much equivalent for InnoDB.
» Read more: Efficiently Truncate InnoDB Tables