Sort hosts page by lowercase host name? #318

New Issue

2025-12-02T23:31:17Z

davmo commented

2025-12-02 23:31:17 +00:00

The Correspondents page is sorted by the names of the hosts. This a sort that separates names which begin with capital letters from those that use lower case.

Thus (hypothetical) hosts Albert and arthur are not adjacent.

This is potentially confusing when looking up a given host by scrolling down the page.

Suggestion is to use ORDER BY lower(host) in the query.

The [Correspondents page](https://hackerpublicradio.org/correspondents/index.html) is sorted by the names of the hosts. This a sort that separates names which begin with capital letters from those that use lower case. Thus (hypothetical) hosts *Albert* and *arthur* are not adjacent. This is potentially confusing when looking up a given host by scrolling down the page. Suggestion is to use `ORDER BY lower(host)` in the query.

👍 1

rho_n commented

2025-12-07 03:42:53 +00:00

Merged to main

[Merged to main](https://repo.anhonesthost.net/HPR/hpr_generator/commit/611a022aabd2f49cc76152c3af957626f42b271e)

rho_n closed this issue

2025-12-07 03:42:53 +00:00

Sign in to join this conversation.