How Does a Database Work?
source link: https://cstack.github.io/db_tutorial/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Let's Build a Simple Database
Writing a sqlite clone from scratch in C
View on GitHub (pull requests welcome)
How Does a Database Work?
- What format is data saved in? (in memory and on disk)
- When does it move from memory to disk?
- Why can there only be one primary key per table?
- How does rolling back a transaction work?
- How are indexes formatted?
- When and how does a full table scan happen?
- What format is a prepared statement saved in?
In short, how does a database work?
I’m building a clone of sqlite from scratch in C in order to understand, and I’m going to document my process as I go.
Table of Contents
“What I cannot create, I do not understand.” – Richard Feynman
This project is maintained by cstack
Hosted on GitHub Pages — Theme by orderedlist
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK