The purpose of this project is to aid in having a more complete understanding of how databases work.
Questions to be answered by this project:
- 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?
https://github.com/danistefanovic/build-your-own-x#build-your-own-operating-system