The Ruby on Rails Podcast
Episode 507: Stephen Margheim on SQLite in Ruby on Rails Applications
Show notes
If you start a new Rails project today, you’re probably going to pick Postgres for your database. And if you have a ten year old Rails app, you might be using MySQL. But Rails ships with support for SQLite, a lightweight SQL database. Can that lightweight database be used to make production-ready software? Stephen Margheim joins the show to help us answer that question.
Show Notes
Stephen's blog post about SQLite - https://blog.wesleyac.com/posts/consider-sqlite
Stephen's website fractaledmind.github.io
You can find Stephen on Twitter or Mastodon @fractaledmind.
pd_loader - https://pgloader.io/
Sponsors
Honeybadger
As an Engineering Manager or an engineer, too much of your time gets sucked up with downtime issues, troubleshooting, and error tracking. How can you spend more time shipping code and less time putting out fires?
Honeybadger is how. It’s a suite of monitoring tools specifically for devs.
Get started today in as little as 5 minutes at Honeybadger.io with plans starting at free!
More from The Ruby on Rails Podcast
All 550 episodes- Episode 552: Hatchbox and GoRails in the age of AI with Chris Oliver and Collin Jilbert Sep 16, 2026
- Episode 551: Practical Hotwire with Jeremy Smith Sep 09, 2026
- Episode 550: XORuby with Jim Remsik Sep 02, 2026
- Episode 549: ChicagoRuby with Anton Tkachov and Michelle Yuen Aug 26, 2026
- Episode 548: MCP + Generators with Andy Andrea and Rachael Wright-Munn Aug 19, 2026
Published by The Ruby on Rails Podcast