Skip to main content
SpringerLink
Log in
Apress
Book cover

Introducing SQLite for Mobile Developers

  • Book
  • © 2015
Download book PDF
Download book EPUB

Overview

Authors:
  1. Jesse Feiler
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Covers the basics of SQLite and SQL
  • For developers of Android or iPhone apps of all levels
  • Covers specifics for Java, PHP, Swift and Objective-C programmers

Buy print copy

Softcover Book USD 29.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Table of contents (12 chapters)

  1. Front Matter

    Pages i-xvii
    Download chapter PDF

  2. Getting Up to Speed with Databases and SQLite

    • Jesse Feiler
    Pages 1-7
    Download chapter PDF

  3. Understanding What SQLite Is

    • Jesse Feiler
    Pages 9-14
    Download chapter PDF

  4. Using SQLite Basics: Storing and Retrieving Data

    • Jesse Feiler
    Pages 15-27
    Download chapter PDF

  5. Working with the Relational Model and SQLite

    • Jesse Feiler
    Pages 29-38
    Download chapter PDF

  6. Using SQLite Features—What You Can Do with SELECT Statements

    • Jesse Feiler
    Pages 39-43
    Download chapter PDF

  7. Using SQLite with PHP

    • Jesse Feiler
    Pages 45-54
    Download chapter PDF

  8. Using SQLite with Android/Java

    • Jesse Feiler
    Pages 55-60
    Download chapter PDF

  9. Using SQLite with Core Data (iOS and OS X)

    • Jesse Feiler
    Pages 61-73
    Download chapter PDF

  10. Using SQLite/Core Data with Swift (iOS and OS X)

    • Jesse Feiler
    Pages 75-95
    Download chapter PDF

  11. Using SQLite/Core Data with Objective-C (iOS and Mac)

    • Jesse Feiler
    Pages 97-120
    Download chapter PDF

  12. Using the Simple Database with a PHP Web Site

    • Jesse Feiler
    Pages 121-134
    Download chapter PDF

  13. Using the Simple Database with a Core Data/iOS App

    • Jesse Feiler
    Pages 135-144
    Download chapter PDF

  14. Back Matter

    Pages 145-147
    Download chapter PDF
Back to top

Keywords

About this book

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.

About the author

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).






Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation