Skip to content
Tagged articles

FTS5

10 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
dbaplus Community
dbaplus Community
Sep 20, 2026 · Databases

SQLite: The Embedded Database That Replaces Solr, MongoDB, Kafka, and More

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: The Embedded Database That Replaces Solr, MongoDB, Kafka, and More
James' Growth Diary
James' Growth Diary
Jun 2, 2026 · Artificial Intelligence

Cross‑Session Retrieval with SQLite FTS5 and LLM Summaries – Hermes Agent’s Four‑Layer Architecture

This article dissects Hermes Agent’s four‑layer cross‑session retrieval system, covering persistent storage, dual‑table FTS5 indexing for CJK and English, a three‑path search strategy, intelligent truncation for LLM prompts, structured summarisation, and a holographic retrieval layer that blends FTS5, Jaccard similarity and HRR vector algebra.

Agent ArchitectureCross-Session RetrievalFTS5
0 likes · 25 min read
Cross‑Session Retrieval with SQLite FTS5 and LLM Summaries – Hermes Agent’s Four‑Layer Architecture
Architect
Architect
Apr 13, 2026 · Artificial Intelligence

How Hermes and OpenClaw Differ in Memory Architecture and Skill Management

The article analyzes Hermes Agent's three‑layer memory system—fact memory stored in tiny Markdown files, session history indexed with SQLite + FTS5, and procedural memory via skill management—then compares each layer to OpenClaw's architecture and explains how to integrate self‑summarizing skills into OpenClaw.

Agent ArchitectureExternal Memory ProviderFTS5
0 likes · 27 min read
How Hermes and OpenClaw Differ in Memory Architecture and Skill Management
CodeTrend
CodeTrend
Apr 11, 2026 · Artificial Intelligence

Inside Hermes Agent: How Its Closed‑Loop Learning Architecture Transforms AI Assistants

Hermes Agent introduces a closed‑loop learning architecture that adds result evaluation, pattern extraction, and persistent user modeling to the traditional receive‑plan‑execute‑return cycle, offering searchable FTS5‑based memory, autonomous skill creation, multi‑platform messaging, provider‑agnostic model switching, and built‑in research tools for AI developers.

FTS5Hermes AgentLLM summarization
0 likes · 8 min read
Inside Hermes Agent: How Its Closed‑Loop Learning Architecture Transforms AI Assistants
Laravel Tech Community
Laravel Tech Community
May 18, 2023 · Databases

SQLite 3.42.0 Release Highlights and New Features

SQLite 3.42.0, the widely used public-domain SQL database engine, introduces features such as FTS5 secure-delete, JSON5 support, new sqlite3_config options, enhanced query planner optimizations, CLI improvements, additional SQL functions, extended PRAGMA integrity_check, subsecond time modifiers, and various bug fixes and performance enhancements.

Database EngineFTS5JSON5
0 likes · 5 min read
SQLite 3.42.0 Release Highlights and New Features