Ruby on Rails + SQLite with Stephen Margheim

Описание: 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 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 Stephen:
Stephen on Twitter:   / fractaledmind  
Stephen's blog: https://fractaledmind.github.io/
Stephen's book: https://fractaledmind.gumroad.com/l/s...

Featured in this episode:
Database school on YouTube:    • Database School  
Database school audio only: https://databaseschool.com
Aaron's conference talk:    • Aaron Francis "Publishing Your Work" - Lar...  

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