sqlite-utils

Evidence (20)

• 5Simon Willison·8/12/2026open_source
  Alchemy Utils 0.1a0 brings SQLite-utils style APIs to multiple databases

  Simon Willison released an alpha of alchemy-utils, a new database-agnostic library and CLI inspired by sqlite-utils. The project uses SQLAlchemy to support multiple engines, including PostgreSQL, SQLite, and DuckDB, while preserving familiar methods such as insert, upsert, create, update, and table introspection.

• 8Hacker News·8/12/2026open_source
  Tailscale Traces Database Corruption to a 16-Year-Old SQLite WAL Bug

  Tailscale says months of repeated database corruption incidents in its control plane were ultimately traced to a long-standing SQLite WAL-reset bug. The company reports it fixed the issue and is publishing the incident details after 19 corruption events over six months that caused shard-level downtime and some lost configuration changes.

• 5Simon Willison·8/9/2026research
  SQLite prototype for compressed text revision history

  Simon Willison describes an experiment for storing full text revision histories in SQLite as a compressed JSON array of prior versions. A prototype using Zstandard reportedly reduced 20.4 MB of simulated revision text to 80.3 KB, with a suggested optimization of splitting history into smaller chunks to avoid repeated full recompression.

• 8Simon Willison·8/4/2026framework_update
  LLM 0.32 adds reasoning traces, OpenAI Responses support, and smarter logging

  LLM 0.32 is a major release that adds visible reasoning traces, support for server-side tools, redesigned content-addressable SQLite logs, and new model support including GPT-5.6. The update also introduces Python API changes for message-based prompts and event streaming, plus a new llm-chat-completions-server plugin and substantial llm-anthropic updates.

• 7Hacker News·8/3/2026security
  JFrog Questions Critical SQLite CVEs as AI-Generated Slop

  JFrog security researchers investigated a set of recently published SQLite CVEs that NVD and CISA had marked as critical or high. They reported that the cited code paths did not match the referenced SQLite versions, the proof-of-concept payloads did not reproduce crashes, and the advisories showed multiple signs of AI-generated content.

• 6Hacker News·7/29/2026research
  Optimizing SQLite for Production with WAL and VFS Tuning

  The article argues that SQLite can serve low-latency production app servers when it is run in-process and tuned correctly. It focuses on enabling WAL mode, managing checkpointing and concurrency, and using custom VFS layers to reduce blocking and latency.

• 3InfoQ·7/27/2026research
  Rethinking Web Data with Client-Side Event Sourcing

  Johannes Schickling discusses moving from a traditional three-tier web stack toward a local-first architecture. He describes building Overtone with client-side event sourcing and SQLite, and compares event sourcing with CRDTs for offline-friendly app design.

• 3Hacker News·7/25/2026product_launch
  Brolly launches a minimalist plain-text weather forecast site

  Brolly is a minimalist weather site designed for quick, at-a-glance forecasts in a single scrollable column. It shows 7-day and hourly weather data, plus features like previous-day logs, pollen and air quality forecasts, shareable URL-stored state, and backend rendering with lightweight JavaScript.

• 3Hacker News·7/24/2026open_source
  Stinkpot: Tiny SQLite-Backed Bash History Searcher

  Stinkpot is a small open source shell-history search tool for Bash that stores commands in SQLite and supports reverse search from the terminal. It focuses on session-agnostic history management and a TUI search experience, offering a simpler alternative to AtuIn for users who only need core history features.

• 4Simon Willison·7/18/2026product_launch
  SQLite Query Explainer

  Simon Willison introduced SQLite Query Explainer, a browser-based tool that runs SQL queries against a SQLite database and annotates the results of both EXPLAIN QUERY PLAN and low-level EXPLAIN output with plain-English explanations. The tool runs SQLite in Python through Pyodide and WebAssembly, aiming to make query planner and virtual machine behavior easier to understand.

• 3Hacker News·7/17/2026research
  Practical lessons from running SQLite in production

  The author shares operational lessons from using SQLite on a Django site, including the importance of running ANALYZE to improve query planning and the challenges of long-running cleanup jobs that block other writers. They also describe backup workflows using VACUUM INTO and restic, highlighting that SQLite can work well for small sites but still requires database operations discipline.

• 4Hacker News·7/15/2026research
  Proposal to add Rust-style editions to SQLite

  A blog post argues that SQLite should adopt Rust-style editions to change unsafe defaults without breaking existing applications. It highlights two major issues: foreign key constraints are off by default, and permissive type affinity can allow values of the wrong type to be stored in columns. The post presents editions as a way to improve safety while preserving compatibility.

• 7Hacker News·7/15/2026product_launch
  Telegram launches serverless backend for bots and Mini Apps

  Telegram Serverless lets developers run bot and Mini App backend code directly on Telegram’s infrastructure without provisioning servers or containers. It uses JavaScript modules, a V8 sandbox, a built-in SQLite-backed database, and a CLI workflow for deployment and schema migrations.

• 6Simon Willison·7/14/2026open_source
  Lobsters completes migration to SQLite

  The community site Lobsters has finished moving from MariaDB to SQLite after years of planning and testing. The new setup runs on a single VPS and is reported to reduce CPU usage, memory usage, and hosting costs while improving responsiveness.

• 3Simon Willison·7/14/2026framework_update
  Datasette 1.0a37 released

  Simon Willison released Datasette 1.0a37, a minor update to the open source tool for exploring and publishing data. The release includes performance and documentation improvements to the permissions system, and reverts a cosmetic API change that had broken many existing plugin test suites.

• 4Simon Willison·7/13/2026open_source
  DOOM built on SQLite

  Peter Gostev created DOOMQL, a small Doom-like game where SQLite and SQL handle movement, collision, enemies, combat, progression, and even per-pixel rendering. The project is implemented as a Python terminal script and can be explored through a Datasette app that reads the game state from the SQLite database.

• 4Simon Willison·7/12/2026framework_update
  sqlite-utils 4.1.1 adds safer table transforms

  sqlite-utils 4.1.1 changes table.transform() to raise a TransactionError when it is used inside an open transaction with foreign key enforcement enabled and destructive ON DELETE actions could be triggered. This prevents silent row deletions or modifications during table replacement, and the release also improves cross-linking between the CLI and Python API documentation.

• 3Hacker News·7/11/2026open_source
  Why strict tables are useful in SQLite

  The post argues that SQLite strict tables are a useful default because they prevent common type errors, such as inserting text into numeric columns. It also notes that strict mode rejects invalid column type declarations, while still allowing flexibility through the ANY type when needed.

• 6InfoQ·7/8/2026framework_update
  Airbnb Details Sitar-agent for Dynamic Kubernetes Configuration

  Airbnb engineers described Sitar-agent, a Kubernetes sidecar used to deliver dynamic configuration to tens of thousands of pods with updates arriving several times per minute. The system was redesigned around Java, Amazon S3 snapshot bootstrapping, and a migration from Sparkey to SQLite to improve reliability, startup speed, and configuration availability at scale.

• 2Simon Willison·7/7/2026framework_update
  sqlite-migrate 0.2 released as a compatibility shim

  Simon Willison released sqlite-migrate 0.2, a simple SQLite migration system based on sqlite-utils. This version effectively retires the library by turning it into a compatibility shim built against the new sqlite-utils 4.0 dependency.