Create Your Own Database from the Ground Up - Part 2 -Writing Your Data to Disk

[@timvw01]

Nice! Part 3, compare to popular database implementations?

[@flyingzeppo]

It would have been nice if this video/series was longer and went into the C code a bit more. But other than that i really enjoyed it. I know what my Christmas project will be now.

[@bazoo513]

Gary, you explain _everything_ !

[@akiratoriyama1320]

Thanks you very much for this!! Happy new year!!

[@GaryExplains]

Happy new year!

[@DK-ox7ze]

How do ACID compliant DBs write data to disk while maintaining good performance? I believe transaction journaling won't work there because it won't make it strictly durable and consistent.

[@GaryExplains]

Why do you say that journaling won't work for an ACID DB?

[@CANEHURRICANE]

Some adult training, highly appreciated Gary

[@GaryExplains]

My pleasure. 👍

[@AIBUNDY-p2m]

Thank you. Most helpful.

[@GaryExplains]

You're welcome!

[@oisinhickey5904]

You should do something on how to write or create a query language

[@cunningham.s_law]

so we lose the avl stucture when writing to disk? does this mean that the database is still in memory and that disk file is just a way to backup the in memory database. how do actual databses work? they can handle data that does not fit in memory

[@GaryExplains]

No the AVL structure isn't lost. By traversing the tree it is possible to write the data out in order, so that when it is read back in the tree is intact. The disk copy is just so that when you restart the program using the database it can reload its data. KVDVLite is memory based, so there needs to be enough RAM for the whole DB.

[@Allgone-b4k]

Merry Christmas happy holidays Gary explain how its 2024 nesrly ha. All the best 🎄

[@GaryExplains]

Same to you!

[@sahbibg9680]

I did the same challenge in CS165 at Harvard

[@GaryExplains]

Harvard! I hear that is a good school, except for that little thing about encouraging genocide on campus, but at least the CS course looks good 😜