Build iOS Database Apps with Swift and SQLite

✍ Scribed by Kevin Languedoc

• Publisher: Apress
• Year: 2016
• Tongue: English
• Leaves: 212
• Category: Library

✦ Synopsis

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.

✦ Table of Contents

Front Matter....Pages i-xxi
Creating the Objective-C Wrapper....Pages 1-10
Creating SQLite Databases....Pages 11-24
Creating Databases During Runtime....Pages 25-44
Altering Databases and Other Features....Pages 45-62
Inserting Records....Pages 63-87
Selecting Records....Pages 89-112
Updating Records....Pages 113-130
Deleting Records....Pages 131-144
Searching for Records in SQLite....Pages 145-159
Working with Multiple Databases....Pages 161-173
Backing Up SQLite Databases....Pages 175-185
Analyzing SQLite Databases....Pages 187-196
Back Matter....Pages 197-200

✦ Subjects

Apple and iOS;Programming Techniques;Programming Languages, Compilers, Interpreters;Database Management