Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

SQLite.swift

github.com

  • Free plan
  • macOS
  • Linux
  • iPhone and iPad
7.3 Club score Visit github.com

What SQLite.swift is

SQLite.swift is a free, MIT-licensed Swift library that places a type-safe layer over SQLite3. It is designed to provide compile-time confidence about SQL statement syntax and intent while offering an optional-aware expression builder for constructing queries. Its chainable query layer executes lazily, and automatically typed data access with parameter binding keeps database calls lightweight. Documented capabilities include schema queries, migrations, full-text search, transactions, and configuration for WAL mode and journaling. SQLCipher support is available through Swift Package Manager, with APIs for setting or changing a database key. The library runs on iOS, Linux, and macOS. Installation options include Swift Package Manager, Carthage, CocoaPods, or manual Xcode integration. Each connection uses its own serial queue and can be shared across threads, although open transactions and savepoints block other statements. SQLite.swift works offline and provides no data synchronization.

Who it suits

SQLite.swift suits Swift developers building offline database features for iOS, macOS, or Linux applications. It is useful when typed queries, migrations, transactions, or optional SQLCipher encryption are needed.

Good to know, and what to watch

  • Free MIT-licensed Swift source library
  • Type-safe SQL expressions and query construction
  • Supports migrations, full-text search, and transactions
  • Offers SQLCipher encryption integration
  • Runs on iOS, Linux, and macOS
  • No data synchronization
  • Shared group containers are discouraged due to reported crashes
  • Open transactions block other threads' statements
  • No free trial is offered

SQLite.swift

Free

Free plan

The verdict

SQLite.swift gives Swift projects typed query building and broad SQLite capabilities without a paid plan. Developers should account for its thread blocking behavior and the project’s warning about shared group containers.

What the maker publishes

Data access
The library provides automatically typed data access and a lightweight interface for queries and parameter binding. source
Database capabilities
Documented capabilities include schema queries and migrations, full-text search, transactions, and WAL mode and journaling configuration. source
Encryption integration
SQLite.swift supports SQLCipher through Swift Package Manager, including APIs to set and change a database key. source
Install options
The project documents installation through Swift Package Manager, Carthage, CocoaPods, or manual Xcode project integration. source
License
SQLite.swift is available under the MIT license. source
Platforms
The project says it works on Linux with some limitations; its documentation includes macOS and iOS setup and platform declarations. source
Purpose
SQLite.swift is a type-safe, Swift-language layer over SQLite3 that provides compile-time confidence in SQL statement syntax and intent. source
Query building
It includes a type-safe, optional-aware SQL expression builder and a flexible, chainable, lazy-executing query layer. source
Security
The project documents optional SQLCipher support for encrypted databases; it does not state a compliance certification on the pages reviewed. source
Shared containers
The documentation advises against storing databases in a shared group container because some users have reported crashes. source
Support
The README directs questions to Stack Overflow under the sqlite.swift tag, bug reports and feature requests to GitHub issues, and contributions to pull requests. source
Thread safety
Each connection has its own serial queue for statement execution and can be accessed across threads; open transactions and savepoints block other threads from executing statements. source

Checked against the maker's pages on 4 Oct 2026.