Ask HN: Book Recommendation on Database Internals

[finlaybw]

I am looking for books (any other resource will do too) that can help with learning database internals. Specifically the core components that makes up a database and how to implements.

The book should probably cover the query engine parts (sql parsing, query plans etc) and the persistence part.

Recommendations will be appreciated.

[jpamata]

"How Query Engines Work" by Andy Grove, you build one in Kotlin: https://leanpub.com/how-query-engines-work

The author also made it available for free at https://howqueryengineswork.com/00-introduction.html

On implementation, my favourite is "Database Design and Implementation" by Ed Sciore, you write a relational DB in Java, including the parser.

[finlaybw]

> "How Query Engines Work" by Andy Grove, you build one in Kotlin: https://leanpub.com/how-query-engines-work

I have come across this, but unfortunately it feels like a book written for someone who already knows the topic. For example, the logical plans did not even bother explaining what logical plans are, where it fits into the whole picture etc https://howqueryengineswork.com/05-logical-plan.html

[mejutoco]

I don‘t know if you:

- did not do any research

- want someone to link to the book "database internals"

But, in the spirit of the most charitable interpretation and, as it is a good book:

https://www.goodreads.com/book/show/44647144-database-intern...

[finlaybw]

Took a look at this, but it looks like it is missing the query engine parts, which is one of the things I am currently interesting in learning more about - perhaps more so than the persistence and distributed parts

[billconan]

https://news.ycombinator.com/item?id=35666598

[sitkack]

In that vein

https://hn.algolia.com/?dateRange=all&page=0&prefix=true&que...

[sitkack]

https://www.youtube.com/@CMUDatabaseGroup