If you go to mysql5.0 (same with mysql5.1) you will notice a list of MySQL binaries for Mac OS X. If you are using Leopard (10.5) and you want to compile PHP with MySQL then DO NOT use the 10.5 binary. There is a reason why the 10.4 binary is twice the size of the 10.5 one...it's because the 10.5 binary does not have the dev libraries that allow PHP to compile against it (well, I kept getting the same error message about missing symbols...).
It seems quite bizarre to put these packages together in the same place on the MySQL site as they represent different things.
Michael Gawenda was on ABC 774 radio this morning talking about his lecture this evening about news and newspapers.
He had some really interesting points about how the web is awash with commentry and analysis and because of this that's not what newspapers should be focusing on. He was also suggesting newspapers can still exist in print in some form, but they need to start making money from their online content. I think perhaps for some specialised information some people might pay, but I think newpapers have made a mistake. The thinking in the past was, let's get news online, make it free, get a large readership, then make money out of that at some point in the future (of course now they do have ads). But once you put something on the web and make it free, then people expect it to be free, and you're not going to succeed if you suddenly start charging money for it. People will go elsewhere.
Ok, I just re-ran my speed tests using what I assume is a more reliable speed test site, at least it's local, www.ozspeedtest.com. The site even has a mobile version.
So the iPhone using the wifi network got 2400kbps (a lot more than on the previous test!) and the iPod Touch got 5680kbps. Hmm, so overall the speeds recorded are a lot higher than the other night, however the iPod Touch is still much faster than the iPhone.
Using 3G at this location I got 1420kbps, pretty decent. And using GPRS I got 42kbps (to be expected).
FIrst of all, if you want to get your app onto an actual iPhone, you need to register for Apple's iPhone Developer Program. This cost me $120 AUD.
The first thing you have to do is download and install the iPhone SDK. If your device is running 2.1.1 of the iPhone OS, you need to read the iPhone OS - Pre-Installation Advisory (one of those boring docs you wouldn't normally read) which tells you to create a symbolic link from 2.1.1 to 2.1. You can read it yourself for the exact details.
Then you have to stuff around getting a few certs onto your system and into Keychain Access.
Then you have to register your device (I'm just using my iPod Touch to develop on), register an App ID (whatever that is), then create a provisioning profile. There's a trick here, and again you have to read the how-tos on the site carefully - when creating the App ID you use a syntax like com.yoursite.nameofappid. However you can also use a wildcard format in which case the ID looks like com.yoursite.*. But then it says, "For iPhone OS 2.0 development, use a wild-card App ID for all of your applications." So, ok, for iPhone OS 2.0+ development you must use the wildcard format.
I have an iPhone and an iPod Touch sitting next to each other, both connected to my wifi network. Running a speed test shows about 1500kbps on the iPod Touch, and less than 400kbps on the iPhone! What's the explanation? Is it too fat and therefore interfering with the signal? The wifi router is 2 rooms away...so I tried it standing right next to it but it wasn't any faster.
On GPRS the speed on the iPhone was 38kbps, and on 3G the speed was 340kbps (I don't seem to have great 3G reception here, but hey, it's almost as good as wifi!).
So the conclusion is, when I'm sitting on the toilet surfing the web, use the iPod Touch and not the iPhone!
Also, after a great deal of messing around (including paying $120 for a developer's certificate from Apple), today I deployed two apps ("Hello iPhone!" and "Button") to my iPod Touch! :)