Reading up on SQLite

Farid Zakaria shows an executable as a SQLite database, letting a web server store code, routes, and state in one file, queryable via SQL.

The SELF format turns executables into SQLite databases, letting programs store and modify their own state and code via SQL, demonstrated by a self‑hosting web server.

Researchers uncovered a 16‑year‑old bug in SQLite’s WAL‑reset handling that could cause database corruption during routine checkpoint sequences and affect performance.

An unindexed CTE made a fuzzy-search query balloon CI benchmark time from ~9 minutes to 44 minutes; switching to a temp table cut it to ~1 second.

The author demonstrates four methods—exec, importNative, giant Nix file, and WASM—to embed SQLite queries in Nix, comparing their speed and resource usage.

SQLite can replace many specialized systems—search, document store, queue, cache, vector DB, etc.—by serving as a single-file, zero‑maintenance database for applications.

Tailscale engineers and SQLite developers collaborated to identify and fix a rare data race bug in SQLite's WAL checkpointing that caused months of database corruption in Tailscale's control plane.

The article argues DuckDB outperforms SQLite for analytical queries due to its columnar storage and vectorized execution, recommending it for data analysis tasks over SQLite's transactional strengths.

Cursor’s new agent swarm design builds SQLite in Rust with far higher success and far lower code size and cost than its earlier swarm.

Lobsters successfully moved from MariaDB to SQLite, cutting CPU and memory use, halving VPS costs, and keeping the site responsive after migration.

SQLite's strict tables enforce column affinities and reject invalid data, making schemas safer and more predictable for applications.

Birdclaw is a local-first Twitter workspace that imports archives and caches live reads into a single SQLite database, accessible via CLI and web app.

Simon Willison introduces a new plugin hosting sandboxed HTML+JavaScript apps inside Datasette, enabling custom read/write SQL interfaces within tight iframe constraints.

Open source software production defies standard economic theory by producing stable, valuable, and widely-used goods despite lacking price signals, contracts, or incentives that textbooks predict are necessary.

Putting a durable buffer between AI agents and LLM providers prevents token waste and re-billing when a process crashes mid-stream, with resumable streaming and crash recovery using the same mechanism.

Many SaaS apps don't need servers; shipping the full backend to the browser via WASM, SQLite, and OPFS enables local-first single-user apps.

The US Library of Congress recommends SQLite as a preferred storage format for datasets, alongside XML, JSON, and CSV, prioritizing long-term readability and low patent risk.

CLI Printing Press automates generating token-efficient Go CLIs, MCP servers, and Claude Code skills from any API by studying official docs, community tools, and sniffed web traffic.

Honker is a SQLite extension that provides durable queues, pub/sub, and task scheduling within the same database file, enabling atomic transactional enqueue without a separate broker like Redis.

SQLite is the most widely deployed database engine, with billions of copies in smartphones, computers, and other devices, possibly outnumbering all other databases combined.

Slacrawl is a Go CLI tool that mirrors Slack workspace data into local SQLite for offline search, querying, inspection, and git-backed archive sharing.

Honker brings Postgres NOTIFY/LISTEN semantics to SQLite by polling the WAL file, enabling cross-process push-style event delivery with single-digit millisecond latency without a broker.

ggsql is a SQL extension that enables declarative data visualization within SQL queries using the Grammar of Graphics, currently supporting DuckDB and SQLite.

The article argues that for many small-scale, read-heavy, or single-user applications, flat files like JSON can outperform a full DBMS, but warns that scaling or adding write concurrency will force you to rebuild a database.

Running multiple $10K MRR businesses on a $20/month stack with SQLite, a VPS, and minimal services is possible, but the approach is controversial among developers.

Running an e-commerce store on SQLite reduces infrastructure complexity but requires care with concurrent writes, JSON types, and backups.

Turbolite is a SQLite VFS serving sub-250ms cold JOIN queries from S3 using B-tree-aware page grouping and compression.

Coding agents lower the cost of rewriting codebases, but codebases encode tacit knowledge and coevolve with people, preserving value that specs alone cannot capture.

An AI agent diagnosed and redesigned its own memory system, improving recall from 60% to 93% by adding 'why' fields to decisions, costing $2 in API calls.

Defining clear, testable acceptance criteria upfront dramatically improves LLM-generated code quality, shifting their output from plausible to actually correct.

As AI clones open source work easily, tests, API contracts, and surface area become the new commercial moat, clashing with open documentation incentives.

Micasa is a terminal-based home maintenance tracker that stores all data in SQLite, offering schedules, project tracking, and contractor management.

LocalGPT is a Rust-based local-first AI assistant with persistent memory, but relies on remote LLM API keys, sparking debate on what 'local' truly means.

Turso rewrites SQLite in Rust to enable a new database engine compatible with SQLite's file format while addressing C's memory safety issues and adding support for concurrent writes.

The Hacker News commenters debate whether Postgres can truly replace specialized databases like Redis or Elasticsearch, with pushback on performance claims for caching and search.

OpenAI released a macOS app for its Codex coding agent, adding a UI, skills, and automations, and reporting over a million developers have used it.

HN commenters debate soft delete tradeoffs, noting schema drift, compliance conflicts, and performance issues, with many preferring archival tables or CDC over flags.

Hacker News commenters share diverse local RAG setups including vector databases, SQLite FTS5, BM25, and lightweight tools like Chroma, Qdrant, and AnythingLLM.

Andy Pavlo's 2025 database review covers PostgreSQL's continued dominance, emerging trends like vibe coding, and commentary on SQLite, DuckDB, and MCP security risks.

A tool serves 22 GB of Hacker News history via SQLite compiled to WASM, fetching only needed database shards in the browser.

SQLite uses four independent test harnesses, 100% branch coverage, and millions of test cases for reliability.

SQLite can index JSON fields at full B-tree speed by creating virtual generated columns with json_extract and indexing them.

Turso, a serverless SQLite-compatible database, aims to improve concurrency and distributed performance over standard SQLite while maintaining compatibility.

SQLite achieves over 100k transactions per second on a billion-row dataset by avoiding network overhead, though durability and HA remain trade-offs.

PGlite is an embeddable Postgres database that runs in browsers and Node.js, enabling local-first and testing use cases.

PocketBase is an open-source backend combining SQLite, realtime subscriptions, authentication, file storage, and an admin dashboard in a single Go binary.