WCDB

What WCDB is

WCDB is a free, open-source database framework based on SQLite and SQLCipher, used in the WeChat application. It is designed for cross-platform mobile database work and provides interfaces for C++, Java, Kotlin, Swift, and Objective-C. Its ORM supports creating tables, indexes, and constraints, as well as CRUD operations through language objects. Developers can use WINQ to express queries in native language syntax rather than assemble SQL strings. Connection pooling supports concurrent read-read and read-write access. The project describes optimizations for mobile use and costly operations such as batch writes. WCDB supports SQLCipher database encryption and includes built-in SQL injection protection. It also provides a repair kit for database corruption recovery, full-text search interfaces with tokenizers for multiple languages, and configured migration between databases. Zstd compression is available for selected table fields. The repository links build and installation guidance alongside tutorials for the supported languages. Listed platforms include Android, iOS, Linux, macOS, and Windows.

Who it suits

WCDB is for developers building cross-platform database features, particularly for mobile apps. It may suit teams working in C++, Java, Kotlin, Swift, or Objective-C.

Getting started

1. Open the WCDB repository at https://github.com/Tencent/wcdb.
2. Choose a supported platform and programming language for your project.
3. Follow the repository’s build and installation guide.
4. Use the tutorial for C++, Java/Kotlin, Swift, or Objective-C to get started.

Verdict

WCDB provides database, query, encryption, and recovery capabilities for developers across several languages and platforms. Review the linked installation guides and tutorials for the language and platform you plan to use.