Introducing SQLite for Mobile Developers

Jesse Feiler is a developer, consultant, and author specializing in database technologies and location-based apps. He has worked with databases and data management on computers from mainframes to iPhone, iPad, and Apple TV using data management tools from DB2 (IBM) and DMSII (Burroughs) to Enterprise Objects Framework and Core Data, MySQL, Oracle, and, of course, MySQL. In the early days of the web, he built the page caching mechanism for the Prodigy web browser for Mac using a relational database library similar in some ways to SQLite. He is the creator of Minutes Machine the meeting management app, as well as Saranac River Trail app a guide to the Trail that includes location-based updates as well as social media tools. His apps are available in the App Store and are published by Champlain Arts Corp (champlainarts-dot-com). As a consultant; he has worked with small businesses and nonprofits on projects such as production control, publishing, and project management usually involving FileMaker. His books include: Swift for Dummies (Wiley, 2014) iOS App Development for Dummies (Wiley, 2014) iWork for Dummies (Wiley, 2012) He is heard regularly on WAMC Public Radio for the Northeast's The Roundtable. founder of Friends of Saranac River Trail, Inc. A native of Washington DC, he has lived in New York City and currently lives in Plattsburgh NY. He can be reached at northcountryconsulting-dot-com (consulting) and champlainarts-dot-com (app development).

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.