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 15m
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 15m
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.

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Chris Woodard, and I'm a senior iOS developer at Actsoft Inc. Welcome to my course, Using SQLite in your iOS Apps. SQLite is a fast, reliable, and flexible embedded SQL database engine with a CAPI that works on iOS, Android, macOS, and other operating systems. In this course, we'll build an app that uses the SQLite engine for a data cache and we'll strive for independence by calling the SQLite API directly from Swift instead of using a third-party library or system framework. Some of the major topics that we'll cover include prototyping SQL queries in the command line, executing SQL queries with the SQLite API, writing and using custom SQLite functions, and working with SQLite in a multithreaded environment. By the end of this course, you will know how to write your own SQLite caches for your apps and use some advanced features of the SQLite engine. Before beginning this course, you should be familiar with Xcode, Swift 3, and operating in the Terminal command line. I hope you'll join me on this journey to learn SQLite, with the Using SQLite in Your iOS Apps course, at Pluralsight.