One question keeps coming up when people start going deeper into databases:

How does a database actually work underneath?

Not the SQL part. Not the API. Not the dashboard.

The real part:


Where is the data actually stored?
Is it kept in memory, on disk, or both?
How are rows and columns laid out?
Why does a query return quickly instead of...