Tag
sqlite-utils 4.1 introduces minor features including --code for Python code blocks, --type for column type overrides, and strict mode support, continuing its evolution as a SQLite CLI utility.
SQLite's strict tables enforce rigid typing to prevent common datatype mistakes. The article explains how to use them and their pros and cons.
Earth Game is a private, offline CLI tool that helps users turn life goals into quests, manage tasks, and review progress, using Python's standard library and SQLite with no external dependencies.
Wire, a platform for AI agent context containers, is migrating from Cloudflare Durable Objects to a custom runtime on Fly Machines due to structural limits: vector index separation, compute-data colocation, placement flexibility, and lack of self-hosting. The new architecture improves latency and enables dedicated capacity.
sqlite-utils 4.0 introduces database schema migrations, nested transactions, and compound foreign keys, making it easier to manage SQLite database schema changes programmatically.
sqlite-migrate 0.2 is a minor release of a Python tool for managing SQLite database migrations, adding new features and improvements.
sqlite-utils 4.0rc3 is a release candidate with new features including compound foreign key introspection and case-insensitive column matching.
Introducing Mnemosyne, a purely local, SQLite-based long-term memory solution for Hermes Agent, featuring ultra-low latency, offline operation, zero cost, and privacy control.
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.