O'Reilly logo

Beginning iPhone® SDK Programming with Objective-C® by Wei-Meng Lee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12. Database Storage Using SQLite3

WHAT YOU WILL LEARN IN THIS CHAPTER

  • How to use the SQLite3 database in your Xcode project

  • How to create and open a SQLite3 database

  • How to use the various SQLite3 functions to execute SQL strings

  • How to use bind variables to insert values into a SQL string

In the previous chapter, you learned about data persistence using files. For simple applications, you can write the data you want to persist to a simple text file. For more structured data, you can use a property list. For large and complex data, it is more efficient to store them using a database. The iPhone comes with the SQLite3 database library, which you can use to store your data. With your data stored in a database, your application can populate a Table view or store a large amount of data in a structured manner.

This chapter shows you how to use the embedded SQLite3 database in your applications.

USING SQLITE3

To use a SQLite3 database in your application, you first need to add the libsqlite3.dylib library to your Xcode project. Use the following Try It Out to find out how. You will need to download the code files indicated for this and the rest of the Try It Out features in this chapter.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required