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.