Build iOS Database Apps with Swift and SQLite

This book leads you through the essential concepts and new iOS 10 SDK and Swift 3 programming language APIs to build iPhone and iPad database driven applications using the defacto standard for data storage for mobile apps, SQLite.

Readers will learn about 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 using Objective-C and Swift.

With Build iOS Database Apps with Swift and SQLite you will also gain expert knowledge on how to create databases at runtime, including creating or modifying indexes, triggers, tables, columns, and views. The examples use time-tested code from working applications.

What You’ll Learn

• How to create database and database applications using iOS and Swift
• How to insert, select, edit, and delete records
• How to extend SQLite
• How to work with multi-database apps
• How to use SQLite with Swift
• How to backup online SQLite Databases and more

Who This Book Is For 

Experienced Apple iOS, Swift programmers and developers.

Table of Contents

Chapter 1: Creating the Objective-C Wrapper
Chapter 2: Creating SQLite Databases
Chapter 3: Creating Databases During Runtime
Chapter 4: Altering Databases and Other Features
Chapter 5: Inserting Records
Chapter 6: Selecting Records
Chapter 7: Updating Records
Chapter 8: Deleting Records
Chapter 9: Searching for Records in SQLite
Chapter 10: Working with Multiple Databases
Chapter 11: Backing Up SQLite Databases
Chapter 12: Analyzing SQLite Databases