Major Updates and New Features of WCDB 2: Multi‑language Support, SQL Builder, Backup & Recovery, Data Migration, Compression, and Performance Optimizations

WCDB is an open‑source, SQLite‑based mobile database developed by the WeChat team. Since its first release in June 2017, it has been widely adopted and now supports more than ten versions while maintaining strong backward compatibility.

Challenges : WeChat handles hundreds of business scenarios and stores millions of messages. The growing data volume and diverse use cases put pressure on the original code framework, requiring continuous upgrades.

Major upgrades :

Support for additional development languages – C++, full Java and Kotlin ORM, alongside existing Objective‑C, Swift, and Java support.

Enhanced SQL expression capabilities through a rewritten Winq query builder that stores each SQL token’s state, allowing safe, chainable query construction and full coverage of SQLite’s syntax.

New data backup and recovery scheme that maps master‑table entries and leaf‑page CRC values, enabling fast, reliable restoration with a 99%+ repair rate and sub‑second backup times even for multi‑gigabyte databases.

Incremental backup using WAL page tracking and savepoints to reduce I/O and avoid blocking the UI.

Automatic data migration that presents a “migration‑completed” view to developers. The framework creates a temporary view that unions old and new tables, rewrites INSERT/UPDATE/SELECT/DELETE statements, and performs the actual migration in the background.

Data compression using Zstandard (Zstd) dictionary compression. WCDB adds hidden status columns for each compressed field, transparently compresses data on INSERT/UPDATE, and decompresses on SELECT/DELETE. It also compresses existing data asynchronously.

Automatic addition of new columns: when a query fails with “no such column”, WCDB checks the ORM definition and adds the missing column on‑the‑fly before retrying.

Other performance improvements: FTS5 optimizer, interruptible transactions, and WAL‑header sync optimization to avoid UI stalls.

Code examples :

Define a C++ model:

class Sample { public: int id; std::string content; WCDB_CPP_ORM_DECLARATION(Sample) };

Insert an object using WCDB:

database.insertObjects
(Sample(1, "text"), myTable);

Select with the new Winq builder:

WCDB::StatementSelect().select(WCTSequence.seq).from("sqlite_sequence").where(WCTSequence.seq > 1000).orderBy({WCTSequence.seq.order(WCTOrderedAscending)}).limit(10).offset(100);

Data migration pre‑processing (SELECT example): the framework replaces the new table name with a union view that merges old and new tables, so developers can query the new table directly while the migration runs in the background.

Data compression on INSERT (simple case): the original content column is stored in a hidden WCDB_CT_content column together with a status flag; the value is compressed with Zstd before being written.

// Simple INSERT with compression
INSERT INTO myTable (WCDB_CT_content, WCDB_CT_content_status) VALUES (compress(originalContent), STATUS_COMPRESSED);

Interruptible transaction loop (pseudo‑code):

while (!shouldCommit) { writeBatch(); if (mainThreadBlocked()) { commit(); wakeMainThread(); } }

All these enhancements make WCDB a robust, multi‑language, high‑performance database solution for mobile applications.