How To Develop iOS Database Apps using SQLite
How To Develop iOS Database Apps using SQLite
$9.99
Minimum price
$19.99
Suggested price
How To Develop iOS Database Apps using SQLite

This book is 100% complete

Completed on 2019-02-24

About the Book

How To Develop iOS Database Apps using SQLite leads you through the essential concepts and APIs to build iPhone and iPad database driven applications using the defacto standard for data storage for mobile apps, SQLite.

The book covers the SQL operations like selecting, inserting, updating and deleting data using various data types like text, numerical types, images and even audio/video data. After working through this book, you will gain an expert view of developing iOS apps using SQlite as a data storage uisng Objective-C and Swift.

You will also gain expert knowledge on hoe to create database at runtime, including creating or modifying indexes, triggers, tables, columns and views. The examples use time-tested code from working applications.

Here are what readers are saying:

Thanks very helpful!

From Mike

this is a great tutorial! I am curious - can you add a search function to this?

From Max Ravi, Pune India 

Thanks for your book, keep adding such content.

About the Author

Kevin Languedoc
Kevin Languedoc

Kevin Languedoc is a software developer with 20 years of solid database development experience. He has worked with all major platforms and technologies in his long and varied career. He brings his expertise in database development to iOS (iPhone and iPad) platform and SQlite. He has developed over 50 iPhone and iPad apps in the corporate level for clients of all sizes. He brings a wealth of practical experience to this book with extensive code samples and working apps.

Packages

The Book
  • English

  • PDF

  • EPUB

  • MOBI

  • APP

$9.99
Minimum price
$19.99
Suggested price
Book & Code

This package includes the book, How to Develop iOS Database Apps using SQLite as well as the code and apps from the book.

Includes:

  • extras
    Code and Apps

    Here are the code and apps from the book

  • English

  • PDF

  • EPUB

  • MOBI

  • APP

$29.99
Minimum price
$49.99
Suggested price
The Definitive Collection

This ultimate collection includes the How to Develop iOS Database Apps using SQLite and the code listings from the book and in addition the complete source code (Xcode project for iOs 9.3) for an iPhone app titled DB Man that is completely written in Swift 2.2 along the a 25 page booklet explaining in detail how the app was built.

Includes:

  • extras
    Code and Apps

    Here are the code and apps from the book

  • extras
    SQLite Swift 2.2
  • English

  • PDF

  • EPUB

  • MOBI

  • APP

$49.99
Minimum price
$69.99
Suggested price

Table of Contents

  • Introduction
  • Creating Databases
    • Pre-Build a Database
    • Build at Runtime
    • Conclusion
  • Updating an iOS SQLite Database
    • SQLite Queries
    • Develop the SQLite iPhone Application
  • Inserting Records
    • Insert Overview
    • Insert Text and Numbers
    • Upsert Text and Numbers
    • Insert Binary Data
    • App: Store Binary Data in an iPhone SQLite Database App
  • Selecting Records
    • Selecting data
    • Using a dynamic WHERE clause
    • Perform a SELECT using a Sub-Query
    • Perform a SELECT using Joins
    • Select and Display Images
    • Select and Display Audio Records
    • Select and Display Video Records
    • Selecting Data from a Multi-Database
    • Browsing Data
    • Conclusion
  • Updating Records
    • Introduction
    • Update Records with Objc and C
    • Update ON Conflict
    • The Update SQLite Database App in iOS
    • Conclusion
  • Deleting Records
    • The DELETE Statement in SQLite
    • Using the WHERE Keywords
    • Delete from Database iOS App
    • Conclusion
  • Extending SQLite
    • Creating Functions
    • Attaching Function to Database
    • Using Your Function in a SQL Query
  • Multi Database Apps
    • The basics
    • Building Multi-Database Queries
    • Conclusion
  • Using SQLite with Swift
    • Setup the Project
    • Add SQLite library
    • Build the Bridge
    • Configure The Swift Compiler
    • Build Phases
    • The SQLiteDAO.swift Code
    • The View Controller Implementation
    • Build the UI
    • Conclusion
  • Backup Online SQLite Databases
    • The Backup App
    • The View Controller Header
    • Conclusion
  • Appendix

The Leanpub 45-day 100% Happiness Guarantee

Within 45 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

See full terms

Free Updates. Free App. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers), EPUB (for phones and tablets), MOBI (for Kindle) and in the free Leanpub App (for Mac, Windows, iOS and Android). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

Authors, publishers and universities use Leanpub to publish amazing in-progress and completed books and courses, just like this one. You can use Leanpub to write, publish and sell your book or course as well! Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks. Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. It really is that easy.

Learn more about writing on Leanpub