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:   / 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.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