Explore the inner workings of databases in this 29-minute conference talk from EuroPython 2022. Dive into the process of building a database using Python, starting with creating an interface and SQL-based language for communication. Learn how to develop a datastore, initially using an in-memory dictionary and later persisting data to disk. Discover the importance of indexes by implementing a basic B-tree structure to improve query performance. Gain insights into future enhancements 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 construction.
Overview
Syllabus
Build-A-Database with Python - presented by Sangarshanan
Taught by
EuroPython Conference