Using SQLite in Your iOS Apps
This is a meat-and-potatoes introduction to using SQLite in your iOS apps without importing an external framework. This course will teach you why you would do it, and it builds an app in steps.
What you'll learn
SQLite is a fast, reliable, and flexible embedded SQL database engine with a C API that works on iOS, Android, macOS, and other operating systems. In this course, Using SQLite in Your iOS Apps, you'll learn how to build an app that uses the SQLite engine for data cache and will strive for independence by calling the SQLite API directly from Swift 3. First, you'll explore prototyping SQL queries in the command line. Next, you'll discover how to execute SQL queries with the SQLite API in a custom data cache. Then, you'll learn how to write and use custom SQLite functions. Finally, you'll be working with SQLite in a multithreaded environment. By the end of this course, you'll know how to write your own SQLite caches for your apps and how to use some advanced features of the SQLite engine.
Table of contents
- Introduction 1m
- Creating the Database 2m
- SQL INSERT Statement 0m
- SQL SELECT Query 1m
- SQL UPDATE and DELETE Statements 1m
- Demo - Creating the Database in the Command Line 2m
- Demo - Inserting Rows in the Command Line 1m
- Demo - Selecting Rows in the Command Line 1m
- Demo - Updating and Deleting Rows in the Command Line 1m
- Summary 0m
- Introduction 1m
- Interfacing Swift with SQLite C API 1m
- SQLite Database Handle 1m
- Updating with the SQLite Database Handle 0m
- SQLite Statement Handle 1m
- ErrandsCache - Intro 1m
- ErrandsCache - Initializing 1m
- ErrandsCache - Opening and Closing Database Handle 1m
- ErrandsCache - Inserting Errands 2m
- ErrandsCache - Selecting Multiple Errands 2m
- ErrandsCache - Selecting Multiple Errands (cont'd) 2m
- ErrandsCache - Selecting Specific Errands 1m
- ErrandsCache - Updating and Deleting Errands 1m
- ErrandsCache - Summary 0m
- Introduction 1m
- Tagging Feature Overview 1m
- Schema for Tagging Feature 1m
- Demo - Tags Table Queries 1m
- SQL 'IN' Operator 1m
- SQL Nested SELECTs 1m
- Demo - Tag Filtering Queries 1m
- Demo - Tag Filtering Queries (cont'd) 1m
- Code - New ErrandsCache Methods Needed 1m
- Code - Assigning and Querying Tags 1m
- Code - Tags for a Particular Errand 0m
- Code - Filtering Errands by Tags 1m
- Demo - New Feature Live 1m
- Summary 0m
- Introduction 1m
- Distance Filtering Feature Overview 1m
- Some Built-in SQL Functions 1m
- How SQL Functions Are Used 1m
- Custom SQLite Functions Intro 1m
- Code - Distance Filtering Custom Function 1m
- Code - Distance Filtering Custom Function (cont'd) 1m
- Code - Demo - Completed Distance Filtering 1m
- Summary 0m
- Introduction 0m
- Errand Manifest Feature Overview 1m
- JSON Review/short Introduction 1m
- JSON for the Errand Manifest 1m
- Using JSONSerialization 1m
- Using SQLite JSON1 1m
- Activating JSON1 and Saving JSON in ErrandsCache 1m
- Using JSON1 to Unpack the Manifest 1m
- Demo - The Manifest in Action 1m
- Summary 0m
About the author
Chris has been an iOS developer for five years and a software developer for 30+ years. Along the way he's been an adjunct college instructor, PHP/server developer, done some HTML/Javascript/CSS development and gotten an advanced degree and a half in visual perception. He's been around the block a few times and has learned a thing or two about best practices and will try to model those best practices in his content.