latest_contributors_clickhouse.md

diff -u <(docker run --rm clickhouse/clickhouse-server:23.12 clickhouse-local --query "SELECT * FROM system.contributors ORDER BY name") <(docker run --rm clickhouse/clickhouse-server:24.1 clickhouse-local --query "SELECT * FROM system.contributors ORDER BY name") | grep -E "^\+" | tail -n +2 | sed 's/^\+//' | tr '\n' ','

This is very elegant.

I tend to do it in a "clickhouse-local" way as follows:

Prior Release: sudo docker run --rm clickhouse/clickhouse-server:24.3 clickhouse-local --query "SELECT * FROM system.contributors ORDER BY name" > contributors_24.3.txt

Current Release: sudo docker run --rm clickhouse/clickhouse-server:24.4 clickhouse-local --query "SELECT * FROM system.contributors ORDER BY name" > contributors_24.4.txt

Comparing the two using ClickHouse Local:

./clickhouse local --query " SELECT arrayStringConcat(groupArray(line), ', ') FROM file('contributors_24.4.txt', LineAsString) WHERE line NOT IN ( SELECT * FROM file('contributors_24.3.txt', LineAsString)) FORMAT TSVRaw"