sqlite

John Regehr describes using tis-interpreter to search for undefined behavior in SQLite, finding bugs like dangling pointer uses and uninitialized reads that other tools missed.

Simon Willison experiments with storing SQLite text revision histories as compressed JSON arrays, comparing whole-blob and chunked storage approaches. A simulation of 1,000 edits compressed 20.4 MB of revision text into 80.3 KB using Zstandard.

An open-source, zero-dependency SQLite debugging tool that tracks database changes and allows instant rewinding to any previous state via snapshots, a web UI, and a CLI watcher daemon.

An AI agent called KISS Sorcar achieved a verified 1.59x geometric-mean speedup on SQLite across four benchmarks in under 8 hours for less than $150, passing over 1 million SQLite tests. This highlights the growing capability of coding agents.

celld is a self-hosted, distributed server that runs Cloudflare Workers and Durable Objects code unchanged, using your own S3 bucket for storage and coordination. It claims significantly lower costs and sub-millisecond warm latencies at scale, with data stored in SQLite/LTX format.

Deno's celld is an open-source daemon that runs Cloudflare Workers and Durable Objects on your own machines, using SQLite per object and an S3-compatible bucket for replication and coordination without a control plane.

The author argues that agent memory layers should skip LLM-based extraction for deciding what to remember, instead using simple storage, embeddings, and retrieval, exemplified by their open-source memU tool.

Cloudflare Computer is a virtual filesystem inside a Durable Object that gives AI agents a persistent workspace, using SQLite for storage and pluggable runtimes (container, shell, JavaScript). It's a preview-only open-source package.

Cortex is an open-source local memory and autopilot layer for coding agents like Claude Code and Codex, using SQLite to persist context across sessions and optionally run tasks autonomously.

SQLite developers share their reliability experience, derived from the DO-178B avionics standard, ensuring code quality through 100% MCDC test coverage, emphasizing the philosophy: 'if it hasn't been tested, it doesn't work.'

Cloudflare released a preview library called computer that provides a SQLite-based virtual file system in Durable Objects, with support for multiple runtime backends (container, isolated shell, isolated JavaScript), offering persistent workspaces for Agents.

JFrog researchers debunk a batch of SQLite CVEs published by a suspicious GitHub repo, finding the advisories are likely LLM-generated slop with non-existent code references and non-working PoCs, prompting NVD downgrades.

Simon Willison announces the 1.0 release of condense-json, a Python library that condenses JSON by replacing repeated substrings with compact references, saving space in SQLite logs for LLM.

The author open-sourced o8, an MIT-licensed orchestrator that manages multiple coding agents in isolated git worktrees, with a merge gate, audit trail, and mobile approvals.

Rivet engineers detail how they built a zero-disk, S3-tiered storage engine for SQLite, enabling isolated databases with instant startup, low-latency writes, point-in-time recovery, and bottomless storage for millions of Actors.

The 2026 Cesium Developer Conference session recordings are now available, featuring talks on geospatial 3D, AI, 3D Tiles 2.0, and a keynote by SQLite creator D. Richard Hipp.

A deep-dive into optimizing SQLite for production use, covering Write-Ahead Logging mode, checkpointing strategies, concurrency improvements, and custom Virtual File System layers to achieve low-latency app server performance.

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.