3 ms·
Cmu course is a must watch really
by etiennebch 6y ago
Cmu course is a must watch really
- cm2187 6y agoParticularly given that the professor is doing his lecture from his bathtub!
- zerr 6y agoYeah, it's good but somewhat diverged from the practical part unless you are an onsite student. I wonder what are alternatives (video lectures or textual resources) with more hands-on approach implementing database systems.
- etiennebch 6y agoNot sure if this is what you are looking for but I found this paper useful on architecting databases. I read it as a complement to the CMU videos. https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf Otherwise there is surprisingly a lack of information about architecting databases online and you have to go to the source code of SQLite and PostgreSQL. I suspect this is because databases are some of the most complex systems in computer science and involve many trade secrets.
- SQLite 6y agoOn-line docs describing the design and internal operation of SQLite include: https://sqlite.org/arch.html https://sqlite.org/arch.html https://sqlite.org/optoverview.html https://sqlite.org/optoverview.html https://sqlite.org/opcode.html https://sqlite.org/opcode.html https://sqlite.org/queryplanner.html https://sqlite.org/queryplanner.html https://sqlite.org/atomiccommit.html https://sqlite.org/atomiccommit.html Inspired by this post, I started yet another: https://sqlite.org/draft/howitworks.html https://sqlite.org/draft/howitworks.html
- polskibus 6y agoIt's awesome, but not for learning how to solve problems with SQL.
- pocket_cheese 6y agoOMG yes! Andy Pavlo is such a good teacher. I watched his entire lecture series, and it really helped me prepare for an interview. I couldn't recommend his MOOC enough if you really want to know how a database works. I just wish that the homework assignments were available to the public.
- diehunde 6y agoIt is, but not if you're trying to get better at SQL.