Topic
#databases
2 posts
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."