iPhone Database Programming Exercises: SQLite

by Norman McEntire

This book is about iPhone database programming. It provides a set of hands-on, step-by-step exercises.

The goal is to help you learn and master iPhone database programming quickly and easily.

Native iPhone OS database applications make use of the embedded SQLite database engine framework. Hence, learning iPhone database programming is learning how to use the embedded SQLite database engine.

The hands-on nature of these exercises is unique. True learning happens when you take action by performing hands-on exercises. That is what this book is about.

Here are the key iPhone Database Programming skills that you will

- SQLite Framework (/usr/include/sqlite3.h, libsqlite3.dylib)
- SQLite Datatypes (NULL, INTEGER, REAL, TEXT, BLOB)
- SQLite Functions (sqlite3_open(), sqlite3_exec(), etc.)
- SQL Syntax (CREATE TABLE, INSERT INTO, etc.)
- Navigation-based Application (UITableViewController, UITableView, etc.)

Is this book for you? To find out, perform these two steps.

Step 1. Scan the Table of Contents, reading the title of each exercise. Each exercise focuses on a specific skill, and if the exercises look interesting to you, then this book is for you.

Step 2. Read through the first Exercise, and see if the clear, step-by-step instructions make sense to you. If so, then this book is for you.

If you have access to a Mac OS X system, along with the iPhone OS SDK (Software Developers Kit), then you can read each exercise, and perform each step, using the iPhone OS SDK.

However, even if you do not have a Mac OS X system with the iPhone OS SDK, you can still read and follow along "in your mind". When you do have access to a Mac, you'll know exactly what to do.

CONTENTS

About This Book

Exercise 1. Navigation-based App

Exercise 2. /usr/include/sqlite3.h

Exercise 3. sqlite3_libversion()

Exercise 4. libsqlite3.dylib

Exercise 5. sqlite3 Datatype

Exercise 6. sqlite3_open()/sqlite3_close()

Exercise 7. sqlite3_exec() - CREATE TABLE

Exercise 8. sqlite3_free()

Exercise 9. sqlite3_prepare_v2(), sqlite3_finalize() - SELECT

Exercise 10. sqlite3_step()

Exercise 11. StudentViewController (.h, .m, .xib)

Exercise 12. sqlite3_exec() - INSERT

Exercise 13. Student (.h, .m)

Exercise 14. UITableViewCell

Exercise 15. sqlite3_exec() - DELETE

Exercise 16. sqlite3_exec() - UPDATE

sqlite3 Framework

sqlite3 Internal Datatypes

sqlite3 Functions

sqlite3 Error Codes

SQL

47 pages, Kindle Edition

First published March 1, 2010