video1.0<iframe src="https://www.loom.com/embed/e6867a04bf5e42dc870bd861d2270afd" frameborder="0" width="1660" height="1245" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>12451660Loomhttps://www.loom.com12451660https://cdn.loom.com/os/loom-media-content/loom/8809671e-4fce-41f6-b4da-168be2caae4a/6087ff69-dcde-4a8e-9497-bf6e09b27f4a/sessions-thumbnails-e6867a04bf5e42dc870bd861d2270afd-f4810705fa83860f.gif/binary?authToken=eyJraWQiOiJtaWNyb3MtZ3JvdXAvdGRwLW9zLWFyY2hldHlwZS9xOXVsZGNqYTRwbnE3Y2N1IiwiYWxnIjoiUlMyNTYifQ.eyJicyI6Imxvb20tbWVkaWEtY29udGVudCIsImF1ZCI6InRkcC1vcy1hcmNoZXR5cGUiLCJuYmYiOjE3OTM4MDU3NTAsInRpIjoiMDRlYjdiNzktYzc5MC00OTJlLWI1NDQtMGUwNDIxOGEyNGY1IiwiYWRpIjoibG9vbS9sb29tIiwiaXNzIjoibWljcm9zLWdyb3VwL3RkcC1vcy1hcmNoZXR5cGUiLCJwaWQiOiJlY2VlNzY3ZS0xYThmLTQ1MGMtODc3MC1mY2Q4NTE2YmVkMjciLCJ3YSI6ImZhbHNlIiwib2lkIjoic2Vzc2lvbnMtdGh1bWJuYWlscy1lNjg2N2EwNGJmNWU0MmRjODcwYmQ4NjFkMjI3MGFmZC1mNDgxMDcwNWZhODM4NjBmLmdpZiIsImV4cCI6MTc5MzgwNjM1MCwiaWF0IjoxNzkzODA1NzUwLCJqdGkiOiI2ZmFmMGNhNy0zYmNhLTQ5MDgtYjU3OC04ZmUxZDVkOWFhNzYifQ.W7naDo_MkEoYR-f7fHn_wkvIJlQfjNn_aap1yJexJQbxAHpLPp1hNCTTN91dzUvcTbDjj-yTEcoBMrd5vXXEy85BFsUnsGp4BVPbD16tkZIT1yeDmTz2_k4lP59yzl18JxX2262qe8sH6g-n4Z-oE4oYXErH8aGpsqO5N0ifH7GncUht_gHOXhczhkzXMUxvZvyrEXVuR7sWo2Cei0TSKNPolvzXrGa3rbKfAsEDHqcQM3v4Dqpjsmcka4ItLmtG46LsmYsKo-Cj73Q45tUCiohLzVzYi8Yj1fo3Y8ox5kkMFtIOgXnjmwsA-_nGhgjhiPG_4gtchg32Tir7yZlO7Q&Expires=1793806350&Signature=kcOkNpkDqdsCVG7oHYWPUfqvvwRMq7FLBEP2F-7FEyW4fezSIscLwYPUC25IldkNfPP1R9NvHAcF97NhI%7E20SIxdVZg1ADv3qr4dw8bJU6U99l36TN%7EkZwRhGJAWFZtL9vgS3TssD31x5H-VHUZg1QOUxPCGIbbXhoJ022dpHeZm3w33swo-wGUw5JHeIJ5VnO%7EeBRsyN5ojH6zVTajmk9CDdMMPcU9HqVYRxrY3PLFkr1o4q0pz-O4MhRfjDD%7EiPCcF%7Evn3RCsuTgluphQ8uqNL4q8fhJ4oPSiQu-4QzypQd868RTh8WxuflQAaLwgAZPXqQWnAlys4H69uRqnqOw__&Key-Pair-Id=KQOSYIR44AIC0347.935MiniDatabase: Crash-Safe, Zero-Dependency EngineThis Loom presents MiniDatabase, a crash-safe, zero-dependency relational database engine built from scratch using Python’s standard library. Aryan Lokesh and Punita K describe the architecture where queries flow through an SQL parser and execution layer into a storage engine with a write-ahead log for durability and recovery that rebuilds indexes after failures. They demonstrate a deployed web interface that supports create table, insert, select, and drop table, showing inserted rows and an empty set after deletion. The implementation uses a custom binary record format with a CRC32 checksum and an append-only persistent storage with an in-memory index, plus an interactive CLI and TCP client server supporting core SQL and transaction commands.