"System & Machine" column should display sw version number(s)

[DBguru]

Currently it only shows SW name (i.e. ClickHouse or DuckDB etc.) but no version information whatsoever - which is insufficient from a usability point of view (especially for a performance results site as newer sw versions often improve average performance).

[alexey-milovidov]

The version is always the latest at the moment of the test.

[DBguru]

The version is always the latest at the moment of the test.

That's good to know but it's not much help for most of the ClickBench users from a usability point of view because:

1. currently each test date need to be looked up at github.com
2. then that test date need to be translated (in a DB-specific manner) to a version number somewhere else.

Adding "SELECT version();" or something very similar to the tests script(s) and then saving and displaying that output in the System column will save a lot of ClickBench users time.

[rschu1ze]

I think we can simply add the version to the database name.

[rschu1ze]

I think we can simply add the version to the database name.

As an extra complication, a lot of ClickBench submissions pull the Docker images with the "latest" tag. If we simply add the version to the database name we'd have the same problem as before (besides the effort to maintain the version manually).

A better approach is to do what @DBguru suggested:

Adding "SELECT version();" or something very similar to the tests script(s) and then saving and displaying that output in the System column will save a lot of ClickBench users time.

[alexey-milovidov]

I'd like it if we save the machine image just after the installation of the system. In this way, we can keep the archive of historical systems that are no longer accessible.