I have an iPhone app that will store data in a database. The data is basically locations, activities you can do at those locations and text about the activities.
eg In Florida you can scuba dive at these locations and here's some info on scuba diving in Coral Key.
The user drills into the application to get to the information:
Florida > Scuba diving > Coral Key > Information
A quicker way to get to this information would be via a full text search.
eg user types "florida coral key scuba" and goes straight to the information - kind of like a Google search result for the site with the most relevant results at the top.
Is this possible on an iPhone with SQLite?