Introducing SQLite for Mobile Developers

This brief book is an introduction to SQLite for both iOS and Android developers.  The book includes an optional introduction to SQL, a discussion of when to use SQLite,  and chapters devoted to using SQLite with the most likely programming languages and then goes through adding a simple database to an Android or iOS app and finally a chapter on managing the app’s life cycle.

What You Will Learn:

• The basics of SQLite
• The SQL you need to use SQLite effectively
• How to integrate a database into your mobile app.
• How to maintain the app

Who this book is for:

This book is for Android or iOS developers who wish to use a lightweight but flexible database for their applications. It mobile development experience but does not assume anything but very basic database knowledge.

Table of Contents

Chapter 1: Getting Up to Speed with Databases and SQLite
Chapter 2: Understanding What SQLite Is
Chapter 3: Using SQLite Basics: Storing and Retrieving Data
Chapter 4: Working with the Relational Model and SQLite
Chapter 5: Using SQLite Features—What You Can Do with SELECT Statements
Chapter 6: Using SQLite with PHP
Chapter 7: Using SQLite with Android/Java
Chapter 8: Using SQLite with Core Data (iOS and OS X)
Chapter 9: Using SQLite/Core Data with Swift (iOS and OS X)
Chapter 10: Using SQLite/Core Data with Objective-C (iOS and Mac)
Chapter 11: Using the Simple Database with a PHP Web Site
Chapter 12: Using the Simple Database with a Core Data/iOS App