BestHub
Sign in
Tagged articles
12 articles
Page 1 of 1
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 MigrationSQL 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.

DataBackupMulti-languageORM
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.

SecurityWCDBiOS
0 likes · 16 min read
Design and Implementation of an iOS Mobile Log System Using WCDB
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