FMDB
github.com
- Free plan
- macOS
- iPhone and iPad
What FMDB is
FMDB is a free Objective-C wrapper around SQLite for Cocoa developers working in Objective-C or Swift on iOS and macOS. FMDatabase represents a SQLite database and executes SQL statements, while FMResultSet exposes typed accessors for query results. FMDatabaseQueue coordinates access across multiple threads and supports transactions, including rollback through a queue method. Queue calls are blocking, and their blocks do not run on another thread. The project recommends SQLite placeholders with bound values instead of inserting values directly into SQL strings. Developers can create custom SQLite functions from blocks. Installation is documented through CocoaPods, Carthage, and Swift Package Manager; Swift projects can also use Objective-C bridging headers. An SQLCipher subspec or package trait can compile FMDB with SQLCipher encryption support. FMDB supports offline use but has no data synchronization. The listed FMDB plan is free. Community support is voluntary through the mailing list, GitHub bug reports, or Stack Overflow.
Who it suits
FMDB suits Cocoa developers who want SQLite access from Objective-C or Swift projects on iOS or macOS. It is useful when local storage and optional SQLCipher compilation are needed.
Good to know, and what to watch
- Free Objective-C and Swift SQLite access
- Typed query results through FMResultSet
- Queue-based coordination for multithreaded access
- Documented CocoaPods, Carthage, and Swift installation
- Optional SQLCipher encryption support
- No data synchronization
- Queue calls are blocking
- One FMDatabase instance should not serve multiple threads directly
- Support is voluntary and community-provided
Plans
Every plan and priceFMDB
Free plan
The verdict
FMDB offers a focused SQLite wrapper with typed results, transaction support, installation choices, and an encryption option. Developers must account for blocking queue behavior, thread-safety guidance, and the absence of synchronization.
What the maker publishes
- Concurrency
- FMDatabaseQueue synchronizes and coordinates database access across multiple threads. source
- Custom functions
- FMDB supports creating custom SQLite functions based on blocks. source
- Database access
- FMDatabase represents a SQLite database and is used to execute SQL statements. source
- Encryption option
- The README describes using the SQLCipher subspec or package trait to compile FMDB with SQLCipher encryption support. source
- Integrations
- The project documents installation through CocoaPods, Carthage, and Swift Package Manager, and describes SQLCipher options. source
- Intended users
- The project is for Cocoa developers who want to work with SQLite through Objective-C or Swift. source
- Parameter binding
- The README recommends SQLite placeholders and bound values, which its execution methods escape, instead of manually inserting values into SQL strings. source
- Purpose
- FMDB is an Objective-C wrapper around SQLite. source
- Query results
- FMResultSet represents the results of executing a query on an FMDatabase and offers typed column accessors. source
- Queue behavior
- FMDatabaseQueue calls are blocking and its blocks do not run on another thread. source
- Support
- Support is community-provided on a voluntary basis through the mailing list, GitHub bug reports, or Stack Overflow. source
- Swift support
- FMDB can be used in Swift projects, including through Swift Package Manager and Objective-C bridging headers. source
- Thread-safety limit
- The README warns against using one FMDatabase instance from multiple threads at once and recommends FMDatabaseQueue for shared access. source
- Transactions
- FMDatabase and FMDatabaseQueue support transactions, including a queue method that can roll back a transaction. source
Checked against the maker's pages on 7 Oct 2026.