How Does a Database Actually Store Your Data?

Every backend engineer has run SELECT * FROM users WHERE id = 42 a thousand times. Most assume the...