Tag
SQLite's WAL mode can cause 'database is locked' errors for short-lived read-only connections due to internal locking of the WAL index file; a busy timeout or switching to DELETE mode can resolve the issue.
Built two local AI agents that share a memory to enforce past decisions, preventing the AI from switching databases without approval. Runs fully on laptop, no cloud.
Stinkpot is a lightweight, SQLite-backed shell history searcher for bash, similar to atuin but with fewer features and around 400 lines of Go.
Agentlas is a free, open-source agent memory system that uses a local SQLite database combined with lightweight embedding and keyword search to achieve 96.4% on LongMemEval without calling an LLM, outperforming alternatives like mem0 and supermemory.
Cursor's team of AI agents reconstructed SQLite from its manual into Rust, passing all tests, with costs varying 15x based on model mix.
A thread discussing Cursor's experiment where a team of AI agents rebuilt SQLite from its manual in Rust, achieving 100% test pass rate with significant cost variation depending on model mix. Takeaways include using frontier models for decomposition and cheaper workers for implementation.
Cursor's new agent swarm design uses planner and worker models to decompose tasks into a tree structure, achieving significant cost savings and quality improvements. In a test rebuilding SQLite from scratch in Rust, the new swarm reached 80% pass rate in four hours while the old swarm failed.
A browser-based tool that runs SQL queries against SQLite and provides plain-English explanations of the query plan and bytecode output.
A resource containing 933 legally structured chunks of the EU AI Act along with BGE-M3 embeddings, packaged in a single SQLite file for easy use in retrieval-augmented generation systems.
This article demonstrates how to detect full table scans in SQLite using its statement statistics API, and suggests integrating this into Rails to warn or raise in test/development environments.
SQLite allows NUL characters in strings but this can cause unexpected behavior in string functions and CLI output; the page explains how to detect and remove embedded NULs.
The article argues that SQLite's defaults for foreign key constraints and type enforcement are problematic and suggests adopting Rust-style editions to allow users to opt into safer defaults.
Peter Gostev built a Doom-like game using SQLite as the game engine, with ray tracing via recursive CTE, and integrated with Datasette for a real-time web interface. The project was created using GPT-5.6 Sol and demonstrates the creative potential of using SQL for game logic.
Lobste.rs has migrated its database from MariaDB to SQLite, resulting in lower CPU and memory usage, reduced costs, and improved site performance. The migration process and background are detailed.
The author discusses building six AI agent harnesses and emphasizes the need for a dedicated database to track agent execution, state, and learnings, beyond just observability tools.
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.