Book Image

Learning SQLite for iOS

By : Gene Da Rocha
Book Image

Learning SQLite for iOS

By: Gene Da Rocha

Overview of this book

The ability to use SQLite with iOS provides a great opportunity to build amazing apps. Apple's iOS SDK provides native support for SQLite databases. This combination offers the potential to create powerful, data-persistent applications. This book starts with the architecture of SQLite database and introduces you to concepts in SQL . You will find yourself equipped to design your own database system, administer it, and maintain it. Further, you will learn how to operate your SQLite databases smoothly using SQL commands. You will be able to extend the functionality of SQLite by using its vast arsenal of C API calls to build some interesting, exciting, new, and intelligent data-driven applications. Understand how Xcode, HTML5, and Phonegap can be used to build a cross-platform modern app which can benefit from all these technologies - all through creating a complete, customizable application skeleton that you can build on for your own apps.
Table of Contents (15 chapters)
Learning SQLite for iOS
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface
Index

Extensions to the C API


SQLite binding functionality extends the popularity and diversity of the SQLite language, but it is not supported by the core developers of the database. Instead, the SQLite community takes care of these integrations, and is well-documented online. Scripting languages, such as Perl, PHP, and Python or Java, work nicely with SQLite.

The C API interface specification for SQLite has several interface elements and can be grouped into the following categories:

  • Category one has a list of objects and datatypes utilized by the SQLite library. There are over a dozen objects and datatypes in it. The most meaningful and common ones are the database object called sqlite3 and the prepare statement called sqlite3_stmt.

  • Category two will have its list of constants used by SQLite and are referenced by the usage of the #defines syntax in the sqlite3.h header file. These are standard constants, such as SQLITE_OPEN_READONLY.

  • Category three is a list of all the functions available and the...