Topic
#databases
3 posts
databases
7 min read
#06
TigerBeetle Would Rather Crash Than Guess
Two asserts buried in a financial database. One panics if your hardware lies about time. The other panics if you allocate memory after startup. Together, they're the whole philosophy.
databases
8 min read
#03
How Postgres Prevents Both Deadlock AND Livelock in Upserts
A one-line rule buried in PostgreSQL's INSERT ... ON CONFLICT code prevents two of the nastiest concurrency bugs at once: the transaction with the higher XID backs out.
databases
7 min read
#01
The Hidden Message in SQLite's Random Number Generator
Four magic numbers in SQLite's source code spell out a secret phrase. It's not an easter egg - it's cryptography's way of saying "trust me, there's no backdoor."