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.
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.
Height:
Width:
Spine:
Weight:0.00