Explore the inner workings of databases by building one from scratch using Python. Learn how to create an interface for communicating with the database, develop a simple SQL-based language for queries, and implement a REPL using Prompt toolkit. Dive into data storage techniques, starting with in-memory dictionaries and progressing to disk persistence. Discover the importance of indexing by implementing a basic B-tree index to improve query performance. Gain insights into future improvements such as ACID transactions, concurrency support, and lock handling. By the end of this talk, gain a deeper understanding of database fundamentals through hands-on development.
Overview
Syllabus
Talk - Sangarshanan: Build-a-Database with Python
Taught by
PyCon US