Exploring Turso with Glauber Costa: Insights on SQLite for Production In this episode of The GeekNarrator podcast, host Kaivalya Apte interviews Glauber Costa, founder and CEO of TursoDB. They discuss the inception of TursoDB, Glauber's background in Linux kernel development, and the journey from unikernel projects to founding a database company. Glauber explains TursoDB's enhancements to SQLite for production use, including native replication, schema management, and vector search capabilities. The conversation dives deep into use cases, architecture, and the benefits of a multi-tenant database design. Learn about TursoDB’s future plans and essential insights for developers. Chapters: 00:00 Introduction 05:05 The Birth of Turso 08:02 Challenges and Pivot to libSQL 17:12 SQLite for Production: Enhancements and Features 22:02 Replication and Backup Solutions 23:38 Enterprise-Level Features and Multi-Tenancy 25:55 User Experience and Simplicity of TursoDB 33:14 Handling Network Failures and Monitoring 36:35 Native Replication in SQLite 37:52 Virtualizing the Write-Ahead Log 39:20 Replication Mechanisms 41:31 Primary and Replica Dynamics 46:51 Multi-Tenancy and Scalability 53:33 Schema Changes and Migrations 58:51 Vector Search Capabilities 01:02:13 Future Roadmap and Features If you like this episode, please hit the like button and share it with your network. Also please subscribe if you haven't yet. Database internals series: https://youtu.be/yV_Zp0Mi3xs Popular playlists: Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA- Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17 Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_d Modern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsN Stay Curios! Keep Learning! #distributedsystems #databases #sqlite #sql