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 ...