4 ms·
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
by throwamon 5y ago
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.
- comonoid 5y agoAlex Petrov's "Database Internals", perhaps. I know nothing better... https://www.databass.dev/ https://www.databass.dev/
- fmeyer 5y agoSilberschatz’s Database System Concepts is a good starting point
- javajosh 5y agoIt'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.)
- throwaway81523 5y agoI found the sqlite3 implementation docs to be very educational, particularly the ones about the query planner.