We had discussed dropping support for SQLite before (e.g. RFC: Dropping support for sqlite) and the main reasoning for keeping it was for development and build tasks. However we have never officially notified users that they shouldn’t be using it in a production environment. The expectation, however, is that most likely the number of users actually using it is very low to none, since the installer installs PostgreSQL by default and SQLite doesn’t quite scale.
Running SQLite in production is generally a Bad Idea , and we should let users know about that. This becomes more acute since upgrading to Rails 6 will require us to perform a change in how boolean fields are stored in the database, which is very problematic to perform as part of a migration.
My proposal is therefor to do the following:
- in 1.24 show a notification for any user running SQLite in production, similar to the notification we have for MySQL.
- in 1.25 stop supporting it officially for non-development usage.
With 1.24 already in RC stage, I would like to come to a decision on this before RC3 is out.