SQLite

How we tracked down a 16-year-old SQLite bugOriginal article link with an AI-written directory summary

Alex Chan recounts the investigation of repeated Tailscale outages that exposed a long-standing SQLite bug. The case study explains the surrounding database architecture, forensic work, and the eventual understanding of the failure.

Case study · SQLite · Debugging

Learning a few things about running SQLiteOriginal article link with an AI-written directory summary

Practical lessons from operating SQLite behind a Django website. Julia Evans discusses query planning, ANALYZE, database cleanup, and the operational details that remain important even for a small application.

Blog post · SQLite · Databases

A database for 2022Original article link with an AI-written directory summary

David Crawshaw explains Tailscale's move from etcd toward a SQLite-based database design. The account emphasizes familiar tools, indexing, and the maintenance burden that bespoke infrastructure places on a growing team.

Case study · SQLite · Software Architecture