The Internals of PostgreSQL

Re:The Internals of PostgreSQL by throwamon on Thursday February 17, 2022 @01:34PM (#30376786)

This may be a good place to ask: Are there any books that are something like "the SICP/HtDP of databases", in the sense of teaching fundamentals in a principled, mind-expanding way? Something that doesn't focus so much on internals, but on how to design and deal with data models and databases.

[ Parent | on HN ]

Re:The Internals of PostgreSQL by comonoid on Thursday February 17, 2022 @01:45PM (#30376947)

Alex Petrov's "Database Internals", perhaps. I know nothing better... https://www.databass.dev/

[ Parent | on HN ]

Re:The Internals of PostgreSQL by fmeyer on Thursday February 17, 2022 @01:56PM (#30377096)

Silberschatz’s Database System Concepts is a good starting point

[ Parent | on HN ]

Re:The Internals of PostgreSQL by javajosh on Thursday February 17, 2022 @08:54PM (#30381271)

It's funny but I think I learned about relational database theory (normal forms and such) from the early chapters and/or appendices of thick computer books written about products like Delphi, FoxPro, and MS Access. The data-modeling knowledge scaled up really well to stand alone database servers of various kinds! It's too bad there isn't something similar for new learners, some in-the-browser environment they could enter to try out their nascent SQL skillz. Ideally something with a big thick paper book, too! (The book is a shibboleth representing stability of API and seriousness of purpose, which are too-rare qualities in today's software products.)

[ Parent | on HN ]

Re:The Internals of PostgreSQL by throwaway81523 on Saturday February 19, 2022 @04:17AM (#30395624)

I found the sqlite3 implementation docs to be very educational, particularly the ones about the query planner.

[ Parent | on HN ]