The book should probably cover the query engine parts (sql parsing, query plans etc) and the persistence part.
Recommendations will be appreciated.
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.
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
- 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...