Database as queue, then Kafka, then FoundationDB
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.
Read the note 1 min read
From the notebook
databases.
6 notes on this topic.
The SQLite bug that hid in plain sight for 16 years
Tailscale traced database corruption back to a WAL-mode edge case that survived billions of deployments since 2010.
Read the note 1 min read
Someone built a time machine for SQLite queries with zero dependencies
A developer built a tool that lets you rewind SQLite databases to any point in their history, no external dependencies required.
Read the note 2 min read
SQLite stores null bytes in strings without warning
SQLite will happily store NUL characters in text columns. Your application layer might truncate them silently.
Read the note 1 min read
Someone built a ray tracer in SQL and it actually works
ClickHouse's query language is Turing-complete. Someone proved it by rendering 3D scenes with recursive CTEs and array functions.
Read the note 1 min read
SQLite corruption is usually your fault
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.
Read the note 1 min read