Production SQLite with Turso and libSQL

Want to learn more SQLite? Check out the full course: https://highperformancesqlite.com. In this interview, we dive deep into the fascinating journey of Glauber Costa, the CEO of Turso, as he shares insights into forking SQLite into libSQL, the challenges faced, and the innovative developments in the world of database technology. We also explore the introduction of vector search capabilities in libSQL and discuss the future of database systems in the AI era. Get production ready SQLite with Turso: https://tur.so/af. Follow Aaron: Twitter: https://twitter.com/aarondfrancis LinkedIn: https://www.linkedin.com/in/aarondfrancis Website: https://aaronfrancis.com - find articles, podcasts, courses, and more. Follow Glauber: Twitter: https://twitter.com/glcst Turso: https://tur.so/af Featured in this episode: libSQL: https://github.com/tursodatabase/libsql Database school on YouTube: https://www.youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15 Database school audio only: https://databaseschool.transistor.fm/ Chapters: 00:00 - Guest Introduction: Glauber Costa, CEO of Turso 02:02 - Glauber's Journey from Red Hat to Scylla 04:50 - The Unorthodox Path to Databases 07:20 - Founding Turso and the Shift from ChiselStrike 10:13 - Forking SQLite: The Birth of libSQL 14:00 - Challenges and Decisions in Forking SQLite 17:21 - The Importance of Community in Open Source Projects 20:50 - Creating User-Defined Functions with WebAssembly 22:57 - Introducing Native Replication in libSQL 28:03 - How Native Replication Works 32:43 - Implementing the HTTP Protocol for SQLite 36:19 - Server to Server Replication Explained 39:07 - Embedded Replicas: A Game-Changer for Local Reads 44:23 - Using Turso in Serverless Environments 49:25 - Introducing Vector Search in libSQL 53:14 - The Development Process of Vector Search 57:50 - What’s Next for libSQL and Turso? 01:01:45 - How to Follow Glauber Costa on Twitter