4 SQLite Databases: Is Rails 8 Taking SQLite Too Far?

DHH announced Rails 8 adding a lot of support for SQLite at Rails World 2024, which motivated me to give it a shot. I migrated one of our Rails 7 apps to Rails 8, migrated from Postgres to SQLite, and migrated to the solid {queue,cache,cable} stack, which is based off SQLite, too. SQLite databases would feel less magical. The crazy thing now with the “SQLite Stack” is that I now can skip Docker entirely. There are beginner-friendly UI-based tools like DB Browser for SQLite which make SQLite databases feel almost as accessible as.. spreadsheets.