v.23.2Improvement
Add Connection Settings Override Feature for ClickHouse Client
Add ability to override connection settings based on connection names (that said that now you can forget about storing password for each connection, you can simply put everything into ~/.clickhouse-client/config.xml and even use different history files for them, which can be also useful). #45715 (Azat Khuzhin).Why it matters
This feature eliminates the need to store passwords and other settings separately for each connection. Users can now consolidate all connection configurations inside~/.clickhouse-client/config.xml, improving security and ease of use. Additionally, it supports using different history files for different connections, enhancing usability and organization.How to use it
Users can define connection-specific settings within the~/.clickhouse-client/config.xml file by specifying different connection names and their corresponding parameters. This allows the clickhouse-client to apply the appropriate configurations automatically when connecting. Different history files can also be set per connection to keep command histories separate.