4 ms·
Any good learning resources for implementing your own DBMS, and DB internals? (not DB theory, not SQL, not intro).
by fizixer 6y ago
Any good learning resources for implementing your own DBMS, and DB internals? (not DB theory, not SQL, not intro).
- macintux 6y agoYou might find useful guidance here: http://www.aosabook.org/en/ http://www.aosabook.org/en/
- otoolep 6y agohttps://github.com/rqlite/rqlite https://github.com/rqlite/rqlite https://github.com/rqlite/rqlite/blob/master/DOC/DESIGN.md https://github.com/rqlite/rqlite/blob/master/DOC/DESIGN.md I built a distributed database using Raft and SQLite, and I put a lot of thought into its design and implementation -- to make it as simple (but not simplistic) and clear as possible. One goal was clear separation between the consensus layer, the database access, and the HTTP API. I think it's a good resource to study (even if I do say so myself).
- gangulo 6y agoCMU DB Group has all their lectures on youtube. Checkout 15445 and 15721 https://www.youtube.com/channel/UCHnBsf2rH-K7pn09rb3qvkA https://www.youtube.com/channel/UCHnBsf2rH-K7pn09rb3qvkA
- cgh 6y agoYes, the Postgresql source and associated docs. It's a well-structured code base that is easy enough to dive into, if you don't try to understand the whole thing at once. I'm slowly reading it in bits and pieces. Here's a Github mirror so you can browse around: https://github.com/postgres/postgres https://github.com/postgres/postgres Note that the offical repo is at git.postgresql.org.
- agambrahma 6y agoShould mention the newer OReilly "Database Internals" book here: https://www.oreilly.com/library/view/database-internals/9781492040330/ https://www.oreilly.com/library/view/database-internals/9781...
- mitchtbaum 6y agohttps://github.com/speakeasy-engine/contentdb https://github.com/speakeasy-engine/contentdb