Migrating from Postgres to SQLite with Kent C. Dodds

Want to learn more SQLite? Check out the full course: https://highperformancesqlite.com. In this episode of Database School, I interview Kent C. Dodds about his journey migrating from Postgres to SQLite with LightFS, simplifying his infrastructure while maintaining global performance. They dive deep into technical challenges, the benefits of SQLite, and how these experiences are shaping the development of the Epic Stack. 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 Kent: Twitter: https://twitter.com/kentcdodds EpicWeb: https://www.epicweb.dev The Epic Stack: https://www.epicweb.dev/epic-stack Featured in this episode: Fly.io: https://fly.io LiteFS: https://fly.io/docs/litefs Litestream: https://litestream.io Database school on YouTube: https://www.youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15 Database school audio only: https://databaseschool.transistor.fm/ Chapters: 00:00 - Introduction to Database School 00:33 - Introducing Kent C. Dodds 01:14 - Kent's Background and Experience 02:25 - Family Life and Work Balance 03:30 - The Reason for the Interview: Migrating from Postgres to SQLite 06:03 - Challenges with Postgres and Redis on Fly.io 07:36 - Choosing SQLite and LightFS for Simplicity 23:39 - Implementing LightFS on Fly.io 31:03 - The Role of Console in Managing Primary Instances 40:03 - Handling Write Requests Across Multiple Regions 42:53 - Sticky Sessions and High-Water Marks Strategy 48:25 - LightFS Built-In Features and Kent's Contributions 50:16 - Discussion on the Epic Stack 56:59 - Conclusion and Final Thoughts