BestHub
Sign in
Tagged articles

Mobile Database

3 articles · Page 1 of 1
Architect's Tech Stack
Architect's Tech Stack
Oct 10, 2026 · Databases

Why WeChat Stores Billions of Messages in SQLite: The Mobile Database Trade-offs

WeChat uses SQLite for chat storage because its embedded, zero-process design fits mobile constraints; ACID transactions and B+tree indexes ensure message durability and fast pagination; WAL enables concurrent reads/writes; SQLCipher encrypts per-device; sharding by session mitigates single-writer limits, offering a blueprint for local-first apps.

ACIDB-treeLocal-First
0 likes · 5 min read
Why WeChat Stores Billions of Messages in SQLite: The Mobile Database Trade-offs
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