Tracking down the 16-year-old WAL-reset SQLite bug

kept by eddie aug 22

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.

How Tailscale helped find the SQLite WAL-Reset bug
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.
also on Richard Hipp, SQLite, #open-source, #software-engineering, #developer-tools
Show HN: LocalGPT – A local-first AI assistant in Rust with persistent memory
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.
also on SQLite, #programming-languages, #open-source, #developer-tools
We had a team of agents rebuild SQLite from its 835-page manual. It created a replica in Rust which passed 100% of a held-out test suite.
A team of AI agents rebuilt SQLite from its 835-page manual into a Rust replica that passed all held‑out tests, with costs varying 15× across model mixes.
also on SQLite, #open-source, #software-engineering, #developer-tools