SQLite.swift
github.com
- Free plan
- macOS
- Linux
- iPhone and iPad
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
Plans
Every plan and priceSQLite.swift
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.