Mac OS X, iPhone & Android Development
Archive for November, 2009
Numeraders 2.0 under development
Nov 21st
The very very popular Numeraders is getting a new look and feel, online hi-score list and special stages to give the most handy Numeraders pilot a real challenge. The current thinking is to get the game looking a bit more calculator-like, without looking like a calculator (hard to explain). The hi-score list will be maintained on a website for you to check out how you rank in the world.
But what we are really excited about are the “special stages” which break the continuous level-style game up with number sequences, count arounds and other fun number enhancements.
We hope to have it out before the end of the year – but if you have any suggestions – get them in now! (Just add comments here or email us)
LIKE % makes for a slow SQL search
Nov 10th
For those who don’t know, SQLite has a full text search module in the full distribution – but on the iPhone, it isn’t there. This means that you have to resort back to good old fashioned LIKE %word% in your SELECT statements. Because LIKE doesn’t speed up when using indexes (it is a full text compare) – it is fairly slow compared to a direct =
When planning your SQLite implementations on the iPhone, make sure you have your data structured in the best possible way for LIKE to fly over it!
Its a SQL weekend!
Nov 7th
For those keen on a bit of SQLite for iPhone (or whatever device), check out the http://sqlite.org website.
This is also quite interesting…
Is the iPhone online?
Nov 5th
For a current project, I needed to know whether an iPhone or iPod Touch was ‘online’. The code revealed itself in Reachability from the Apple Sample Code. Really really easy!
Add Reachability.m and .h to your project, define a Reachability class, and then add code like below to your project:
online = TRUE;
hostReach = [[Reachability reachabilityWithHostName: @"www.site.com"] retain];
NetworkStatus netStatus = [hostReach currentReachabilityStatus];
switch (netStatus)
{
case NotReachable:
{
online= FALSE;
}
}
If(online)
{
//Then do online stuff!
}