Skip to content
Tagged articles

WCDB

14 articles · Page 1 of 1
Java Tech Enthusiast
Java Tech Enthusiast
Oct 27, 2026 · Databases

Why WeChat Chooses SQLite for 1.3 Billion Users' Chat Records

WeChat stores 1.3 billion users' chat records locally on devices using SQLite via its WCDB framework, avoiding EB-scale server costs while enabling instant search via FTS5 full-text indexing, with SQLCipher encryption and automatic sharding at 240MB per database file.

ACIDFTS5SQLCipher
0 likes · 16 min read
Why WeChat Chooses SQLite for 1.3 Billion Users' Chat Records
IT Services Circle
IT Services Circle
Oct 18, 2026 · Databases

Why WeChat Uses SQLite for 1.3 Billion Users' Chat Records

This article explains why WeChat stores chat records locally using SQLite instead of cloud databases, detailing the cost savings, privacy benefits, and performance advantages of embedded databases, along with WeChat's custom WCDB framework, FTS5 full-text search, encryption, and the trade-offs of local-only storage.

ACIDFTS5SQLCipher
0 likes · 16 min read
Why WeChat Uses SQLite for 1.3 Billion Users' Chat Records
Tencent Cloud Developer
Tencent Cloud Developer
Apr 16, 2024 · Databases

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

WCDB 2 introduces multi-language support (C++, Java, Kotlin), a rewritten SQL builder, fast backup and recovery with sub‑second times, incremental WAL‑based backup, automatic data migration, Zstandard compression, on‑the‑fly column addition, and performance enhancements such as an FTS5 optimizer and interruptible transactions, delivering a robust high‑performance mobile database solution.

Data CompressionSQL BuilderSQLite
0 likes · 47 min read
Major Updates and New Features of WCDB 2: Multi‑language Support, SQL Builder, Backup & Recovery, Data Migration, Compression, and Performance Optimizations
WeChat Client Technology Team
WeChat Client Technology Team
Apr 9, 2024 · Databases

How WCDB Evolved: Multi‑Language Support, Powerful SQL Builder, and Ultra‑Fast Backup

This article details the major upgrades of WCDB, including expanded language support, a redesigned Winq SQL builder, robust data backup and repair mechanisms, seamless data migration, on‑the‑fly compression, automatic column addition, and performance optimizations such as interruptible transactions and WAL header improvements.

CompressionDataBackupMulti-language
0 likes · 49 min read
How WCDB Evolved: Multi‑Language Support, Powerful SQL Builder, and Ultra‑Fast Backup
Sohu Tech Products
Sohu Tech Products
May 19, 2021 · Mobile Development

Design and Implementation of an iOS Mobile Log System Using WCDB

This article describes the requirements, architecture, API design, database selection, retention policies, security measures, and performance optimizations of a new iOS log system that records business, network, and player logs, uses WCDB for storage, and employs active pull and encrypted chunked uploads to improve issue diagnosis.

LoggingSecurityWCDB
0 likes · 16 min read
Design and Implementation of an iOS Mobile Log System Using WCDB
WeChat Client Technology Team
WeChat Client Technology Team
Aug 16, 2017 · Backend Development

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

This article compares FMDB and WCDB, detailing smooth migration steps, benchmark results showing WCDB's superior write and multithreaded performance, reduced code complexity, built‑in encryption, statistics and repair tools, and provides practical guidance for developers considering a database switch.

Database MigrationFMDBSQLite
0 likes · 10 min read
Why Switch from FMDB to WCDB? Performance, Migration & Feature Guide
Tencent TDS Service
Tencent TDS Service
Jun 15, 2017 · Databases

How We Built WCDB: Inside WeChat’s Open‑Source Mobile Database Evolution

This article chronicles the development of WCDB, WeChat’s open‑source mobile database, detailing its early challenges, performance bottlenecks, security risks, concurrency improvements, cross‑platform collaboration, and future roadmap for a more reliable and efficient data layer on iOS and Android.

AndroidMobile DatabaseSQL injection
0 likes · 14 min read
How We Built WCDB: Inside WeChat’s Open‑Source Mobile Database Evolution
WeChat Client Technology Team
WeChat Client Technology Team
Jun 15, 2017 · Databases

How WCDB’s WINQ Eliminates SQL String Concatenation and Injection Risks

This article examines WCDB’s design principles for efficient, complete, and easy-to-use client-side databases, explains the pitfalls of SQL string concatenation such as code redundancy, debugging difficulty, and injection attacks, and describes how WCDB’s WINQ abstraction and ORM layer safely encapsulate SQLite syntax to enable concise, compile-time-checked queries.

C++ORMSQL injection
0 likes · 10 min read
How WCDB’s WINQ Eliminates SQL String Concatenation and Injection Risks