How Tailscale helped find the SQLite WAL-Reset bug

kept by eddie aug 13

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.

Tailscale | Secure Connectivity for AI, IoT & Multi-Cloud
Tailscale offers a zero-trust identity-based connectivity platform that replaces legacy VPNs for remote teams, multi-cloud, IoT, and AI workloads.
also on WireGuard, Tailscale, #developer-tools
Tracking down the 16-year-old WAL-reset SQLite bug
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.
also on Richard Hipp, SQLite, #open-source, #software-engineering, #developer-tools
Git at any scale
Cursor argues Git’s packfile‑based design hinders scalable hosting and presents Continuity, a S3‑backed write‑ahead log system that enables linear, consistent replication.
also on S3, #open-source, #developer-tools
Exa AI Research Blog | Semantic Search & Neural Network Search Engine
Exa built exa-d, a data framework using typed columns, declarative dependencies, and surgical fragment updates to manage a real-time web index at scale.
also on S3
Honker | Honker
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.
also on #database, SQLite, #open-source, #developer-tools