From PostgreSQL to SQLite in Rails: Our Migration Journey, Challenges, and Lasting Trade-Offs
Wojtek Wrona
SQLite's growing popularity in production has caught many developers' attention - especially with recent Rails enhancements that make it a more viable option. But beyond the buzz, what does it take to migrate an existing Rails app from PostgreSQL, and what trade-offs do you end up living with? In this talk, Wojtek will share his real-world experience of migrating a production Rails application to SQLite. He will cover the incremental migration process and discuss the challenges he encountered during the transition - such as dealing with differences in built-in features, handling data migration complexities, and adapting to a non-ephemeral server deployment. He will also address some ongoing post-migration quirks that you'll need to accept. Whether you're drawn to the promise of a simpler, more cost-effective setup or are cautious about potential compromises, you'll leave with clear, actionable insights to help guide your decision.