sqlite

Extralite 3.0.0, a fast Ruby SQLite wrapper, introduces object graph transforms and modern defaults for database interaction.

ctx is an open-source CLI tool that indexes coding agent sessions locally into SQLite, enabling fast search of past discussions, decisions, and failed attempts to save tokens and improve agent performance.

Introduces WeChat's mobile database framework WCDB built on SQLite and SQLCipher, and recommends related learning resources.

Canonical's dqlite team used TLA+ to model and understand a 16-year-old SQLite bug in WAL checkpointing that can cause database corruption, then verified whether dqlite is affected.

PMB is a local-first memory system for AI coding agents that stores decisions, lessons, and project facts in a SQLite file on your disk. It integrates with Claude Code, Cursor, Codex, and Zed via MCP, providing fast recall without cloud dependencies.

Squad is an open-source Rust tool that lets four major AI CLIs (Claude Code, Gemini CLI, Codex CLI, OpenCode) collaborate on the same codebase through a single SQLite file, with no daemon or server required.

squad is a command-line tool written in Rust that enables collaboration among multiple AI CLI agents (such as Claude Code, Gemini CLI, etc.) via shell commands and an SQLite database, without requiring a background daemon.

This article from SQLite's official documentation explains the various ways an SQLite database can become corrupted, such as file overwrites by rogue processes, misuse of file descriptors, and unsafe backup procedures, along with mitigation strategies.

This article demonstrates that pre-sorting random data before inserting into SQLite can improve insert performance by 2-3x, by leveraging the B+ Tree's ordered nature and reducing page splits.

AutoShorts is an open-source desktop application based on Tauri 2 + React + Rust + SQLite that can automatically convert long videos or audio into vertical short videos, and uses AI (supporting DeepSeek, Claude, or local Ollama) to evaluate the viral potential of clips. It supports multiple platforms.

Simon Willison created a tool to convert Mozilla's browser compatibility data into a downloadable SQLite database, hosted with open CORS headers for easy exploration via Datasette Lite.

The author describes building an ambient memory agent that runs locally on a Mac, watching the screen and optionally audio, OCRs/transcribes everything into structured Markdown in an Obsidian vault, with SQLite as the source of truth. They invite feedback on design choices like using SQLite over vector/graph DB, cost, and durability of such systems.

sqlite-utils 4.0rc1 is a release candidate that adds built-in database migrations (ported from sqlite-migrate) and nested transactions via db.atomic(), along with minor backwards-incompatible changes.

This research explores methods to determine the source table and column for each result column in arbitrary SQLite queries, using SQLite's internal column metadata API accessed via Python's apsw library or a ctypes bridge, with applications for tools like Datasette.

Describes improving agentic memory search by incorporating grep-based exact matching alongside vector embeddings, inspired by a paper; achieved significant recall gains in their memory layer.

EZRA is a lightweight, persistent task queue built on Erlang/OTP with SQLite storage. It exposes a Redis-compatible interface, allowing any Redis client to push and pop tasks without needing a Redis server.

An open-source project uses Tree-sitter to parse code into a graph structure and store it in local SQLite, providing a code map for AI coding agents, thereby reducing token consumption and costs. On average, it saves 57% tokens and reduces costs by 25%. Supports tools like Claude Code, Cursor, aider, etc.

Lore is an open-source tool that uses the Model Context Protocol (MCP) to share session history between AI agents, storing all data locally in SQLite. It enables agents to access each other's past sessions without external dependencies.

Lore is a local tool that indexes AI agent sessions into a SQLite database and serves them over MCP, allowing different agents (e.g., Claude and Codex) to share and retrieve each other's context across sessions.

A guide to backing up annotations from Kobo e-reader for borrowed books using a script that combines sqlite and ImageMagick.