Database School cover image

Database School

Latest episodes

undefined
13 snips
Nov 26, 2024 • 1h 9min

Moving from Redis to SQLite with Mike Buckbee

Mike Buckbee, co-founder of Wafris and an expert in cybersecurity, discusses his transition from Redis to SQLite for web application firewalls. He shares challenges faced in managing security and architecture, emphasizing the enhanced performance and usability gained through SQLite. The conversation highlights SQL's advantages over JSON, addressing operational challenges and how Wafris effectively handles IP data. Buckbee also reflects on Wafris' dual architecture, operational efficiencies, and the importance of community engagement in cybersecurity.
undefined
Oct 14, 2024 • 1h 22min

Bootstrapping an email service provider (with Jesse Hanley)

Jesse Hanley, founder of Bento, shares insights from running a lean email service provider in Japan. He discusses the innovative use of Discord for customer support, emphasizing its efficiency and community-driven feedback. Jesse dives into the challenges of scaling infrastructure, managing databases, and maintaining calm in a competitive landscape. He also explores the journey of bootstrapping Bento and highlights the importance of personal relationships in growing a business. A must-listen for aspiring entrepreneurs!
undefined
Oct 7, 2024 • 1h 1min

Creating a Postgres platform with Monica & Tudor from Xata.io

Monica Sarbu, founder of Xata.io, and Tudor Golubenco, the CTO, share their journey from Elastic to launching Xata, a Postgres database platform. They discuss the challenges of schema management and the innovations behind their free tier, which supports both developers and nonprofits. The duo also explores how user-friendly database solutions can empower underrepresented groups in tech and the significance of their open-source roots in shaping Xata's mission.
undefined
Sep 24, 2024 • 1h 3min

Heroku's glory days & Postgres vs the world, w/ Craig Kerstiens

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.
undefined
Aug 8, 2024 • 1h 43min

Ruby on Rails + SQLite with Stephen Margheim

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.
undefined
12 snips
Jun 20, 2024 • 52min

Migrating from Postgres to SQLite with Kent C. Dodds

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!
undefined
17 snips
Jun 14, 2024 • 1h 41min

Production SQLite with Turso and libSQL

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.
undefined
Jun 13, 2024 • 1h 27min

Offline-first, multiplayer SQLite

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.
undefined
13 snips
Jun 13, 2024 • 58min

Distributed SQLite with Litestream and LiteFS

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.
undefined
8 snips
Jun 13, 2024 • 54min

DHH discusses SQLite (and Stoicism)

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.

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode