Tags
Author Archives: pixelbyter
optimising MySQL server
Over the weekend the Real World web sites went down following a torrent of visitors with the imminent release of Peter Gabriel’s Scratch My Back, which played havoc on our MySQL databases and downed our websites. Our connections maxed out and started to queue, causing any pages requiring a DB connection to refuse to load. [...]
developing iTunes LPs/iTunes Extras for the AppleTV
Apple’s ‘hobby’ TV unit, AppleTV, is a rather limited platform in terms of interactability and processing power. After getting my hands on a unit for testing iTunes LPs on, I was shocked at the changes necessary in order to make an LP work on this medium. This article does not cover the information outlined within [...]
Posted in Uncategorized Tagged AppleTV, iTunes Extras, iTunes LP, Javascript, source code Leave a comment
Actionscript 3 draggable objects and kinematics example
I wrote this example a couple of years ago while researching Actionscript 3, inverse kinematics and the mathematic principles behind motion. I’m currently porting it to a CSS3 example.
Get the Flash source files here.
The following Actionscript 3 snippet is the bread and butter of the code that makes the above example possible:
//calculates angle of centre
var [...]
mysqldump database backup for mixed InnoDB and MyISAM tables
Backing up a collection of MyISAM and InnoDB tables within a database via mysqldump can cause problems. MyISAM tables require locking, whereas InnoDB tables need to remain unlocked and can also take advantage of single transactions to speed up the backup process. I decided to write the following PHP script to list all of the [...]
iTunes LP/Extras Javascript redirects
For iTunes LP and iTunes Extras content programatically loading a link is very difficult. Both iTunes and AppleTV don’t support the Javascript function windows.open() or the property window.location. I’ve managed to come up with this bypass (aka hack) which is demonstrated in the Javascript code below. It triggers a mouse click event emulating the user [...]
Scratch My Back iTunes LP