{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/e6867a04bf5e42dc870bd861d2270afd\" frameborder=\"0\" width=\"1660\" height=\"1245\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1245,"width":1660,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1245,"thumbnail_width":1660,"thumbnail_url":"https://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.eyJicyI6Imxvb20tbWVkaWEtY29udGVudCIsImF1ZCI6InRkcC1vcy1hcmNoZXR5cGUiLCJuYmYiOjE3OTM4MDU3NzMsInRpIjoiNzZkNzFkOWItNDMyMS00NDA3LTliY2QtZjg2ZTc1ZjAxZTFmIiwiYWRpIjoibG9vbS9sb29tIiwiaXNzIjoibWljcm9zLWdyb3VwL3RkcC1vcy1hcmNoZXR5cGUiLCJwaWQiOiJlY2VlNzY3ZS0xYThmLTQ1MGMtODc3MC1mY2Q4NTE2YmVkMjciLCJ3YSI6ImZhbHNlIiwib2lkIjoic2Vzc2lvbnMtdGh1bWJuYWlscy1lNjg2N2EwNGJmNWU0MmRjODcwYmQ4NjFkMjI3MGFmZC1mNDgxMDcwNWZhODM4NjBmLmdpZiIsImV4cCI6MTc5MzgwNjM3MywiaWF0IjoxNzkzODA1NzczLCJqdGkiOiJiZjA5MzUwMy0zOGU0LTQ3NTctYWRiYi0xZjRiNjcwM2YxMzUifQ.LyOVcymzLjWt4foF3HdsZzFZSo6E-lqXgVJgCXt6P1R6dHham2CxBlHcvWsof_3WsidKQ6sM-A-lrZ_cVgjXQgzEIFSGWD4M3EGbKP9nZsbMoxXc91OI1m7DsWisgNhlXyxMeVAxGjzgbNWFXAM0O2KxrnBrH7AybG9GgTwyTdVK86zLFpCKgYrEBOuBL3F-4zD7WKBmmCEDa8BnvlzVVykAgG2u7VjoWyitR_qBPEt8LL93VoDqjo9aQNcBfbzQL_v8aQVGlq-9EyTEbDh5wNW9n324QHyHyDMB3GbrgUNU2xG_D8x2g5cUvJNk6iOKW1RSwmoRoinvDSMCPA5QKQ&Expires=1793806373&Signature=U0Blss0pmQAtE8t943p3lKfil%7EIPfgcDk6q94mVxYB58S9u9Cni7ul%7EiKFI9Sr9ACmcks2952Ov3HUgi6YPcVdNmu4DDYVGcUOUQMN1A10FbTn8rplRWobsmdsfRjk3s27Ynw3kqJS5sJOsQhj8JBAZkwmw3UM%7EjWXfjEzldDoi7AzqWxdGQ4OaiHsXuKHr%7EVH1bXikTODkpvjFYeXJdUn31rmaZvHTlMC7ibILDXd%7EfSr6pwh2IawaTTeCKU1H9A-D-15O0Zlpo-tV87xzlhGxcCKDyPCbMY2TsAhi57Zw6Hx5w%7EPCHBKvIFUJ9q%7Ec1%7EPqWwShmPD-Jo-4N47ftzQ__&Key-Pair-Id=KQOSYIR44AIC0","duration":347.935,"title":"MiniDatabase: Crash-Safe, Zero-Dependency Engine","description":"This 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."}