Someone built a Go library to stop you shooting yourself in the foot with SQLite
A new Go wrapper enforces WAL mode, busy timeouts, and foreign keys by default. Turns out most SQLite footguns are configuration problems, not the database itself.
From the notebook
7 notes on this topic.
A new Go wrapper enforces WAL mode, busy timeouts, and foreign keys by default. Turns out most SQLite footguns are configuration problems, not the database itself.
Tigris Data swapped their database-backed queue for Kafka, then swapped Kafka for FoundationDB. The reasons why tell you more about queue design than any tutorial.
Tailscale traced database corruption back to a WAL-mode edge case that survived billions of deployments since 2010.
A developer built a tool that lets you rewind SQLite databases to any point in their history, no external dependencies required.
SQLite will happily store NUL characters in text columns. Your application layer might truncate them silently.
ClickHouse's query language is Turing-complete. Someone proved it by rendering 3D scenes with recursive CTEs and array functions.
The SQLite team keeps a public list of every way you can break their database. Turns out most corruption comes from ignoring fsync or writing to the file yourself.