during triage of a bug (Bug #26939: ActiveRecord::ValueTooLong: PG::StringDataRightTruncation: ERROR: value too long for type character varying(255) - Foreman) I realized that to fix the issue MySQL version 5.0 or newer must be installer. However we do not say which minimum SQL server versions Foreman require. I think until now our strategy was to assume that users are installing embedded databases which ship with OS which we support. That’s probably not always the case, some users might even configure Foreman with external databases which can often be provided as a service.
Do we want to specify minimum RDBM requirements? Once we do that, it is probably worth looking on what these new versions can offer and optimize our schema a bit (new index types, larger values or limits).
Or do we want to open the “let’s drop MySQL and SQLite” topic again?