Chapter 16Data Persistence Using SQLite

Key Skills & Concepts

• Creating a database and adding data to it

• Including the database in Xcode

• Reading from a database

• Making a database writable

• Inserting a record

• Updating a record

• Deleting a record

The SQLite database is a popular open-source database written in C. The database is small and designed for embedding in an application, unlike a database such as Oracle that was designed to run on a separate, large server. SQLite is part of the standard open-source Linux/BSD server stack, and as OS X is essentially FreeBSD, it was only natural Apple chose SQLite as the iOS’s embedded database.

Adding a SQLite Database

Adding a SQLite database to your project involves two steps. First, you must ...

Get iOS SDK Programming A Beginners Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.