iPhone
Dec 11th
After writing the article on iPhone SQLite Database Basics, I received lots of followup questions and comments, some of which I will discuss here.
SQLite Database CreationIn my first article I wrote that the easiest way to work with SQLite databases on the mac was the SQLite extension for Firefox.
Since then, my attention has been brought to Menial’s Base application. This is the application that I now use for all of my SQLite work. It is super fast, and has an interface that is extremely easy to use. It also has a lot of nice touches that make it more Mac-like than using a Firefox extension. If you’re doing SQLite work on the Mac, I strongly recommend that you check it out.
Making a Writable Copy of the DatabaseIn the first part of this tutorial, I mentioned that if you needed to write to your database you needed to copy it to a location that you could write to.
A couple of people have asked how to do this. To answer that, I first want to talk a little bit about how to control SQLite access in Cocoa applications. There are really three ways to do this:
- Have DB access code in each class More >
Dec 8th
The Scriptures for the iPhone and iPod Touch version 1.1.0 is now available for download from the App Store. You can read about the changes here.
What happened to Landscape mode?Previous version of The Scriptures application had the useful (and expected) feature of being able to rotate the device to read in landscape mode. Unfortunately due to some technical issues, some of the new features in this version made this feature a bit buggy. Some of these issues were design related, others have to do with a known bug regarding how the iPhone SDK handles rotations.
Rather than deliver a substandard user experience, I have pulled this feature until I can fix the issues associated with it.
Oct 2nd
In celebration of the lifting of the NDA on the iPhone SDK, I decided to write a tutorial on using SQLite on the iPhone.
This tutorial covers the basics of SQLite database creation, things to consider in the design of the database, and some particular things to be aware of when deploying these types of applications to the iPhone.
Once you have finished with these basics, take a look at the SQLiteBooks sample code from the iPhone dev center for details on how to interface with the database from your code.
Step 1: Create a SQLite Database FileThere are lots of ways to create a SQLite database file. The easiest way that I have found is to download the SQLite Firefox extension, which provides a GUI to create and manage your SQLite database. The rest of this tutorial will assume you have that extension installed.
In this tutorial we’ll be creating a recipe application, so we are naming our database “recipes”.
To create the database:
- Click the “New Database” toolbar button.
- Enter the name of the database file.
- Click OK.
You will then be prompted for a location to save the database. The ideal place is in the directory of your XCode project.
Step 2: Create the Database SchemaNow More >