sqlite

A long-time OpenClaw user reports that the 2026.10.10 update broke all 11 chat turns due to a hard-coded 512 MB SQLite worker heap cap causing repeated ERR_WORKER_OUT_OF_MEMORY crashes, alongside a broken migration of Claude CLI model refs — and frustration that similar update regressions keep recurring despite an existing issue.

This article introduces Obelisk, an open-source system that indexes historical sessions from coding agents like Claude Code and Codex into SQLite for direct retrieval by agents. Its design is inspired by the paper "Is Complex Agentic Memory Always Needed?", which found that a simple RAW-RAG approach (retaining raw conversation history and retrieving on demand) outperformed complex agentic memory schemes across multiple memory benchmarks.

SAG2 提出一种无需嵌入的多跳检索架构，仅使用 SQLite、BM25 和 JEV 上下文证据决策，在 MuSiQue、2WikiMultiHopQA 和 HotpotQA 上取得最高 Recall@5/Recall@10，索引速度快且无需模型调用。

Pi officially published a tutorial on building a multi-user Agent on Cloudflare Durable Objects: a single Durable Object maps to one session, state is stored in built-in SQLite, and it supports multiple users sharing a link to chat collaboratively, as well as scheduled wake-up tasks. The tutorial also demonstrates an isolated design for session retrieval, idempotent request handling, and a mechanism for sharing a single alarm across multiple tasks.

sparqlite is a Rust-based SQLite loadable extension that stores RDF quads in ordinary SQLite tables and natively executes SPARQL 1.1 queries, achieving 3.5× speedups over SQL translation while passing 636 of 639 W3C evaluation tests — notably generated by Claude Code's Ultracode agentic workflow over a 12-hour run.

腾讯开源了 Agent Memory，一个可 100% 本地基于 SQLite 运行的 AI 智能体长期记忆层，无需云端 API 或向量数据库，报告可减少约 61% token，PersonaMem 准确率从 48% 提升到 76%，且记忆可读可追溯。

作者分享了如何用 C 语言和 CGI 协议构建并部署一款现代商业 Web 产品（marketyour.games）：单个静态链接二进制、SQLite 文件、仅三个依赖库，无框架、无容器，部署即替换文件、零停机。文章论证了在 2026 年用 C + OpenBSD httpd + SQLite（BCHS 栈）写真正的生产级 Web 应用依然可行且极具简洁性。

Simon Willison 发布了 datasette-ports 0.4 版本，这是 Datasette 生态中的一个插件/工具更新。

APSW（Another Python SQLite Wrapper）是一个开源 Python 库，将完整的 SQLite C API 与 Python C API 粘合在一起，支持全文搜索、虚拟表、VFS、JSON 及异步框架，旨在提供比内置 sqlite3 模块更完整的 SQLite 使用体验。

Anton Zhiyanov (@ohmypy) 报道 SQLite 核心团队正在开发 Vec1——SQLite 原生向量搜索（ANN）功能，支持欧氏（L2）与余弦距离，并使用 SIMD 加速向量运算；该功能已基本完成，仅剩测试改进等工作。

A tweet discussing how SQLite is open source yet rejects external contributions, prompting Turso to fork it into libSQL and later rewrite a SQLite-compatible database in Rust (originally named Limbo) to add async I/O, concurrent writes, vector search, and better WASM support.

An indie dev released repopedia, an MIT-licensed, fully local code knowledge-graph tool that builds a SQLite graph from Python/TypeScript repos using tree-sitter, plus an MCP server so coding agents like Claude Code can query call graphs and blast-radius impact directly instead of relying on grep.

Hillock 0.8 is an open-source tool that replaces vector databases for local RAG using SQLite relational facts and 10,000-dimensional bit-packed hypervectors with SIMD/popcount gating, blocking hallucinated answers before token generation under 1.2GB VRAM.

Supabase is acquiring Turso to build AI-agent-oriented database infrastructure, combining Supabase's Postgres platform with Turso's SQLite-based cloud that can serve millions of databases on demand.

OpenLTM is a shared local SQLite database with semantic recall and decay that allows multiple AI agent hosts like OpenClaw, Claude Code, and others to use the same memory, ensuring consistency when switching tools.

Garry Tan praises Astra as impressive, and Peter Steinberger discusses a design flaw with sqlite in an agent system.

Extralite 3.1.0 is released with automatic caching of parametric queries to reduce parsing overhead and improve performance in Ruby applications using SQLite.

Datasette-explain version 0.2.2 has been released, enhancing Datasette with additional explanation features for data exploration.

Capsule is a tool that creates single-file web apps with built-in SQLite storage, enabling portable, private, and offline-first applications without cloud dependencies.

A developer built a custom AI memory system in Python that avoids hallucinations by using a rule-based architecture with hypothesis testing and consolidation phases, inspired by neuromodulation.