Why Switch from FMDB to WCDB? Performance, Migration & Feature Guide

Background

WCDB has been open‑source for over two months, during which the team has iterated on features, improved documentation, and engaged with developers worldwide, many of whom are using FMDB and are considering migrating their projects to WCDB.

Smooth Migration

Because both FMDB and WCDB are built on SQLite, the database file format is identical, allowing existing FMDB databases to be opened directly with WCDB without any data migration.

WCDB provides ORM capabilities. Since class property names often differ from table column names, WCDB offers the macro WCDB_SYNTHESIZE_COLUMN(className, propertyName, columnName) to map properties to columns.

Example table definition: CREATE TABLE message (db_id INTEGER, db_content TEXT) Corresponding class mapping is illustrated in the following images:

After using WCDB_SYNTHESIZE_COLUMN, WCDB fully supports the FMDB table structure, eliminating the need for data migration.

Performance Comparison

Performance is a common migration driver for production projects. WCDB optimizes both the ORM layer and the SQLite core, whereas FMDB offers a straightforward wrapper.

Benchmarks (WAL mode, cache size 2000 bytes, page size 4 KB) were uploaded to GitHub, including FMDB tests for side‑by‑side comparison.

Key benchmark settings:

PRAGMA cache_size=-2000

PRAGMA page_size=4096

PRAGMA journal_mode=WAL

Test table: CREATE TABLE benchmark(key INTEGER, value BLOB) Read operations: WCDB is about 5% slower than FMDB due to additional ORM overhead.

Write operations: WCDB is 28% faster than FMDB, and batch writes are 180% faster .

Multithreaded read/write tests show WCDB’s performance matches FMDB in reads and exceeds FMDB by 62% in combined read/write scenarios.

Initialization speed: WCDB’s optimizations give it a 107% performance advantage over FMDB as the number of tables grows.

Usability Comparison

For new projects, development efficiency matters most. WCDB typically requires far fewer lines of code than FMDB for equivalent functionality, leading to faster development and fewer bugs.

WCDB’s ORM mirrors modern client‑side databases such as CoreData and Realm.

Example FMDB definitions:

CREATE TABLE message (localID INTEGER PRIMARY KEY AUTOINCREMENT, content TEXT, createTime INTEGER, modfiedTime INTEGER)

CREATE INDEX message_index ON message(createTime)

WCDB equivalents use the following macros:

WCDB_IMPLEMENTATION(className)

WCDB_PROPERTY(propertyName)

WCDB_SYNTHESIZE(className, propertyName)

WCDB_PRIMARY_AUTO_INCREMENT(className, propertyName)

WCDB_INDEX(className, indexNameSubfix, propertyName)

After ORM setup, most operations require only a single line of code, as shown in the query and insert examples (images omitted for brevity).

Database Upgrade

SQLite schema upgrades can become complex. WCDB ties upgrades to the ORM layer: modifying or removing fields in the ORM and calling createTableAndIndexesOfName:withClass: automatically updates the schema.

Adding, removing, or renaming columns, changing types, adding constraints (e.g., WCDB_UNIQUE(Message, aNewModifiedTime)) or indexes (e.g., WCDB_INDEX(Message, "_newIndex", aNewProperty)) is done directly in the ORM definitions.

Multithreaded Operations

Both WCDB and FMDB support multithreading. FMDB requires the FMDatabasePool class for thread‑safe access, whereas WCDB’s core CRUD interfaces are thread‑safe out of the box, reducing boilerplate code.

Feature Completeness

WCDB includes additional capabilities:

Encryption via SQLCipher.

Statistics APIs to log SQL statements, performance metrics, and errors.

Repair tools for corrupted databases.

Conclusion

Compared with FMDB, WCDB lets developers write less code while achieving higher performance. It abstracts database upgrades and multithreaded access, and adds encryption, statistics, and repair features. For new projects, WCDB is recommended for better performance and developer efficiency; for existing stable projects, consider migration if you face performance bottlenecks or need the extra features.