title: “Code4PizzaCollator: The first push.” date: 2010-01-10 tags:

- “code4pizzacollator”

An excellent day of coding today as I spent the day hooking up the database storage to the iPhone.  This was all new to me but there’s some good documentation out there.  I used some sample code from Bill Dudney and Chris Adamson’s book “iPhone SDK Development” so I could get used to using SQLite (cos I’m a MySQL kinda guy).The most useful thing I learned today….. the way that the SDK will copy the SQLite database to a WHOLE new place.  Turns out the insert code was working fine I just didn’t know where it was going.NSArray *searchPaths = NSSearchPathForDirectoriesInDomains (NSDocumentDirectory, NSUserDomainMask, YES); NSString *documentFolderPath = [searchPaths objectAtIndex: 0]; dbFilePath = [documentFolderPath stringByAppendingPathComponent: DATABASE_FILE_NAME];NSLog(documentFolderPath); is your friend.So it’s all coming along nicely, the first commit went up to github this afternoon so other people can have a play with it (assuming that you’re all bored with the snow now).  The next job is to bundle up the saved locations and send them to a server (somewhere to be decided).  There’s plenty of resources on getting an iPhone app to pull JSON data in from a URL but not a lot about transmitting it.  This is going to be fun :)