I’ve noted how difficult it is to get a complete list of parameters that can be used in the Rails’ config.database.yml file. I understand this is because there are different parameters for the different library layers. Still, I would like a more complete list somewhere, especially given that the parameter names can be confusingly similar but different between adapters (eg: timeout, connection_timeout, login_timeout, connect_timeout) For PG the disparate parameters can be found here:

• ActiveRecord::ConnectionAdapters::ConnectionPool – as far as I know this is consistent across all ActiveRecord adapters. (connection_timeout)
• ActiveRecord::ConnectionAdapters::PostgreSQLAdapter
• libpq Parameter Key Words – (connect_timeout)

I may create similar list for SQL Server.