Tagged articles
embedded database
19 articles · Page 1 of 1
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

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.
ACIDDatabase DesignFTS5
0 likes · 16 min read

This article argues that SQLite, often dismissed as a toy database, can replace specialized systems like Elasticsearch, MongoDB, Kafka, ClickHouse, Redis, and even microservices due to its stability, zero-configuration deployment, built-in full-text search, JSON support, vector extensions, and local-first architecture, reducing operational complexity.
CachingFTS5JSON
0 likes · 25 min read

SQLite powers virtually every mobile app, browser, TV and car system, with an estimated trillion live instances, yet it is written and maintained by only three people who enforce a public‑domain license and a rigorous aerospace‑grade test suite.
Fossil VCSPublic DomainSQLite
0 likes · 7 min read


TonyBaiMar 13, 2026 · Backend Development
The article analyzes why traditional row‑oriented databases struggle with high‑volume analytics, introduces DuckDB as an embedded columnar engine for Go, presents benchmark results of up to 18.6 M rows per second writes and 6 M rows per second scans, walks through the Appender API code, and outlines the trade‑offs and ideal hybrid architecture.
DuckDBGoOLAP
0 likes · 11 min read

SQLite, the lightweight embedded SQL engine created by Richard Hipp, powers virtually every smartphone, computer, browser and countless desktop apps, and thanks to its strict backward‑compatible C API, exhaustive documentation, extensive comments, rigorous cross‑platform testing, and a tiny dedicated team, it aims to remain reliable and widely used through 2050.
SQLitebackward compatibilitydocumentation
0 likes · 9 min read

This article recounts how SQLite was created by Richard Hipp to solve reliability issues on a U.S. Navy destroyer, evolved from a simple file‑based engine into an open‑source, B‑Tree powered embedded database that now powers billions of devices, smartphones, browsers, and applications worldwide.
B+TreeDatabase ArchitectureSQLite
0 likes · 7 min read

SQLite, the lightweight embedded SQL engine created in 2000, is the world’s most deployed database, powering mobile apps, embedded systems, desktop software, data analysis tasks, and even browser‑based acceleration via WebAssembly, thanks to its zero‑configuration design and broad language support.
SQLiteWebAssemblydata analysis
0 likes · 8 min read


ITPUBSep 4, 2024 · Databases
This article introduces SQLite, explains why it is the most widely deployed lightweight SQL engine, outlines its common use cases in mobile, desktop and IoT devices, compares it with MySQL and PostgreSQL, and provides step‑by‑step installation instructions.
Database InstallationSQLiteembedded database
0 likes · 6 min read

SQLite, a lightweight serverless relational database written in C, powers billions of devices and is used for mobile app storage, embedded systems, offline desktop applications, small‑to‑medium data analysis, and browser‑based acceleration via WebAssembly, supporting languages such as C, C++, Java, Python, and Swift.
IoTSQLiteWebAssembly
0 likes · 5 min read

This article explains why SQLite, the lightweight embedded relational database, is the most widely deployed database in the world, detailing its origins, core features, and diverse usage scenarios across mobile, embedded, desktop, data analysis, and web acceleration contexts.
Data StorageSQLiteWebAssembly
0 likes · 6 min read


ITPUBJan 22, 2024 · Databases
This article traces SQLite’s origins from a 2000 Navy project, explains how its first version wrapped GDBM, details its layered architecture and code flow, and shows how Richard Hipp’s philosophy of building every component himself turned SQLite into the ubiquitous embedded database we see everywhere today.
Database ArchitectureGDBMRichard Hipp
0 likes · 10 min read

This article explores why SQLite is the world’s most ubiquitous database, tracing its birth from a Navy project, its early implementation atop GDBM, the layered architecture that processes SQL statements, the transition to a B‑tree engine, and the creator’s philosophy of self‑contained software.
GDBMRichard HippSQL Engine
0 likes · 10 min read

The article introduces DuckDB, a high‑performance embedded analytical database, outlines its new release’s storage, performance, and memory improvements, describes its C/C++ integration and build process, and lists key feature changes such as parallel execution, novel compression methods, and enhanced SQL capabilities.
CompressionDuckDBParallelism
0 likes · 3 min read

This article introduces SPL, an open‑source Java‑embeddable computation library that outperforms traditional embedded databases and DataFrame tools by handling both tabular and nested JSON data, supporting JDBC, SQL‑like queries, multi‑source integration, and persistent .btx files with concise code examples.
JDBCJSONJava
0 likes · 8 min read

Nacos 1.3.0 introduces an embedded relational database, unified cluster management, an upgraded Raft consistency protocol, and security fixes, providing simpler deployment, higher performance, and safer operations for both small‑scale and enterprise environments.
NacosOperationsRaft Protocol
0 likes · 9 min read

Nacos 1.3.0 introduces an embedded relational database, unified cluster management, an upgraded Raft consistency layer, security patches, Snowflake ID configuration, data migration guidance, new cluster addressing modes, and a set of Open‑API operations for Raft administration, all aimed at simplicity, performance, and high availability.
NacosRaftSecurity
0 likes · 10 min read

This article explains the lightweight features of the pure‑Java H2 embedded database, demonstrates its various modes—including in‑memory, file‑based, and standalone server—and provides step‑by‑step integration with SpringBoot and MyBatis for rapid development and testing.
JavaMyBatisSpringBoot
0 likes · 9 min read

This article introduces SQLite, a lightweight ACID‑compliant relational database widely used in mobile devices, detailing its zero‑configuration design, key features, limitations, transaction and locking mechanisms, and the Write‑Ahead Logging mode that enables concurrent reads and writes.
SQLiteTransactionsWrite-Ahead Logging
0 likes · 11 min read
