Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Using SQLite in Your iOS Apps

via Pluralsight

Overview

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.

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.

Syllabus

  • Course Overview 1min
  • Introduction and Sample App 7mins
  • SQLite, SQL, and the Command Line 11mins
  • Using the SQLite API 14mins
  • Adding a New Feature 12mins
  • Using Custom SQLite Functions 8mins
  • Using JSON in SQLite 9mins
  • Safe Multithreading in SQLite 8mins
  • Course Wrapup 1min

Taught by

Chris Woodard

Reviews

3.1 rating at Pluralsight based on 11 ratings

Start your review of Using SQLite in Your iOS Apps

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.