SQLite for iOS Development with Swift

This section explains the basics of using the SQLite3 library with Swift for iOS app development.

• What is SQLite?
  • Introduction to SQLite
  • When Should You Use SQLite?
• SQLite Data Types
  • Overview of SQLite Data Types
  • Supported Data Types in SQLite
  • Unsupported Data Types in SQLite
• Creating a Test iOS App for SQLite
• How to Create and Open a SQLite Database in Swift
• How to Create Tables in SQLite with Swift
• Swift + SQLite: Insert Data (INSERT)
  • Defining a Function to Insert Data into the Students Table
  • Inserting Data into the Students Table
• Swift + SQLite: Update Data (UPDATE)
  • Defining a Function to Update Data in the Students Table
  • Updating Data in the Students Table
• Swift + SQLite: Retrieve Data (SELECT)
  • Defining a Function to Select Data from the Students Table
  • Retrieving Data from the Students Table
• Swift + SQLite: Delete Data (DELETE)
  • Defining a Function to Delete Data from the Students Table
  • Deleting Data from the Students Table
• Swift + SQLite: How to Check the Database File Location in iOS Apps
  • Finding the SQLite File Path in iOS Apps
  • Opening the SQLite File Path in Finder on Mac