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 un

[riywo]

これ好きな言語でやろうっと。

[kawasin73]

REPL が sqlite っぽいだけであって、File format なども sqlite ではなかった。

[kane-please]

データベース　ハンズオン

[toge]

SQLITEのサブセットを作りながらRDBの基本を学ぶ資料

[igrep]

面白そう

[darwinia]

これいいな。スクラッチでDB書くの

[sezemi]

よいテーマや

[gfx]

“Writing a sqlite clone from scratch in C”

[fjwr38]

これいいね

[matsumoto_r]

これは良い知見

[yujiorama]

きしださんもRBD実装してたなぁ https://www.slideshare.net/nowokay/with-java8

[suu-g]

作りたい

[master-0717]

実装してみたシリーズ

[nyaocat]

“Writing a sqlite clone from scratch in C”

[zetta1985]

あとでやる

[deeeet]

Writing a sqlite clone from scratch in C