sqlite

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.

Release of github-to-sqlite version 2.9.1, a tool for exporting GitHub data to SQLite databases, posted by Simon Willison.

The article introduces 'memoryfields', a portable file format for AI agent memory that uses Markdown files and optional SQLite indexes, advocating for a simpler, data-driven approach over existing complex systems.

OpenRun introduces built-in Litestream support for SQLite apps, enabling automatic replication to object storage and seamless deployment on Docker and Kubernetes with GitOps integration.

Squad is a command-line tool that enables multiple AI agents to collaborate in a terminal using shell commands and SQLite for real-time communication, without background processes.

The article introduces the concept of executables as SQLite databases, demonstrating a proof-of-concept webserver that stores its program, routes, and state in a single file.

The article discusses a long-standing bug in SQLite's WAL-reset mechanism that caused data loss and corruption, reproducing it with a 100-line C workload to demonstrate the race condition.

This article explains how to use SQLite's JSON support and generated columns to treat SQLite as a document database, enabling data extraction and indexing from JSON columns.

A blog post explains a Linux pattern where a SQLite database file is formatted to act as an ELF executable, using a custom interpreter and binfmt_misc for direct execution.

The article explores replacing the ELF executable format with SQLite, introducing a prototype called SELF that enables executables to be SQLite databases and discusses the benefits and technical implications.

The author replaced a file-based agent handoff system with a self-hosted message board using SQLite, tested it in a real task, and documented failure points.

Hillock v0.5.0 is a lightweight neuro-symbolic memory engine for AI agents that manages persistent memory efficiently using structured triples in SQLite and hypervectors, designed for local setups with limited VRAM.

The author describes building a memory layer for news-reading AI agents to handle deduplication and improve continuity across sessions, using SQLite and vector storage with a Python API, CLI, and MCP server.

The article advocates for SQLite as a versatile and stable database solution, highlighting its ability to replace multiple other tools in various tech stacks.

A developer created an open-source local memory layer called Memmy to share context between Claude Code and Cursor, eliminating the need to re-explain architecture when switching tools.