Want to learn more about SQLite? Check out the full course: https://highperformancesqlite.com/
In this episode of Database School, I sit down with Stephen Margheim, a Rails and SQLite expert, to explore his unique journey from academia to software development. We dive deep into the challenges and solutions he encountered while optimizing SQLite for Rails, including his work on reducing database locked errors and improving performance for production environments.
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 Stephen:
Stephen on Twitter: https://twitter.com/fractaledmind
Stephen's blog: https://fractaledmind.github.io/
Stephen's book: https://fractaledmind.gumroad.com/l/sqlite-on-rails
Featured in this episode:
Database school on YouTube: https://www.youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15
Database school audio only: https://databaseschool.transistor.fm/
Aaron's conference talk: https://www.youtube.com/watch?v=2YaEtaXYVtI
Chapters:
00:00 Introduction to Database School
00:22 Meet Stephen Marg: Rails and SQLite Guru
01:12 Stephen's Journey: From Academia to Rails
03:00 Discovering Rails: A Non-Traditional Path
07:04 Why SQLite? Stephen’s Perspective
10:18 Rails and SQLite: The Perfect Pairing
13:41 The Importance of Operational Simplicity
19:43 Overcoming SQLite Challenges in Rails
30:00 The Future of Rails with SQLite
36:02 Stephen’s Passion for Writing and Community
41:01 Technical Deep Dive: SQLite's Busy Handler
55:14 Solving the Backoff Problem in SQLite
01:10:58 Future Goals: Simplifying Deployment and Zero Downtime Migrations
01:20:11 Final Thoughts