BestHub
Sign in
Tagged articles

FTS5

7 articles · Page 1 of 1
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.

CLIDatabase EngineFTS5
0 likes · 5 min read
SQLite 3.42.0 Release Highlights and New Features