Database School

Craig Kerstiens, an expert from Crunchy Data specializing in Postgres, dives into the rise and importance of Postgres, particularly during its glory days at Heroku. He shares insights on scaling databases and the innovative 'data clips' feature that bridges technical and non-technical teams. The conversation touches on the evolution of Postgres and its extension ecosystem, highlighting challenges like database sharding. Craig also discusses future trends and the unique strengths of Postgres compared to competitors like DuckDB.

In this lively discussion, Stephen Margheim, a professional developer with a unique background in classical studies, shares his journey from academia to mastering Ruby on Rails and SQLite. He emphasizes the importance of operational simplicity in tech, optimizing SQLite for better performance, and the value of community collaboration. Stephen also delves into multi-threading challenges and innovative strategies to enhance database access. His insights offer a mix of practical advice and inspiration for both novice and experienced developers.

In this enlightening discussion, Kent C. Dodds, a key figure in the React community and creator of the Epic Stack, shares his expertise on migrating from Postgres to SQLite. Kent highlights the simplicity and efficiency of using SQLite to solve common database challenges, balancing tech projects with family life. He dives into performance management with Lightstream and LiteFS, emphasizes enhancing user experience, and explores the future of educational podcasts. Tune in for valuable insights into modern web infrastructure!

Glauber Costa, CEO of Turso, discusses the journey from a database enthusiast to CEO, forking SQLite to build a community, developing libSQL for serverless environments, implementing vector search embedding for AI, and future plans for libSQL and Turso.

Carl Sverre, developer of SQLSync, discusses event sourcing, conflict resolution, VFSes, and more in the podcast. They cover multiplayer SQLite, durable objects, local-first approach, conflict resolution as business logic, and the future goals for SQLSync.

Ben and Aaron delve into replication and backups in SQLite, Litestream, and LiteFS. They discuss building LiteFS, enhancing SQLite functionality, and replicating data in distributed systems. The podcast highlights the simplicity and efficiency of these tools, emphasizing their speed and reliability.

DHH, co-founder of Basecamp and creator of Ruby on Rails, discusses the evolution and viability of SQLite for multi-user setups, embracing simplicity in software development, and implementing SQLite as a backend for caching and queuing in Rails applications. The conversation also includes insights on stoicism, conceptual compression, and the new product Workbook by ONCE.com.