Stephen, an American living in Berlin, Germany, discusses why SQLite can be a great choice for production web applications in his presentation. He highlights SQLite’s simplicity, control, and speed, dispelling the myth that it’s not fast enough. Stephen details the process of deploying a SQLite on Rails application using hosting providers like Hatchbox, showcasing how easy and affordable it can be. He introduces the Enhanced Adapter gem to enhance SQLite databases, improve concurrency handling, and support features not yet available in Rails core. By sharing his experience and insights, Stephen aims to challenge the belief that SQLite isn’t suitable for production use, showcasing its potential for scalability and development ease.
https://fractaledmind.github.io/2023/12/23/rubyconftw/