AI Weekly Malaysia

Simon Willison released alchemy-utils 0.1a0, a cross-database version of his sqlite-utils library built on SQLAlchemy that supports PostgreSQL, SQLite, and DuckDB. He generated the prototype using Codex and GPT-5.6 Sol Ultra with red/green TDD, taking very few follow-up prompts to reach an alpha release. He also used Codex to optimize a CSV-to-DuckDB insertion task from nearly an hour down to 35 seconds.

Why: It provides a concrete blueprint for using AI coding agents to build and optimize real, test-driven open-source projects from scratch using uv, pytest, and iterative prompting. You can also use the resulting CLI to quickly inspect or populate PostgreSQL, SQLite, and DuckDB databases via one-liners.

Tailscale traced a series of outages starting August 2025 to a 16-year-old bug in SQLite's write-ahead log checkpointing process. After a six-month investigation, SQLite maintainers had to build a new VFS activity logging tool (funded by Tailscale) just to reproduce the issue, which resisted all initial debugging attempts. Tailscale has used SQLite as its primary database since 2022, and the corruption first surfaced during their routine snapshot-to-S3 backup pipeline.

Why: If you ship SQLite in production with WAL mode and periodic snapshot backups, this postmortem is a direct warning that WAL checkpoint corruption can surface silently and be extremely hard to reproduce. Database learners and builders should read the Tailscale write-up before assuming SQLite's WAL is bulletproof in backup-heavy workloads, and consider whether their own backup pipeline could hit the same edge case now that the bug is documented.

Tailscale experienced 19 separate SQLite database corruption incidents over six months, traced to a 16-year-old WAL-reset bug deep in SQLite. Their architecture uses one SQLite database per shard with a single Go writer, and their backup pipeline snapshots the full DB file to S3 every few minutes—corruption was first detected when a downstream data pipeline reading those S3 backups reported an error.

Why: If you run SQLite in production and take file-level backups or snapshots (especially with WAL mode), you should run PRAGMA integrity_check against your backups routinely—Tailscale's corruption was invisible to the live writer and only surfaced from the backup consumer. Anyone shipping SQLite-backed services should review whether their backup method correctly handles WAL state.

A 16-year-old SQLite write-ahead log (WAL) checkpointing bug caused recurring database corruption in Tailscale's tailnet infrastructure starting August 2025, taking six months to diagnose. Tailscale funded SQLite maintainers to build a new virtual file system logging tool to reproduce the issue, which engineer Alex Chan described as resisting all initial debugging attempts including checks on POSIX locks, memory management, and thread safety.

Why: If you ship SQLite as a primary database under continuous backup snapshots, this postmortem is a concrete lesson in how deep storage-layer bugs can masquerade as application-level corruption for months. The debugging methodology—systematically ruling out POSIX lock, memory, and threading theories before isolating checkpointing—is worth studying before you hit a similar wall. The fact that SQLite maintainers themselves had to write new tooling to reproduce it should reset expectations about how 'reliable and well-known' doesn't mean 'bug-free' for critical infrastructure.