Introducing SQLite for mobile developers : enabling database functionality for Android and iPhone

1. Getting Up to Speed with Databases and SQLite.-2. Understanding What SQLite Is ... -- 3. Working with the relationship model and SQLite -- 4. Using SQLite basics -- storing and retrieving data.-5. Using SQLite features -- What you can do with SELECT statements.-6. Using SQLite with PHP.-7. Using SQLite with Java (Android) -- 8. Using SQLite with Swift (iOS/Mac) -- 9. Using SQLite with Objective-C (iOS/Mac).-10. Exploring the simple database (used in chapters 10-12) -- 11. Using the simple database with a website (database example code included) -- 12. Adding the simple database to an Android app (using android.database.sqlite) -- 13. Adding the simple database to an iOS app (using Core Data) -- 14. Considering performance issues -- 15. Managing the SQLite life cyle.;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. 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ĺls 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 Front Matter....Pages i-xvii Getting Up to Speed with Databases and SQLite....Pages 1-7 Understanding What SQLite Is....Pages 9-14 Using SQLite Basics: Storing and Retrieving Data....Pages 15-27 Working with the Relational Model and SQLite....Pages 29-38 Using SQLite Features—What You Can Do with SELECT Statements....Pages 39-43 Using SQLite with PHP....Pages 45-54 Using SQLite with Android/Java....Pages 55-60 Using SQLite with Core Data (iOS and OS X)....Pages 61-73 Using SQLite/Core Data with Swift (iOS and OS X)....Pages 75-95 Using SQLite/Core Data with Objective-C (iOS and Mac)....Pages 97-120 Using the Simple Database with a PHP Web Site....Pages 121-134 Using the Simple Database with a Core Data/iOS App....Pages 135-144 Back Matter....Pages 145-147