index.md · teleis/db_tutorial

加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

免费加入

文件

该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。

克隆/下载

index.md 907 Bytes

一键复制编辑原始数据按行查看历史

提交于 2017-09-17 21:00 . Feynman Quote

---
title: 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](https://www.sqlite.org/arch.html) from scratch in C in order to understand, and I'm going to document my process as I go.

# Table of Contents
{% for part in site.parts %}- [{{part.title}}]({{site.baseurl}}{{part.url}})
{% endfor %}

> "What I cannot create, I do not understand." -- [Richard Feynman](https://en.m.wikiquote.org/wiki/Richard_Feynman)

{% include image.html url="assets/images/arch2.gif" description="sqlite architecture (https://www.sqlite.org/arch.html)" %}

马建仓 AI 助手

尝试更多

代码解读

代码找茬

代码优化

https://gitee.com/fhyfhy17/db_tutorial.git

git@gitee.com:fhyfhy17/db_tutorial.git

fhyfhy17

db_tutorial

master

teleis/db_tutorial

简介

发行版

贡献者

近期动态

teleis/db_tutorial .gitee-modal { width: 500px !important; }

简介

发行版

贡献者

近期动态

搜索帮助

teleis/db_tutorial