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 your free SQLite reference guide: https://highperformancesqlite.com/pro... Follow Aaron: Twitter:   / aarondfrancis   LinkedIn:   / aarondfrancis   Website: https://aaronfrancis.com - find articles, podcasts, courses, and more. Follow Kent: Twitter:   / 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:    • Database School   Database school audio only: https://databaseschool.com 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