SQLite.swift

A type-safe, Swift-language layer over SQLite3.

SQLite.swift provides compile-time confidence in SQL statement syntax and intent.

Features

• A pure-Swift interface
• A type-safe, optional-aware SQL expression builder
• A flexible, chainable, lazy-executing query layer
• Automatically-typed data access
• A lightweight, uncomplicated query and parameter binding interface
• Developer-friendly error handling and debugging
• Full-text search support
• Well-documented
• Extensively tested
• SQLCipher support via Swift Package Manager
• Schema query/migration
• Works on Linux (with some limitations)
• Active support at StackOverflow, and Gitter Chat Room (experimental)

Usage

import SQLite
// Wrap everything in a do...catch to handle errors
do{letdb=tryConnection("path/to/db.sqlite3")letusers=Table("users")letid=SQLite.Expression<Int64>("id")letname=SQLite.Expression<String?>("name")letemail=SQLite.Expression<String>("email")try db.run(users.create{ t in
t.column(id, primaryKey:true)
t.column(name)
t.column(email, unique:true)})
// CREATE TABLE "users" (
// "id" INTEGER PRIMARY KEY NOT NULL,
// "name" TEXT,
// "email" TEXT NOT NULL UNIQUE
// )
letinsert= users.insert(name <-"Alice", email <-"alice@mac.com")letrowid=try db.run(insert)
// INSERT INTO "users" ("name", "email") VALUES ('Alice', 'alice@mac.com')
foruserintry db.prepare(users){print("id: \(user[id]), name: \(user[name]), email: \(user[email])")
// id: 1, name: Optional("Alice"), email: alice@mac.com
}
// SELECT * FROM "users"
letalice= users.filter(id == rowid)try db.run(alice.update(email <- email.replace("mac.com", with:"me.com")))
// UPDATE "users" SET "email" = replace("email", 'mac.com', 'me.com')
// WHERE ("id" = 1)
try db.run(alice.delete())
// DELETE FROM "users" WHERE ("id" = 1)
try db.scalar(users.count) // 0
// SELECT count(*) FROM "users"
}catch{print(error)}

Note that Expression should be written as SQLite.Expression to avoid conflicts with the SwiftUI.Expression if you are using SwiftUI too.

SQLite.swift also works as a lightweight, Swift-friendly wrapper over the C API.

// Wrap everything in a do...catch to handle errors
do{
// ...
letstmt=try db.prepare("INSERT INTO users (email) VALUES (?)")foremailin["betty@icloud.com","cathy@icloud.com"]{try stmt.run(email)}
db.totalChanges // 3
db.changes // 1
db.lastInsertRowid // 3
forrowintry db.prepare("SELECT id, email FROM users"){print("id: \(row[0]), email: \(row[1])")
// id: Optional(2), email: Optional("betty@icloud.com")
// id: Optional(3), email: Optional("cathy@icloud.com")
}try db.scalar("SELECT count(*) FROM users") // 2
}catch{print(error)}

Read the documentation or explore more, interactively, from the Xcode project’s playground.

Installation

Swift Package Manager

The Swift Package Manager is a tool for managing the distribution of Swift code.

1. Add the following to your Package.swift file:

dependencies:[.package(url:"https://github.com/stephencelis/SQLite.swift.git", from:"0.15.5")]

2. Build your project:

$ swift build

See the Tests/SPM folder for a small demo project which uses SPM.

Carthage

Carthage is a simple, decentralized dependency manager for Cocoa. To install SQLite.swift with Carthage:

1. Make sure Carthage is installed.

2. Update your Cartfile to include the following:

   github"stephencelis/SQLite.swift" ~> 0.15.5

3. Run carthage update and add the appropriate framework.

CocoaPods

CocoaPods is a dependency manager for Cocoa projects. To install SQLite.swift with CocoaPods:

1. Make sure CocoaPods is installed.

   # Using the default Ruby install will require you to use sudo when# installing and updating gems.
   [sudo] gem install cocoapods

2. Update your Podfile to include the following:

   use_frameworks!target'YourAppTargetName'dopod'SQLite.swift','~> 0.15.0'end

3. Run pod install --repo-update.

Manual

To install SQLite.swift as an Xcode sub-project:

1. Drag the SQLite.xcodeproj file into your own project. (Submodule, clone, or download the project first.)

   

2. In your target’s General tab, click the + button under Linked Frameworks and Libraries.

3. Select the appropriate SQLite.framework for your platform.

4. Add.

Some additional steps are required to install the application on an actual device:

5. In the General tab, click the + button under Embedded Binaries.

6. Select the appropriate SQLite.framework for your platform.

7. Add.

Communication

Read the contributing guidelines. The TL;DR (but please; R):

• Need help or have a general question? Ask on Stack Overflow (tag sqlite.swift).
• Found a bug or have a feature request? Open an issue.
• Want to contribute? Submit a pull request.

Original author

• Stephen Celis (@stephencelis)

License

SQLite.swift is available under the MIT license. See the LICENSE file for more information.

Related

These projects enhance or use SQLite.swift:

• SQLiteMigrationManager.swift (inspired by FMDBMigrationManager)

Alternatives

Looking for something else? Try another Swift wrapper (or FMDB):

• GRDB
• SQLiteDB