Expanded

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.
Course info
Rating
(10)
Level
Intermediate
Updated
Aug 18, 2017
Duration
1h 14m
Table of contents
Course Overview
Introduction and Sample App
SQLite, SQL, and the Command Line
Using the SQLite API
Adding a New Feature
Using Custom SQLite Functions
Using JSON in SQLite
Safe Multithreading in SQLite
Course Wrapup
Description
Course info
Rating
(10)
Level
Intermediate
Updated
Aug 18, 2017
Duration
1h 14m
Your 10-day individual free trial includes:

Expanded library

This course and over 7,000+ additional courses from our full course library.

Hands-on library

Practice and apply knowledge faster in real-world scenarios with projects and interactive courses.
*Available on Premium only
Description

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.

About the author
About the author

Chris is an iOS Developer, adjunct college instructor, PHP developer, former visual perception researcher and 30+ year software developer across multiple platforms from the Mac+ to mainframes.