Tagged articles

SQLite FTS5

4 articles · Page 1 of 1
Architecture Digest
Architecture Digest
Sep 25, 2026 · Artificial Intelligence

Context-Mode MCP Plugin Cuts AI Context 96% via Sandbox & SQLite FTS5

The article analyzes context-mode, an MCP plugin that reduces AI coding agent context usage by 96% across 21 real-world scenarios by intercepting tool outputs, executing analysis in sandboxes, and indexing content in SQLite FTS5 with BM25 retrieval for session continuity.

AI programmingBM25Context Management
0 likes · 12 min read
Context-Mode MCP Plugin Cuts AI Context 96% via Sandbox & SQLite FTS5
Tech Architecture Stories
Tech Architecture Stories
Sep 3, 2026 · Backend Development

DxC: Natural-Language Content Workbench with 8-Step Pipeline & Local Memory

DxC is a personal content workbench that uses natural language to orchestrate an 8-step production pipeline — research, brief, outline, draft, title, visuals, review, and WeChat draft delivery — backed by local hybrid retrieval (SQLite FTS5 + BGE embeddings) and a four-layer memory system that persists across projects.

BGE embeddingsSQLite FTS5WeChat publishing
0 likes · 19 min read
DxC: Natural-Language Content Workbench with 8-Step Pipeline & Local Memory
AI Engineering
AI Engineering
Mar 2, 2026 · Artificial Intelligence

How Context Mode Cuts 98% of Context Tokens for AI Development Tools

Context Mode inserts a sandbox and SQLite‑FTS5 retrieval layer between Claude Code and tool outputs, shrinking typical tool data from megabytes to a few hundred bytes and reducing overall context usage by 98%, extending session time from about 30 minutes to three hours.

AI toolingClaudeSQLite FTS5
0 likes · 4 min read
How Context Mode Cuts 98% of Context Tokens for AI Development Tools
Tencent Cloud Developer
Tencent Cloud Developer
Feb 20, 2023 · Mobile Development

iOS WeChat Full-Text Search Technology Upgrade: Selection and Optimization

iOS WeChat’s full‑text search was upgraded by selecting SQLite FTS5, creating a VerbatimTokenizer with multi‑level delimiter support, optimizing table formats to cut index size by 30 %, improving batch index updates and parallel search logic, resulting in 40‑60 % faster query latency.

Database OptimizationIndex OptimizationSQLite FTS5
0 likes · 26 min read
iOS WeChat Full-Text Search Technology Upgrade: Selection and Optimization