How Does a Database Work?

• What format is knowledge saved in? (in reminiscence and on disk)
• When does it transfer from reminiscence to disk?
• Why can there solely be one major key per desk?
• How does rolling again a transaction work?
• How are indexes formatted?
• When and the way does a full desk scan occur?
• What format is a ready assertion saved in?

Briefly, how does a database work?

I’m constructing a clone of sqlite from scratch in C with a view to perceive, and I’m going to doc my course of as I am going.

“What I can’t create, I don’t perceive.” – Richard Feynman

sqlite structure (https://www.sqlite.org/arch.html)